Connecting of BPC 7.0 MS with SAP BI

[Former Member]

Dear all

I am looking for the connectivity of BPC 7.0 MS with SAP BI. I have used the flat file upload mode but I am exploring some robust method to connect both systems. Can you tell me about this? What is the ETL connectors and to what extent they are useful in connectivity?

Thanks in advance.

[pravin_datar · Accepted solution]

Hi Amar,

Have you explored the option to use Open Hub to export the flat file at a defained location so that BPC can pick it up automatically ? Also if you want to load BI data to SQL database, there are more options available at: http://www.microsoft.com/isv/sap/technology/interop/bi.aspx

Regards

Pravin

[Former Member · Accepted solution]

Dear Sir

Thanks for the reply.

We are doing the data upload thru Open Hub > Flat File upload and then via Data Manager into BPC. Also I'll look into the link shared by you. However from system control point of view still not confident as system is finally going to generate a flat/ csv file. So just trying to make the communication in more controlled environment.

Also I am wondering for 'ETL connection/ connector' as heard for several times in context of BPC connectivity.

Once again thanks for the prompt reply.

[pravin_datar · Accepted solution]

Have you explored using UD Connect (http://help.sap.com/saphelp_nw04/helpdata/EN/78/ef1441a509064abee6ffd6f38278fd/content.htm)

Regards

Pravin