Customer Article

Integrate CData Power BI Connector for SAP HANA with SAP Datasphere:

  • 25 June 2024
  • 0 replies
  • 29 views

Badge

 

This article covers required configuration of both SAP Datasphere and the CData Power BI Connector for SAP HANA, to make the two successfully integrated. The steps to accomplish this integration are listed below. 

 

Configuration of SAP Datasphere: 

  1. Login to your SAP Datasphere instance:
    https://<serverName>.us20.hcs.cloud.sap/dwaas-core/index.html#/home
     
  1. Navigate to ‘System’ –> ‘Configuration’ -> ‘Database Access’ 

AD_4nXcwtglfPG_rQ_58j_kIs16mddwzaGFNhKNN6aWffJyf7mv2n6gmXANKFivZ1u8niFRCPCddhOugm96dMEWDS9boKH305axS6ZfVDEQEyEa2he1jCV_sifqCZUKNqkXHuJPEiD0V8e_sE2t2bIo0ZWrTwfTb?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

 

  1. Click on ‘Create’ to create new User: 

AD_4nXdAX8ett7eFwmspXqqoqgzTJ0uYyADRcUUYcszc00sopN2kz8e2Fdu-GiN-uCkcbqlonSFiqJ6eJ8A3i1A3PJmsxMOA993FauUp67QfF5fKW1rwt1lc63QnDJRE_JLlKjiOgHeYrI9ImS86W7S08Qqp4t0?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

  1. Provide the ‘Database Analysis User Name’, and then check the ‘Enable Space Schema Access’ check box. Set ‘Database analysis user expires in’ to ‘Never’. 

AD_4nXeK5Gk-PfQNkGVW80XvduPeKIma0PSkRxVSDLH-LcHgRhMjkek0VtXPKMRYOsC1cCt4AgyIyUfhQr3wnF_hYzXGX0d5-3kqXc9J4JbQQUI6EtJEDSqTqb9Lo-z4HkIZ5qrgMrGyBaYmM0e6fT0mY6bsywhH?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

  1. Note the ‘Host Name’, ‘Port’, ‘Database Analysis User Name’ and ‘Password’ values: 

AD_4nXfzvbCil6LzZaH88WCJyigUf6jE7SaFSg_NliQY2niB49Ztf5h15TLFrLFnBcisUE-WdFmnVfHHFi8R_zsT5MR6DSkWBEnKtymOJMA-srwQwk_Hni910sMnNjm9fW8Al51klq7-Bu95Vol_p5ADScvYXA27?key=Z7V6CrtUkJZp5rPpYLNEsg

 

  1. Select the Database Analysis User and click on ‘Open Database Explorer’. This will open new window with SAP HANA Database connection. You can retrieve the previous values from this window as well: 

AD_4nXc0OfYmSSO4D1s1a1SBQJRMC7QxyiUUKpplelhU7XqRJ187bFg23mWOxLCPJsAqiP7f-iAcCKmVnVx9AV2ZN08HdgxY_aRT85kj8uxwVka6oJmDqtJfpEw6pw_1HX4ubVBpu2cf2yg0lYRoA98zRjokDNTN?key=Z7V6CrtUkJZp5rPpYLNEsg

 

AD_4nXc4DFU1uuzEOLMYDIL9TlB4ue8yG5yZHUprIPlyYlUW3BSoTLq-B_djTfQ3Q4eOrWujK20xy64iIxhuXnxhOaCnjjNxzAqRMLnFgdOg2q-LsGGupYQMhQyvrRjixgh-TZdHFnV_Ynd5aPDTwZHSRtIRtQr-?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

 

 

  1. Open the native HANA Studio and execute the following query to get underlaying database name. This value will be required to successfully configure the connection from the CData connector: 
    select "DATABASE_NAME" from M_DATABASES 

AD_4nXcxGRLCjywD3RfDmG8Tl6vu7-d8S1VGxtQ0AwH8fz4pzuod4CeMDg1gBTbq3NNvba-ioBIR23ICf14I1PHPu9H5BL0irn0DWg929Gi0PsBdEom9yKR53uHz0x6tDwtsGw3qnXDEloWBSBZSdGy_NzRYxklV?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

Configuration of CData Power BI Connector for SAP HANA: 

 

  1. Download and install the CData Power BI connector driver:
    https://www.cdata.com/drivers/saphana/download/powerbi/
     
  1. Open the ConfigureODBC tool as Administrator: 

AD_4nXcmc3UC7Eao0OBw_uMhxXyYolDtJt-2ydJcPFKThyJOonYL4jir5cbLCY1JbJFgO-W-3-AzuFCmDvf-yUtbjya3jHFSlJuAVd3do69ojq9VZnYIwm6hntdwzuH-F3bSiTISctBCB47P_tnpyIT3lv4z-Ct9?key=Z7V6CrtUkJZp5rPpYLNEsg

 

  1. Provide the information related to SAP Datasphere to the ‘Server’ (set to the Host value), ‘Port’, ‘User’, ‘Password’, and ‘Database’ properties. Set ‘Use SSL’ to ‘True’: 

AD_4nXdfHpqvhxwXfqZPdTzhx89lhDabCygRP9470r7rdOwuWVVqZ7I_5Kxx1LKkhQ56gIMctKsW1rR0sgg4gSV4LsF6uZ6SkWb3pMaVeMRihUnyHB0Lq3zFApcUUm9_ZvjmhfU8W-oNq5PDdU5XZJ68hGSk-F1L?key=Z7V6CrtUkJZp5rPpYLNEsg

 

  1. Click on Test connection: 

AD_4nXd0LEgee3T8BwMHlkLznRwITamQf0uHF7aLcB6UvYKpmt17qSgcDI-XsbpubnGIP8IRMr0jGHqQLRwY3C-B2_u-Speak4_JUxV1_N6YV2V8CrAIfuE9amF4Q86ZAi5gXimBT-wcycdpi7dsF6HYLV_aDUNp?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

Verify connectivity in Power BI: 

 

  1. Open the Power BI application. Then, click on ‘Get Data’ and search for ‘ODBC’: 

AD_4nXfe1Enz_hodbXXTJ0ubns3WqyFjt2Mxny3bACqZmOez_6G-WMhZq-d1Bt3xr2yj4qUU4KLX1YsDT7VDpP25GelFMA4bx0YpiXeGEMjn4gbXGCxkLfe4CpgeYUBzr5bS63a8Sp2EJSj9mW3ePMrDPvMJ3sx7?key=Z7V6CrtUkJZp5rPpYLNEsg

 

  1. Select  ‘CData PBI SAPHANA Source’ as shown in ODBC Data Source: 

 

AD_4nXcTJLua1xDTTh6jbxljTwoNGqSI7tx4qUHVoBn00iSXdIfWay_WfVV_DyZMlqMXrK_OIMmkjVk_c8et8qldf6_NtVOVJWkFRDsdhC46Q8nduD4ZUQY_PTne5L3USuHLGd6nQyVXQjDz14F-8sVI_-TTeOc?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

 AD_4nXd9Kg-Bvf5cicWubZ5611Ia38t9J8sdgenTinV5wofxbZAoX1iUPhUNQ55hbL77jJBu7BcuQXgqwRpaKxTuf1kZh4SUzksQvIP3Q89N6mr6nNl8lMMWHqcVfbDWglcJzzLx4-G-1KvJo_rqknQUiYf3yfo?key=Z7V6CrtUkJZp5rPpYLNEsg

 

  1. You should now see all the source data in the Power BI explorer. Select the Analytic model/Graphical view from SAP Datasphere to use in Power BI: 

AD_4nXdRrAfZCu6S5_LJ-xwSZTZUo7HD9dMC9aPjR1JszAVxiBa_lwWwJkN5W03J0vtHAjYKKNm64QP_nQ-bz2I6qnOYA7SXl1OEm3rHi_jVXPwczmK_02Jolir2F5K39gkqS5Xu2R5FOMoQxz1jamOK3s7G1BwO?key=Z7V6CrtUkJZp5rPpYLNEsg

 

AD_4nXeQD_bthiN5TMi6aGe07Z9FJBgpLxw0ngPNhwZy1iwvp5QpwgdyQ_Sap2vHTLGjOpsBwtAbhOMK6D1loz_benKM1Da4EQXQ0eiJsM7UILKnZW-oMJd1dnXNfOdAVare0e5K-UUc24dU0t-26Dvy1rwdZxeg?key=Z7V6CrtUkJZp5rPpYLNEsg

 

 

 


0 replies

Be the first to reply!

Reply