{"id":53883,"date":"2019-05-09T14:15:57","date_gmt":"2019-05-09T08:45:57","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53883"},"modified":"2021-12-04T13:12:18","modified_gmt":"2021-12-04T07:42:18","slug":"create-relational-connection-in-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/","title":{"rendered":"Create Relational Connection in SAP HANA in 8 Steps – Most Awaited Tutorial"},"content":{"rendered":"

Previously, we have learned SAP BusinessObjects Reporting Tools<\/strong>, now, let’s learn about a new process that is creating a relational connection in SAP HANA. We will start with understanding what is a relational connection and then move on to learn how to create a relational connection in SAP HANA.<\/p>\n

We will firstly discuss, what is exactly a relational connection.<\/p>\n

Relational Connection in SAP HANA<\/h3>\n

A relational connection is an indirect way of connecting to the SAP HANA database. The reporting tools that cannot connect directly to the SAP HANA database, consumes data from the data foundations present in the data universes.<\/p>\n

Therefore, the data universes are connected to the SAP HANA database via relational connections.<\/p>\n

These connections establish using JDBC\/ODBC connection drivers. Reporting tools like Web Intelligence and Dashboard Designer<\/strong> use a relational connection to connect to SAP HANA.<\/p>\n

Once a reporting tool is connected to the SAP HANA database via a relational connection, it is saved in the repository for further use. The user can then use data from SAP HANA to create the data foundation for your universe layer.<\/p>\n

How to Create Relational Connection in SAP HANA?<\/h3>\n

 <\/p>\n

In this section, we will learn how to create or establish a relational connection in SAP HANA. Here, we are making a connection through the\u00a0Information Design Tool (IDT).<\/strong><\/p>\n

You can start creating a relational connection with the SAP HANA database after creating a new project in IDT.<\/p>\n

The steps to create a relational connection are given below:<\/p>\n

Step 1:\u00a0Information Design Tool<\/strong><\/p>\n

Open the Information Design Tool’s main page. Right-click on the project name under Local Projects<\/strong> tab.<\/p>\n

Select New<\/strong> and then select Relational Connection.<\/strong><\/p>\n

Step 2: Resource Name<\/strong><\/p>\n

Enter the name of the connection in Resource Name<\/strong> option and click Next<\/strong>. For instance, we have entered the name SAP_HANA.\u00a0You can also add a description of the connection in the Description box given.<\/p>\n

Step 3: Database Middleware Driver Selection<\/strong><\/p>\n

Next, we will select the SAP HANA database driver<\/strong>. In the \u201cDatabase Middleware Driver Selection\u201d dialog, select the SAP option.<\/strong><\/p>\n

Then, expand the SAP HANA database 1.0<\/strong> driver list.<\/p>\n

Select JDBC driver<\/strong> as the connection driver. Click Next.<\/strong><\/p>\n

Step 4: Parameters for SAP HANA database 1.0 Connection<\/strong><\/p>\n

Enter the SAP HANA database user information; Authentication Mode, User Name, Password, and Server (host:port) details. Also, you can select from a list of Authentication Modes.<\/p>\n

You can also test the connection by clicking on Test Connection<\/strong>. A message will prompt confirming the successful connection if the connection is correct.<\/p>\n

Click on Next><\/strong> to continue.<\/p>\n

Step 5: Database Specific Parameters<\/strong><\/p>\n

Next, we will have to enter database specific parameters such as Connection Pool Mode, Pool Timeout, Array Fetch Size, Array Bind Size, Login Timeout, JDBC Driver properties, etc. Click Finish<\/strong> after entering all the details.<\/p>\n

The Array Fetch Size<\/strong> number decides how many lines will be fetched from the database in each trip until the full data set is fetched.<\/p>\n

If you need faster data retrieval from the database, set the array fetch size<\/strong> to 1000 (maximum value). But do make sure that the client tool has enough memory. The default value\u00a0<\/strong>is 10<\/strong>.<\/p>\n

Step 6: Connection Configuration & Details<\/strong><\/p>\n

The connection is successfully created. You can check the connection configurations in the tab present on the screen. The connection parameter screen will also have a General section<\/strong> and a Login Parameter section.<\/strong><\/p>\n

You will have the following information regarding the newly created relational connection.<\/p>\n

    \n
  • Authentication Mode<\/li>\n
  • User Name<\/li>\n
  • Password<\/li>\n
  • Sever(host:port)<\/li>\n
  • Connection Pool Mode<\/li>\n
  • Pool Timeout<\/li>\n
  • Array Fetch Size<\/li>\n
  • Array Bind Size<\/li>\n
  • Login Timeout<\/li>\n
  • JDBC Driver Properties<\/li>\n<\/ul>\n

    Step 7: Publish in BO Repository<\/strong><\/p>\n

    Now, for the users to use this connection from universe designers, we need to publish this connection in the BO repository<\/strong> and create a shortcut.<\/p>\n

    To publish the connection we just created, right-click on the connection name<\/strong>. The new connection is shown under your project name in the Local Projects<\/strong> tab. Then select Publish Connection to a Repository<\/strong> option.<\/p>\n

    Step 8: .cnx File to Prohibit Users<\/strong><\/p>\n

    This will publish a secured repository connection under the project tab with .cns<\/strong> extension. Along with this, a .cnx<\/strong> file will also be created which is a local unsecured connection prohibiting the users to publish anything in the repository.<\/p>\n

    Summary<\/h3>\n

    This is how we create a relational connection with the SAP HANA system using IDT. The business users can connect to the SAP HANA database from reporting tools using these connection shortcuts.<\/p>\n

    Users also use these connections to create a data foundation for universe layer fetching data from the SAP HANA database.<\/p>\n

    We hope you liked our explanation. Stay with us as we move on to learn more exciting things about SAP HANA reporting and SAP HANA technology in general.<\/p>\n

    If you have come across with any queries or have any feedback for us, just enter in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Previously, we have learned SAP BusinessObjects Reporting Tools, now, let’s learn about a new process that is creating a relational connection in SAP HANA. We will start with understanding what is a relational connection...<\/p>\n","protected":false},"author":6,"featured_media":53969,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19474,19473],"class_list":["post-53883","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-create-relational-connection","tag-relational-connection-in-sap-hana"],"yoast_head":"\nCreate Relational Connection in SAP HANA in 8 Steps - Most Awaited Tutorial - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn what is relational connection in SAP HANA and steps to create relational connection in SAP HANA database through IDT. Learn for free!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Relational Connection in SAP HANA in 8 Steps - Most Awaited Tutorial - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn what is relational connection in SAP HANA and steps to create relational connection in SAP HANA database through IDT. Learn for free!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-09T08:45:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:42:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-Relational-Connection-in-SAP-HANA.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1201\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Relational Connection in SAP HANA in 8 Steps - Most Awaited Tutorial - DataFlair","description":"Learn what is relational connection in SAP HANA and steps to create relational connection in SAP HANA database through IDT. Learn for free!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Create Relational Connection in SAP HANA in 8 Steps - Most Awaited Tutorial - DataFlair","og_description":"Learn what is relational connection in SAP HANA and steps to create relational connection in SAP HANA database through IDT. Learn for free!","og_url":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-09T08:45:57+00:00","article_modified_time":"2021-12-04T07:42:18+00:00","og_image":[{"width":1201,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-Relational-Connection-in-SAP-HANA.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Create Relational Connection in SAP HANA in 8 Steps – Most Awaited Tutorial","datePublished":"2019-05-09T08:45:57+00:00","dateModified":"2021-12-04T07:42:18+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/"},"wordCount":815,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-Relational-Connection-in-SAP-HANA.jpg","keywords":["Create Relational Connection","Relational Connection in SAP HANA"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/","name":"Create Relational Connection in SAP HANA in 8 Steps - Most Awaited Tutorial - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-Relational-Connection-in-SAP-HANA.jpg","datePublished":"2019-05-09T08:45:57+00:00","dateModified":"2021-12-04T07:42:18+00:00","description":"Learn what is relational connection in SAP HANA and steps to create relational connection in SAP HANA database through IDT. Learn for free!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-Relational-Connection-in-SAP-HANA.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-Relational-Connection-in-SAP-HANA.jpg","width":1201,"height":628,"caption":"Steps to Create Relational Connection in SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/create-relational-connection-in-sap-hana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"Create Relational Connection in SAP HANA in 8 Steps – Most Awaited Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=53883"}],"version-history":[{"count":19,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53883\/revisions"}],"predecessor-version":[{"id":104922,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53883\/revisions\/104922"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/53969"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}