Forum Discussion

Franklin1's avatar
Franklin1
Advocate I
9 years ago

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)....
  • Franklin1's avatar
    Franklin1
    Advocate I
    9 years ago

    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.

    • Franklin1's avatar
      Franklin1
      Advocate I
      9 years ago

      Anyone?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Franklin1,

       

      >>Regarding Q2: Just to make sure I got your point - so SAP Business One is a SAP BW?

      Sorry, it seems like I have misunderstanding of SAP B1.

       

      >>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).

      Power bi desktop has the connector of sap bw/hana, current it not support sap b1. About this requirement, I'd like to suggest you submit an idea to ideas forum.

       

      >>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?

      I think you can get further support at sap forum.

       

      BTW, you can also try to use OLE DB and ODBC to connect.

       

      Regards,

      Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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