connection to an Ms-sql external db by mean of jdbc drivers...

[Former Member]

dears

I should make available a connection between a BI system (abap+java), based on nw 702 , Unix/Oracle 102, with an external (non Sap) Ms-Sql 2005 database.

I read somewhere this should be possible using Jdbc drivers, and I'm looking for a usable step-by-step procedure .

Any advise ?

best regards

[Former Member]

Hi Roberto,

This links might be useful to you

Video:

http://www.mattbartlett.co.uk/connecting-sap-on-oracle-to-an-external-microsoft-sql-db/

SAP Help

http://help.sap.com/saphelp_nw70/helpdata/en/9c/d736b880c34f76b507bac7751a0474/content.htm

Note

https://service.sap.com/sap/support/notes/738371

But if I would be doing it, I would have gone simply to RSA1 -> Source system -> DB connect

and would have followed the wizard and see if this works for me or not

[Former Member]

thanks , very interesting but unfortunately I cannot use DBCON

As the Sap sistem is on Unix, I cannot copy the dlls for Ms-Sql under unix.

I'm going to get throught the several Oss-Notes.....hope to find something usefull.

regards

[Former Member]

these links might help in your journey.

http://www.sommarskog.se/mssqlperl/unix.html

http://www.martin-evans.me.uk/node/55

http://www.cs.washington.edu/lab/sw/everywhere.html