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)

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

Also have a look at these threads.



Former Member
0 Kudos

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

See note 512739 and

Answers (0)