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:
- Login to your SAP Datasphere instance:
https://<serverName>.us20.hcs.cloud.sap/dwaas-core/index.html#/home
- Navigate to ‘System’ –> ‘Configuration’ -> ‘Database Access’
- Click on ‘Create’ to create new User:
- Provide the ‘Database Analysis User Name’, and then check the ‘Enable Space Schema Access’ check box. Set ‘Database analysis user expires in’ to ‘Never’.
- Note the ‘Host Name’, ‘Port’, ‘Database Analysis User Name’ and ‘Password’ values:
- 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:
- 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
Configuration of CData Power BI Connector for SAP HANA:
- Download and install the CData Power BI connector driver:
https://www.cdata.com/drivers/saphana/download/powerbi/
- Open the ConfigureODBC tool as Administrator:
- 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’:
- Click on Test connection:
Verify connectivity in Power BI:
- Open the Power BI application. Then, click on ‘Get Data’ and search for ‘ODBC’:
- Select ‘CData PBI SAPHANA Source’ as shown in ODBC Data Source:
- 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: