cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC vs Web Services

Former Member
0 Kudos

Hi,

Can someone please let me know that if we need to send some data from a SQL db to XI, what should be preferred, JDBC adapter or a Web service that pulls data out of the db and XI picks the data from then on(through a SOAP adapter i think)

Can you please reply with the benefits and drawbacks of using either of them.

Regards,

Sampada

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sampada,

Q: Can someone please let me know that if we need to send some data from a SQL db to XI, what should be preferred?

Ans: JDBC Adapter, because jdbc adapter directly hits the database and retrieve data from it but on the other hand SOAP adapter works with webservice and for that you need a registered webservice to take request and give response back. if you dont have webservice, it needs to be written.

For JDBC adapter see this link:

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

For SOAP Adapter see:

http://help.sap.com/saphelp_nw04/helpdata/en/69/a6fb3fea9df028e10000000a1550b0/content.htm

Reffer this For JDBC Sender

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

JDBC Framework:

JDBC for Synchronous communication:

Webservice/SOAP Adapter:

Please reward if found helpful.

BR,

Alok

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sampada,

JDBC is preffered. XI has the ability to poll the database on sender side. Also it is good with performance then SOAP.

While using Web Service for this scenario with XI, you should the complexities are-

1) You have to write Web Service of your own including JDBC code.

2) You will need some trigger to start the XI scenario ans this Web Service will work on Receiver side.

3) You will have to use BPM to provide it to any other system.

So, for database connection, always JDBC Adapter is preffered.

Regards,

Piyush