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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
Syndicate_Admin
Administrator
Administrator

Do you need to install sap gui to use the extract table?

I've been trying for months, and when it connects what should be done to achieve the connection to extract

For the sourceforge ExtracTable tool to download or live connect SAP tables to Power BI or  Power Query the SAP GUI is not needed. 

Use the tool's 'extract_table web service' in the power BI Web data source for real-time data retrieval. You need then to configure BI a little to get the streamed XML table presented the best.

 

For none real-time data (e.g. downloaded via the tool at night or so) you can just link Power BI to the corresponding saved CSV or Excel file.

unais
Helper V
Helper V

We are having Sybase Database with SAP ECC and able to configure Sybase DB with ODBC and Though Gateway service able to connect Power bi service.

I had created Different Views in Sybase to and connect with Power BI Query.

Anonymous
Not applicable

Just to add to this, SAP is sitting on top of a database which could be Hana, SQL Server, or Oracle. As such you can create a connection from Power BI directly to the database layer, however, you would have to currently have a FULL USE database license and not a RUNTIME license. I know this to be the case with SQL Server and would assume Oracle would be the same but I can't say the same for Hana. None the less a FULL USE license allows you to access the database directly where as a RUNTIME license only allows the application (SAP ECC) to access the database. You would have to check with you SAP Account rep or even your DBA should be able to tell you. 

djnww
Impactful Individual
Impactful Individual

The answer is yes, it can be done. The 3 methods I know are:

 

1. SAP HANA connector (I have not tried the connector)

2. SAP BW connector via Power BI Desktop. I am assuming if you have SAP ECC, then there will be equivalent SAP BW cubes.  You will need your SAP/IT area to provide you with the relevant credentials). My company has been using this method.

3. Ask IT to build a custom API that will work (ie. JSON with OAUTH2 security) - probably the best long term method, but will be difficult to convince IT.

 

The challenges you face will be getting SAP Admin OR IT to allow Power BI to connect to SAP ECC. Security will always be the number 1 reason they use. With the right governance and implementation, it won't be an issue. 

 

Cheers,

Dan

 

Hi Dan,

I'm looking to connect SAP ECC through power Bi,
SAP ECC is not a database, It's a service, In that service we are using oracle as a database.
So could you please guide me step by step proccess how to connect SAP ECC and get the data.

Thanks in advance.

Best Regards
Venkata

Hi @gudakrishna 

If PowerBI needs to fetch data directly from SAP (say reports, queries, tables, views CDS etc) then the USB4SAP connector for PowerBI will be useful: Ecoservity – Ecosystem. Services. Technology

Besides realtime in PowerBI, you may also provision SAP data to a datalake/ DB / NFS & consume from there.

This is certified by SAP & Microsoft:  USB4SAP - Connectors | Microsoft Learn.

hope this helps. 
AJ

[PS] Step by step Video guide is here: https://www.linkedin.com/feed/update/urn:li:activity:7174406748747833344/

I would say BW or HANA are not the approach we want to use ... the Power BI connectors for these sources are already defined.  But they require ETL/staging to bring the desired data from ECC to BW or HANA.

 

The need is for DIRECT access to ECC data, ideally using SAP-sanctioned API's.

 

Up until last year, Power BI had a "BObj Universe" connector, which would be a desireable.  But this connector was removed due to licensing issues (so I hear).

 

I think there is a market for this if someone would develop it.

 

Pete

Do you have the Netweaver Gateway installed? The one used for fiori apps. It is a free SAP product. You just need to install it. You can write simple report function modules in ECC (say for sales or inventory data) and then map them through the gateway. Super simple. Then you've just created a REST oData feed that can be consumed in PowerBI. Straight Up...now BW garbage, cubes, all that muck and no Hana required. I've done it numerous times...only downfall is if you are trying to read too much (like financials for five years). 

Anonymous
Not applicable

Could you please specify the steps to connect SAP ECC to power BI.

Anonymous
Not applicable

1. Launch Power BI

2. Select 'Get Ddata'

3. Select the Database Source that your instance of ECC is on. In my case its a SQL Server Database

 2019-01-30_10-56-27.png

4. Enter the Server Name that the database is on

5. Enter the Database Name 

6. (I do it this way) Expand 'Advanced Options' and paste your SQL Statement

2019-01-30_11-06-47.png

7. Click Ok and your done. Here is the output from my select statement. 

2019-01-30_10-59-56.png

As mentioned in previous posts this requires you to have a full use database license. There are instances where the database that SAP runs on is a runtime license which means that the application is the only one that can access the database. This is licensing issue more than a technical issue. If you have a runtime license you can still technically do the above but from a licensing standpoint you'll most likely run into issues with SAP. 

 

Also, you'll need your DBA or who ever manages your databases to create a Read-Only databse user that you can use to login with. I don't know what else to add, your simply connecting to a database just like any other database. 

 

Please note that we do have a Full-Use SQL Server Database License. 

 

Hope that helps. 

Anonymous
Not applicable

Thanks for the reply. We are looking for the document for the Odata configuration in SAP application.

Anonymous
Not applicable

Everyting dealing with SAP always seem to be so cumbersome. I did find this link, it's a bit older and looks like it might be targeting SAP ECC 6.0 but didn't really look. I'm sure there are a tone of turorials on this. 

 

https://blogs.sap.com/2015/05/11/developing-odata-services-in-sap-backend-and-exposing-odata-service...

 

Anonymous
Not applicable

Thank you very much for your reply. I understood the steps you have specified is from Power BI side. I would like to how to establish the connectivity between SAP and Power BI. Is there any gateway configuration that needs to be done from netweaver side. Also we have tried to create the project via SEGW  and initiated the config however we are confused from connectivity point of view. Could you please let me know the steps that needs to be done from SAP ECC side.

 

Thank you.

 

Regards

Raj

Anonymous
Not applicable

There is no direct connection from Power BI to SAP ECC. And I would assume there never will be. 

 

Your options are but not limited to (As others may have come up with other ways to get data):

  1. Direct connection to the database
  2. Connect to SAP BW (Which can be done through Power BI)
  3. Connect to SAP Hana (Which can be done through Power BI)
  4. Follow the examples from sreenathv and use the DBCO T-Code or SAP PI and put your data in a different database and then once again use a direct connection to the database that has your replicated data. 

I've have talked to other companyies who do schedule nighly reports to be ran and saved to a network drive. They then consume these reports in Power BI with the Excel connection. 

Anonymous
Not applicable

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. 

2019-01-30_12-41-37.png

Anonymous
Not applicable

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

We are on SAP ECC 6.0 and on oracle database

Anonymous
Not applicable

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!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors