SAP DB Connection from SAP BI on HP UNIX to MS SQL External Database

[Former Member]

Dear All,

Greetings!

I have a scenario to configure a SAP DB Connection from SAP BI System on HP UNIX 11i to the external legacy system MS SQL 2000 Enterprise for data upload. I am interested in connecting the SQL server as a Source System to the BI System.

I read through documents mentioning about installation of a Client driver in the SAP BI System, I also downloaded the JDBC client software and tried installing the same, but the steps as mentioned Setting the CLASSPATH or connecting to the server did not work.

Please help me in connecting the SQL Server as Source System, I would like to know in detail about the same - so kindly help me with the links to documents and guides about the same.

Thank you

Regards,

Vineeth Damodar

[Former Member]

I was able to solve this issue using a UD connection.

[markus_doehr2]

Short answer: this does not work.

Long answer: To connect directly to the database you need

- a database client for the source system

- a database interface library for the source system

Both of them are not available for HP-UX if the target database is SQL server --> doesn't work.

What you can do is: add a Windows application server to your BI system (heterogeneous installations work and are supported) and add there the database client and the database interface library.

Markus