How to connect SQl Server 2008 to SAP BW

[former_member199448]

Hi Experts,

i would to build the following scenario.

I would like to connect an infoprovider or a query in sap BW to a SQL Server.

The goal will be to use the Management studio as well and to send the data from SAP BW (Cube or Query) to the sql server.

1. Could you please advice steps by steps how to do the istallation?

2; Which connectors should i use?

3. Is there any document which provide the tools, drivers, connectors to be used?

4. Is there any how to which can help after the installation to run the scenario?

Thank you in advance for your Input.

Cheers

Gilo

[Former Member]

Hello,

What you request can be done with DB Connect.

A good starting point is the following link :

[http://help.sap.com/saphelp_NW04/helpdata/en/58/54f9c1562d104c9465dabd816f3f24/content.htm|http://help.sap.com/saphelp_NW04/helpdata/en/58/54f9c1562d104c9465dabd816f3f24/content.htm]

Also I recommend to search further on SDN because there are some interesting posts on connecting BW to external databases like SQL Server.

Wim