Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How get data directly from SAP ECC

Since the last question someone asked about that was 2 years ago. I wanna know if its possible to get data direclty from the SAP. I am pretty sure that my SAP is ECC, and I wanna know how I can pull...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I appoligize but I didn't know what SEGW was. If you are exposing your data through odata services then you can point Power BI at the odata. I assume you have tested in a browser that you can connect to your odata connection that you've configured with SAP??

 

With in Power BI there is an OData Connector, you should just need to enter your url for the odata feed. 

 

Then within the Power BI Service you would configure an odata connection in the gateway. You just need to supply the url and credentials. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for your reply. Please find the below queries from my side.

 

1) you are just simply saying after the service created within the SAP and tested it via browser. OK coming to your point how this service built in SAP ECC going to connect to Power BI. If we built the connectivity then there should be the soure and target systems should have the connectivty method. Which method we need to use to estabish the connectvity between SAP and Power BI .? So how SAP ECC is going to connect with the Power BI.?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    We are on SAP ECC 6.0 and on oracle database

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    rajsekhar, 

     

    You're going to make your connection to Power BI utilizing the oData Connection. You'll configure this in Power BI and Power BI Servcie the same way. Your oData feed should have a url that exposes your data. This URL is your connection from Power BI to SAP ECC. You won't be connecting directly to SAP ECC in regards to the app but you'll be consuming data from SAP through the oData feed. 

     

    Check this out: 

    https://docs.microsoft.com/en-us/power-bi/desktop-connect-odata

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Rajsekhar,

    Were you able to access tables from SAP ECC 6.0 on Oracle Database to Power BI for generating reports?

    Please help.

    Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Pankaj,

     

    We are planning to connect the system by using Netweaver Gateway through ODATA services, however trying to findout for a document for this one. 

     

    Do you have any document on this one or is this already configured in your SAP environment.? If yes do you have any screenshots from SAP end for this config.?

     

    Regards,

    Raj

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I don't have anything from our system but did you look at the link i provided in the previous post? That seemed to walk through the steps of creating an oData feed. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes that URL is to connect to an ODATA feed in Power BI. We are looking for the document of Netweaver Gateway setup and ODATA configuration within the SAP application. Once this is done the we can go with the steps described in your provided URL.