on 04-15-2008 5:38 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.