cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect SAP BW with SQL Server 2005

Former Member
0 Kudos

     Hello! good day, first of all, i want to tell you I am new in the group and i am not sure if I should ask  here in  this section.

I'm in BW but need help with connections
I am on  the server SAP BW using the rsa1 transaction, so I have a sql server database on other server, they have permission to connect through TSQL.
I would like to know what are the steps necessary to make a connection to sql server and pull data from it.

Thank you for your advices

Accepted Solutions (1)

Accepted Solutions (1)

former_member186082
Active Contributor
0 Kudos

Hi Garcia,

BW can be connected to SQL server 2005 using DB connect

This document will help you in achieving this

http://scn.sap.com/docs/DOC-11704

Also have a look at these threads.

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

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

Regards

Chandu

Former Member
0 Kudos

May I add that certain restrictions apply in the naming of the database tables etc.

See note 512739 and http://help.sap.com/saphelp_nw04/helpdata/en/58/54f9c1562d104c9465dabd816f3f24/frameset.htm

Answers (0)