About JDBC Adapter?

[Former Member]

Hi experts,

iam practicing scenario on company sandbox,i want to work using JDBC adapter,what are the prerequisite to do that senario.

I want to do JDBC->XI->File senario in my sandbox, let me know how to do this senario and also what are the software i have to load in this standalone system.

plz send me related doc's.

regards,

Phani

[Former Member]

HI,

First check JDBC is in Adapters list or not , if not try to install..

Next check what is the Database you are trying to connect,

The respective driver parameters and the connection parameters are to be selected and the respective database is existed or to be created and create the table also .

Now use the scenario to get the data from the table and send to file as your requirement

see also the below links

Sender JDBC scenario - /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

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

also

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

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response - XI: How-to on JDBC receiver response

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Deploying and Removing JDBC Drivers

Regards

Chilla

[Former Member]

Hi Phani,

Check this..

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

cheers,

Prashanth

[Former Member]

Hi,

Just have a look at this link:

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

For more information

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=jdbc%20to%20file&cat=sdn_weblog

regards,

Gunasree

[former_member335553]

Hi

refer this thread

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

/community [original link is broken]

This is how a SENDER JDBC Adapter works,

When you are using your JDBC as a sender, then your JDBC will poll over your database and select the rows that satisfy your Select Query.

In your case, as you are dealing with multiple tables, you can write a stored proceudre for your Database, and call this stored procedure in your Sender JDBC adapter in the SELECT field of your JDBC adapter.

Go through this blog for stored procedures.

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Message was edited by:

Anu Ram