Forum Discussion
How get data directly from SAP ECC
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
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
7. Click Ok and your done. Here is the output from my select statement.
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.
Thanks for the reply. We are looking for the document for the Odata configuration in SAP application.
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.