Enquiry about XI

[Former Member]

Can XI directly send data to SQL server? Or in order words directly update to SQL server.

Any other tool that we can use for that besides using XI?

[Former Member · Accepted solution]

Can XI directly send data to SQL server?

yes U can send data. U can update data also. using JDBC adaptor with in XI.

regards,

Ansar.SK

[bhavesh_kantilal]

Hi,

It sure can. use the JDBC adapter provided by XI to insert , update , Delete , and Call stored procedures to SQL server!

You would need to install SQL server drivers on XI and then create the data format as expected by the JDBC adapter and you can use XI to "talk " to SQL server.

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

Thanks for your reply.

Is there any documentation, website or blogs that can show me step by step on doing this? I am quite new to XI and may need those stuff to help me out.

Thanks.

[Former Member]

go through this link

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

regards,

Ansar.SK

[Former Member]

Hi Justin,

Got thro this blog:

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

All you need to do is change the drivers accordingly for SQL server.

Go thro this thread for Driver and Connection URL:

You also need to deploy the driver jars in XI server.

For deploying:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f...

Regards,

P.Venkat

Message was edited by:

Venkataramanan