{"id":32,"date":"2018-09-30T10:14:00","date_gmt":"2018-09-30T08:14:00","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/2018\/09\/30\/what-is-sap-hana-beginners-tutorial-2\/"},"modified":"2020-08-22T14:29:38","modified_gmt":"2020-08-22T12:29:38","slug":"what-is-sap-hana-beginners-tutorial-2","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/what-is-sap-hana-beginners-tutorial-2\/","title":{"rendered":"What is SAP HANA &#8211; Beginners Tutorial 2"},"content":{"rendered":"<p>In<a href=\"http:\/\/kindsonthegenius.blogspot.com\/2018\/09\/what-heck-is-sap-hana-beginners.html\" target=\"_blank\" rel=\"noopener\"> Tutorial 1<\/a> we gave an introduction to SAP HANA and described the architecture of SAP HANA.<\/p>\n<p>In this <a href=\"http:\/\/kindsonthegenius.blogspot.com\/2018\/09\/what-heck-is-sap-hana-beginners.html\" target=\"_blank\" rel=\"noopener\">Tutorial 2<\/a>, we would go further to discuss other bits and pieces of SAP HANA as well as how you can.<\/p>\n<div style=\"clear: both; text-align: center;\"><\/div>\n<p>We would cover the following:<\/p>\n<ul>\n<li><a href=\"https:\/\/kindsonthegenius.com\/blog\/what-is-sap-hana-beginners-tutorial-2#t1\">Migrating Oracle to HANA<\/a><\/li>\n<li><a href=\"https:\/\/kindsonthegenius.com\/blog\/what-is-sap-hana-beginners-tutorial-2#t2\">Introduction to SAP HANA Studio<\/a><\/li>\n<\/ul>\n<div style=\"-webkit-text-stroke-width: 0px; background-color: transparent; color: #555555; font-family: Times New Roman; font-size: 18px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; line-height: 30px; orphans: 2; text-align: justify; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;\">\n<div style=\"font-family: &amp;quot;\">\n<div style=\"margin: 0px;\"><a href=\"https:\/\/youtu.be\/8CerRKvLQ1c\" target=\"_blank\" rel=\"noopener\">Watch the video tutorial here<\/a> and subscribe to get notified when new tutorials are made.<\/div>\n<\/div>\n<\/div>\n<p><b><\/b><i><\/i><u><\/u><br \/>\n<b><\/b><i><\/i><u><\/u><br \/>\n<b><\/b><\/p>\n<h3 id=\"t1\">Migrating Oracle to SAP HANA<\/h3>\n<p>Before SAP HANA, we have enterprise environments with Oracle backend connected to SAP Business Warehouse.<br \/>\nWith SAP HANA, three steps would be required to make a migration to SAP HANA as illustrated in Figure 1.<\/p>\n<p><b>Step 1<\/b>: Transform the Oracle database into SAP HANA using one of the methods described in Tutorial 1 (BODS, SLT, DXC etc)<br \/>\n<b>Step 2<\/b>: Upgrade existing SAP Business Warehouse to a version that has support for SAP HANA.<br \/>\n<b>Step 3:<\/b> Connect SAP HANA to upgraded Business Warehouse<\/p>\n<p>&nbsp;<\/p>\n<h3 id=\"t2\">Introduction to SAP HANA Studio<\/h3>\n<p>SAP HANA Studio is an Eclipe-based application development tool used for creating information models in SAP HANA.<br \/>\nIt Provides the following dedicated perspective roles:<\/p>\n<ul>\n<li>Administrative<\/li>\n<li>Modeller<\/li>\n<li>Development<\/li>\n<\/ul>\n<p><ins style=\"display: block; text-align: center;\" data-ad-layout=\"in-article\" data-ad-format=\"fluid\" data-ad-client=\"ca-pub-7041870931346451\" data-ad-slot=\"8227894917\"><\/ins><br \/>\nIn SAP HANA Studio, you would be working with table and view. You can also load a table from a csv or xls file or other data sources.<br \/>\nThe following views can be created using SAP HANA Studio:<\/p>\n<ul>\n<li>Analytic View<\/li>\n<li>Calculation View<\/li>\n<li>Attribute View<\/li>\n<\/ul>\n<p>We would then get into the a hands-on tutorial on working with SAP HANA Studio.<\/p>\n<p><a href=\"https:\/\/youtu.be\/8CerRKvLQ1c\" target=\"_blank\" rel=\"noopener\">Watch the video here<\/a> and subscribe to get notified when new tutorials are made.<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/8CerRKvLQ1c\" width=\"100%\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Tutorial 1 we gave an introduction to SAP HANA and described the architecture of SAP HANA. In this Tutorial 2, we would go further &hellip; <\/p>\n","protected":false},"author":2,"featured_media":468,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[583],"tags":[587],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/32"}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":5,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":1124,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/32\/revisions\/1124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media\/468"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}