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
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
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