JDBC vs Web Services

[Former Member]

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

[Former Member · Accepted solution]

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