SAP- BPC (MS Version 10.0) : How to get data from MS SQL !!!

[Former Member]

Appreciate, if any one can assists regarding data uploading from MS SQL (2005/2008) to SAP BPC - (EPM - 10.0). Thanks.

[former_member188883]

Hi Nasar,

Is your SAP BPC 10.0 on SAP NW stack ?

If the answer is yes, then you have define MSSQL database connection using the document below

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/503c4394-cfb6-2e10-349e-85052e8e9...

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thanks for your email. Actually we not using SAP NW, our BaaN ERP database exist on MS SQL (2005). That’s why we have purchased SAP-BPC 10.0 MS version.

Really appreciate if you can assist to resolve this issue.

Thanks,

Nasar Khan

[former_member188883]

Hi Nasar,

Please check link for remote database

How to enable remote connections in SQL Server 2008? - <dw:daniel_walzenbach runat=&quot...

Hope this helps.

Regards,

Deepak Kori

[Sriram2009]

Hi Khan

Could you refer the SCN link

http://scn.sap.com/thread/3429221

and also you can post you query in

http://scn.sap.com/community/epm/planning-and-consolidation-for-microsoft

Regards

Sriram