on 04-24-2007 7:25 AM
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
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
Deploying and Removing JDBC Drivers
Regards
Chilla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Phani,
Check this..
/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter
cheers,
Prashanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Message was edited by:
Anu Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.