Forum Discussion
SAP - PBI Integration
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.
Hi Franklin1,
Hope you have figured out the questions you raised. Xiaoxin's replies are helpful and informative.
I had a chance to work with SAP B1 based on HANA and MS SQL database as well as Power BI. SAP Business One is an ERP product for small to medium size companies while SAP BW is a data warehouse product.
Your Power BI desktop is connecting to the B1 database. You can use ODBC or the PBI MSSQL connector to connect to MSSQL or using the PBI HANA connector to connect to HANA database. So technically speaking you don't need the B1 ERP license as you don't have to login to SAP B1 to pull data. Please note that there may be some terms from B1's End User License Agreement that end user should not connect to database via unauthorized connection. So please check with your SAP partner or admin about the details.
There have been many "Power BI content packs" for various applications. But it doesn't seem there is one for B1 yet.
Hope this helps.
Jimmy