Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 direct data from that source.
Im looking from ways in the internet and not finding anything guiding me.

Thanks in advance

29 REPLIES 29

Had same problem for connecting SAP table data , used free https://sourceforge.net/projects/extract-table-for-sap/ 

Problem solved.

Anonymous
Not applicable

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
Not applicable

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
Not applicable

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.

Anonymous
Not applicable

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

Can you put some more explaination to this? I am also looking for similar functionality to connect to SAP ECC via Power BI. What you have mentioned makes more sense.

 

Appreciate if you can explain in little greater details.

Anonymous
Not applicable

Hi,

 

There are couple of options that we can use and the decision will based on the method that you would like to use.  But as a disclaimer, I would like to tell you that it is not a good idea for analysis, because SAP ECC's underlying database will be optimised for transaction processing with many table linkages (OLTP). If you import the data directly to Power BI, the performance will not be optimal. So the first step that we have to do is to convert the OLTP data into an OLAP data model (Star Schema, Snowflake Schema etc..) and then connect Power BI to this OLAP data source.

 

This OLAP data source can either be SAP BW (with or without BI/BO) or any other databased modelled as OLAP. If you choose not to use SAP BW, and bring the data into a database like SQL Server from ECC to normalise them / optimise for analysis, and then connect Power BI to this database, then we have two options.

 

Option I: Exporting SAP ECC data to another database.

 

SAP ECC has a transaction code - "DBCO". Using this, we can configure a connection to an external database and define a connection string for that. We can create as many connections as we want. Then write an ABAP program to create a report in SAP and instead of throughing the output as ALV, the output of the report can be written to this external database using this connection string. You can schedule a background job in SAP to run this report periodically and the output will be available in the external database like SQL server. In this SQL server, you may write queries, normalise them, optimise for reporting, create views etc... and connect Power BI to the tables and views in this database for reporting.

 

In this case, the data between SAP ECC and Power BI will not be live. It will be as per the frequency of the scheduled background job. Moreoever, the background job might put load on the ECC production client.

 

Option 2: Using SAP PI (Process Integration)

 

We can use SAP PI to sync the data in SAP ECC to another database or Power BI dataset. The dataset in Power BI can be used as the source of data for creating reports. In this case, the data from SAP ECC has to be pushed to the Power BI dataset or the external database through REST APIs, JSON etc... 

 

From what I understand, the major difference between these two options is that, in Option 1, the method of data transfer is similar to Pull Method where it is based on a time schedule. Whereas in the 2nd Option, it is more like a Push Method which happens in real-time.

 

Another major consideration is what kind of SAP licensing you have and the option you choose to use has to be careful as not to violate any licensing terms.

 

Search Terms: "SAP transaction code : DBCO", "Power BI REST APIs", "SAP Process Integration", "Push data into Power BI dataset using JSON" , "SAP BW Connector for Power BI"

 

 

 

 

 

 

Anonymous
Not applicable

How to connnec the SAP ECC to powerBI. We have created the project under SEGW however we are not able to find the method to connect the ECC system to Power BI. Any help would be appreciated.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors