DB Connect MS SQL Server

[Former Member]

Hi All

My customer needs to get data from another legacy system, which is implemented on SQL Server 2000, to show on their reports. I want to connect to the SQL Database by using DB Connect on BW 3.5.

Here is my BW Specification:

1. App. : BW 3.5

2. DB : Oracle 9.2.0.6.0

3. OS : LINUX

Here is my SQL Server Specification:

1. Microsoft SQL Server Version 8.0

2. Microsoft Windows Server 2003 Standard Edition

Because my BW is on a non SQL Server, I need to install the SQL server client software and the DB shared library on the BW Application server. Are these components available for LINUX systems?

Regards Sigi

[Former Member]

Hi,

I have the same problem. When i want to connect to AS400 system for some legacy data.

When i am creating the source system, its throwing an error no shared libraries found and the source system is not getting created.

Your help will be greatly appreciated.

Thanks and Regards,

Sen

[Former Member]

Hello:

These do not exist on Linux. In order to utilize DBconnect in this configuration, you would need to install an application server on your BI system that is a windows server. There is a small amount of extra basis config necessary to enable a windows app server on anotherwise unix (or Linux) system. The dbsl & client software would then be installed on that specific windows app server.

Alternatively, you can utilize UDconnect to take a differnt route. With UDconnect you would not need a windows app server, as the interface would be accomplished using adapters & drivers (ie JDBC or ODBO) throught the AS-JAVA adapter framework. So you would need the JAVA stack configured to work with you AS-ABAP instance to accomplish the interface using UDconnect.

BEst Regards -

Ron Silberstein

SAP

(thanks for any points you choose to assign)

[Former Member]

Ron, one general question on setting up the App Server to enable the DB Multiconnect. Documentation refers to the server needing to be 64-bit. Does this need to be a True 64-bit server, or 64-bit compatible. We have several servers in our client reserve that are of the "compatible" variety, and would like to utilize those if at all possible.

Thanks

Harry