Forum Discussion
SAP - PBI Integration
Hello,
We want to create a report for a third party using their data in SAP.
The report will be created using the Desktop BI App by us, and will be shared with the 3rd party using PowerBI (Web).
We have no SAP license at this point of time.
We have a few questoins:
1. In order to get data from SAP to the PBI Desktop what exactly do we need? we realized that we need SAP Hana ODBC, but in order to download the SAP Hana Client do we need any other SAP License?
2. Does the Get Data, support geting data from SAP Business One?
3. The users of the Dashboard will be use them by PowerBI (Web). Do they need to install the SAP Hana ODBC as well?
Thanks.
8 Replies
Hi Franklin1,
Q1: You can refer to belowl link which about use SAP Hana in power bi:
Use SAP HANA in Power BI Desktop
Q2: No. SAP hana and SAP BW not the same datasource.
SAP BW and SAP HANA – a simpler view
Q3: Not need to, you only need to config the gateway and share the dashboard to users.
Regards,
Xiaoxin Sheng
Thanks a lot Xiaoxin,
I still need a few more clarifications please:
The data I want to get to PowerBI is comng from SAP Business One.
Regarding Q2: Just to make sure I got your point - so SAP Business One is a SAP BW?
As far as I am aware of, there is a way to get data from SAP BW (one of the sources under Get Data is SAP Business Warehouse Server).
Is that correct?
What do I need to be installed in my local machine in order to get data from SAP Business One (see also comment regardint Q1 below).
Regarding Q1: I understand that I need connectors (for SAP BW) / Client (for SAP Hana). The issue is that at this point of time I don't have any SAP License, so I can not download the required Connector/Client. What do I need in order to be able to download it?
Thanks.
Anyone?
Can anyone comment here?
Thanks.
Getting data out of SAP is a snap using Simplement's Data Liberator:
This platform surfaces any SAP table in real-time, directly into SQL Server, ready for integration, Power BI, SSAS, SSRS, Tabular, or further processing in Management Studio. It is simple, and powerful, and easily integrates with third party data, as does Power BI.
Mike McNally
