Integration of SQL database with XI

[Former Member]

Dear All,

I have a req in that I have to connect to SQL Server database to XI system then from XI to ECC.

To do this what are Connection should done from DatabaseXI-ECC.

I have JDBC adapter in XI.Do I need install again in XI .

how we will connect SQL Database to XI system?

Regards

Manish

[Former Member]

Hi Manish,

Your scenario like this

JDBC->XI->ECC(RFC/PROXY/IDOC).

Download the following JDBC Driver. Once you deploy this driver you would be able to connect to SQL Server .

http://www.microsoft.com/downloads/details.aspx?familyid=6d483869-816a-44cb-9787-a866235efc7c&displa...

Drivers Instalation Process

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfc...

Jdbc Channel Configuaration

JDBC Diver:com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection:jdbc:sqlserver://ServerName:Port;Database=XXXXXXXX;

Username:XXXXX(Ex:sa)

Pwd:XXXXXXXX

Thanks

Ravi

[Former Member]

Hi ,

That means there are no RFC connection are req to make connectivity between SQL database and XI?

and in the below link there are some jar files which I will need to install the driver for MSSQL200.

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfc...

from where I get these jars

Regards

[Former Member]

Hi ,

That means there are no RFC connection are req to make connectivity between SQL database and XI?

and in the below link there are some jar files which I will need to install the driver for MSSQL200.

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfc...

from where I will get these jars?

Regards

[sunilchandra007]

Yes, you are right. No RFC connection is required. It would be JDBC connection that is created when you configure the JDBC communication channel filling the details about the database SQL server.

The drivers can be downloaded from microsoft site http://search.microsoft.com/Results.aspx?q=sqldriverdownload&mkt=en-US&FORM=QBME1&l=1&refradio=0&qsc0=0 .

Regards,

Sunil Chandra

[Former Member]

HI Sunil,

thanks for reply ...

I have one doubt..

there are two parameters in XI JDBC adapter at sender side...

Query statement is to select the data

update statement is to update the data

in my case we don't want update the database so in this wht we have to do?

[sunilchandra007]

Actually it depends on your requirement. Normally update query is used to update any flag that indicates about what has been read through the condition in select query. Anyways, if you don't need that it is ok. For details, refer to http://help.sap.com/saphelp_nwpi71/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm .

Regards,

Sunil Chandra

[Former Member]

Hi Sunil,

according to below link ....

http://help.sap.com/saphelp_nwpi71/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm

If we don't want to upadate the database after pulling the data from database

We can give <Test> in update parameter plz correct me if I am wrong?

Warm Regards

[sunilchandra007]

Correct .

[Former Member]

Hi All,

How can we check JDBC driver are instaleld in our XI system or not?

Regards

[sunilchandra007]

Hi Manish,

You can request the basis guys to check the JDBC drivers on XI. For help, you can provide them with the following links:

1. section 2.2.1in http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d...

2. /people/francesco.bersani/blog/2009/11/27/jdbcjms-adapter-list-jdbc-drivers-installed-on-pi-box

Regards,

Sunil Chandra

[Former Member]

Hi,

you need to install the driver of your databas. It's explained here:

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d...

Regards

Patrick

[stefan_grube]

check online help forst:

http://help.sap.com/saphelp_nwpi71/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm

[sunilchandra007]

Hi Manish,

Your scenario is JDBC to ECC(IDoc/RFC/Proxy). Before trying this, you should have the proper SQL drivers installed on XI server.

Search on SDN, you will get many blogs for the same.

Regards,

Sunil Chandra