JDBC connection XI to MSSQL

[Former Member]

Hi!

I'm starting whit SAP XI. I need to connect from SAP XI (on UNIX) to MSSQL DB.

I know that I have to install and configure drivers for JDBC adapter, but the question is:

Whot I have to do after that. Is anything what I have to do on XI side. How and where I have to create that connection for taking data from this database. I have to write some program in Java or I can use some module from XI to do that?

[bhavesh_kantilal · Accepted solution]

Hi,

After you install the driver you use the Sender or Reciver JDBC adapter to connect to the database.

The parameters in the JDBC adapter,

If you have already deployed the drivers (msbase.jar, mssqlserver.jar, msutil.jar).

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

If you are using the new SQL Server 2005 jdbc driver (sqljdbc.jar). Setup is basically the same, except the driver is now:

com.microsoft.sqlserver.jdbc.SQLServerDriver

And the URL is slightly different as well:

jdbc:sqlserver://host:1433;DatabaseName=name

Regards,

Bhavesh

[Former Member]

Can you give me some example how to configure all that things?

PS: Masz moze numer gg pogadaliby&#347;my na ten temat. Moze szybciej bym mogl rozwiazac ten problem.

[Former Member]

Hi,

Have a look into the blog /people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

This will show you how to do the settings to access a db using JDBC adapter..

Regards,

Jai Shankar.

[MichalKrawczyk]

hi,

2203335

Regards,

michal

[Former Member]

OK but I still dont know where this JDBC adapter is situated and how to run this adapter to put this parameters:

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

Maybe I have to run some transaction like dbco and write this there.

Please advice me step-by-step

[MichalKrawczyk]

hi,

>>>OK but I still dont know where this JDBC adapter is situated and how to run

did you deploy the driver as per my link?

then you need to configure it in integration directory

( transaction sxmb_ifr on XI)

but you also need to configure the rest of the routing

in the integration directory and the repository part too

for jdbc weblogs you can have a look at documents

section in XI FAQ link below

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

Message was edited by: Michal Krawczyk

[MichalKrawczyk]

Hi,

after you deploy the jdbc driver for mssql

on your XI all you need to do is to

maintain the jdbc channel - nothing more

(then just standard routing)

deploying the jdbc driver:

https://websmp205.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDrivers.zip

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>