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...
djnww's avatar
djnww
Impactful Individual
8 years ago

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

 

gudakrishna's avatar
gudakrishna
Regular Visitor
7 years ago
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