{"id":54173,"date":"2019-05-11T14:52:09","date_gmt":"2019-05-11T09:22:09","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=54173"},"modified":"2021-12-04T13:09:41","modified_gmt":"2021-12-04T07:39:41","slug":"connect-design-studio-to-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/","title":{"rendered":"How to Connect Design Studio to SAP HANA – Easy Step-by-Step Instructions"},"content":{"rendered":"

After creating dashboards in SAP HANA<\/strong>, we will move to connect SAP Design Studio to the SAP HANA database. We have provided a step-by-step account of making a connection from Design Studio to SAP HANA. The steps are very easy to implement and you will not face any issue in the process.<\/p>\n

Let’s start by a short explanation on SAP BusinessObjects Design Studio.<\/p>\n

SAP BusinessObjects Design Studio<\/h3>\n

SAP BusinessObjects Design Studio is a dashboard designing tool that enables business users to create interactive reporting applications and dashboards.<\/p>\n

It is an advanced level designing tool that connects to the SAP HANA database using a BICS connection<\/strong> communicating through SQLDBC language.<\/strong><\/p>\n

The tool requires complete compatibility and support with SAP NetWeaver BW<\/strong> and SAP HANA platforms. It also provides the capability to do server-side programming.<\/p>\n

How to Connect Design Studio to SAP HANA?<\/h3>\n

Here, we will learn the steps to connect Design Studio to SAP HANA:<\/p>\n

Step 1:<\/strong> Open the SAP BusinessObjects Design Studio.<\/strong><\/p>\n

Step 2:<\/strong> Click on Tools<\/strong> then select Preferences.<\/strong><\/p>\n

Step 3:<\/strong> A dialog box with the name Preferences will open. On the left of this dialog box, you will see two options; Application Design<\/strong> and Scripting<\/strong>. Expand the Application Design<\/strong> node, select Backend Connections.<\/strong><\/p>\n

The information related to backend connections will appear on the right half of the dialog box. The bottom two sections are named \u201cSAP HANA Connections (maintained in ODBC Data Source Administrator)\u201d<\/strong> and \u201cSAP HANA Connections (HTTP)\u201d.<\/strong><\/p>\n

These two sections show the details of ODBC and HTTP connections made to SAP HANA.<\/p>\n

Step 4:<\/strong> We will go by creating an ODBC connection <\/strong>(for instance). To create an OBDC connection to connect to SAP HANA, click on the icon present on the right of SAP HANA Connections (maintained in ODBC Data Source Administrator)<\/strong> section. It will launch the ODBC Data Source Administrator.<\/p>\n

Step 5:<\/strong> A dialog box \u201cODBC Data Source Administrator\u201d<\/strong> will open. Select the\u00a0HANAODBC<\/strong> from the list of system data sources and click on Add<\/strong>.<\/p>\n

Click on OK<\/strong> to go to the next step.<\/p>\n

Step 6:\u00a0<\/strong> From the dialog <\/span>Create New Data Source<\/b> select the connection driver of your choice (i.e. the driver that connects to the data source). Click on <\/span>Finish<\/b>. <\/span><\/p>\n

Step 7:<\/strong> Enter connection details<\/strong> such as Data source name, Description, and Sever: Port<\/strong> information. Click on Connect<\/strong>.<\/p>\n

Next, enter the HANA system Username and Password<\/strong> then click on OK<\/strong>. The connection will be successfully made.<\/p>\n

Step 8:\u00a0<\/strong>The name and other details like description, host and port number of the newly created ODBC connection will appear in the SAP HANA Connections (maintained in ODBC Data Source Administrator)<\/strong> section.<\/p>\n

Now, to use this connection to create analytical applications, click on the connection name from the panel and click OK<\/strong>.\u00a0 The connection to SAP HANA will be made instantly.<\/p>\n

Step 9:<\/strong> You can create a new analytic application from here\u00a0using the data from the connected SAP HANA database. Click on \u201cCreate Analysis Application\u201d<\/strong> on the main page of SAP Design Studio under the Create New<\/strong> section.<\/p>\n

Summary<\/h3>\n

This was all you need to know about the process to connect SAP Design Studio to the SAP HANA database. After making the connection, you can start with creating analytic applications on Design Studio using data fetched from the HANA system.<\/p>\n

Now, have you understood the process to connect the design studio to SAP HANA? If any queries, simply enter in the comments section.<\/p>\n","protected":false},"excerpt":{"rendered":"

After creating dashboards in SAP HANA, we will move to connect SAP Design Studio to the SAP HANA database. We have provided a step-by-step account of making a connection from Design Studio to SAP...<\/p>\n","protected":false},"author":6,"featured_media":54207,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19519,19520],"class_list":["post-54173","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-connect-design-studio-to-sap-hana","tag-sap-businessobjects-design-studio"],"yoast_head":"\nHow to Connect Design Studio to SAP HANA - Easy Step-by-Step Instructions - DataFlair<\/title>\n<meta name=\"description\" content=\"Want to know, how to connect SAP Design Studio to SAP HANA database? Check easy step-by-step instructions to implement in SAP BusinessObjects Design Studio.\" \/>\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\/connect-design-studio-to-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect Design Studio to SAP HANA - Easy Step-by-Step Instructions - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Want to know, how to connect SAP Design Studio to SAP HANA database? Check easy step-by-step instructions to implement in SAP BusinessObjects Design Studio.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-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-11T09:22:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:39:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Connecting-Design-Studio-to-SAP-HANA.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2500\" \/>\n\t<meta property=\"og:image:height\" content=\"1308\" \/>\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=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Connect Design Studio to SAP HANA - Easy Step-by-Step Instructions - DataFlair","description":"Want to know, how to connect SAP Design Studio to SAP HANA database? Check easy step-by-step instructions to implement in SAP BusinessObjects Design Studio.","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\/connect-design-studio-to-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"How to Connect Design Studio to SAP HANA - Easy Step-by-Step Instructions - DataFlair","og_description":"Want to know, how to connect SAP Design Studio to SAP HANA database? Check easy step-by-step instructions to implement in SAP BusinessObjects Design Studio.","og_url":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-11T09:22:09+00:00","article_modified_time":"2021-12-04T07:39:41+00:00","og_image":[{"width":2500,"height":1308,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Connecting-Design-Studio-to-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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"How to Connect Design Studio to SAP HANA – Easy Step-by-Step Instructions","datePublished":"2019-05-11T09:22:09+00:00","dateModified":"2021-12-04T07:39:41+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/"},"wordCount":573,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Connecting-Design-Studio-to-SAP-HANA.jpg","keywords":["Connect Design Studio to SAP HANA","SAP BusinessObjects Design Studio"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/","name":"How to Connect Design Studio to SAP HANA - Easy Step-by-Step Instructions - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Connecting-Design-Studio-to-SAP-HANA.jpg","datePublished":"2019-05-11T09:22:09+00:00","dateModified":"2021-12-04T07:39:41+00:00","description":"Want to know, how to connect SAP Design Studio to SAP HANA database? Check easy step-by-step instructions to implement in SAP BusinessObjects Design Studio.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Connecting-Design-Studio-to-SAP-HANA.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Connecting-Design-Studio-to-SAP-HANA.jpg","width":2500,"height":1308,"caption":"Connecting Design Studio to SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/connect-design-studio-to-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":"How to Connect Design Studio to SAP HANA – Easy Step-by-Step Instructions"}]},{"@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\/54173","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=54173"}],"version-history":[{"count":13,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54173\/revisions"}],"predecessor-version":[{"id":104915,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54173\/revisions\/104915"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/54207"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=54173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=54173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=54173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}