JDBC Scenario

[Former Member]

Could you please tell me the details required for doing a JDBC scenario.

[Former Member · Accepted solution]

For mode details on jdbc adapter refer the following link .

Edited by: Ajay Kumar on Jul 1, 2008 11:35 AM

[Former Member]

Hi,

FileXI-JDBC--Sync

RFC-JDBCSync

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario

JDBC-File_Using Adapter Scheduling

HTTPXI-JDBC---Sync Process

Regards

Seshagiri

[Former Member]

HI

Refer the links

Adapter: We use this adapter to connect database systems using the JDBC driver. We need to deploy JDBC driver

Details:

http://help.sap.com/saphelp_nw2004s/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

JDBC ADAPTER:

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Use thes step by step guidese

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

https://wiki.sdn.sap.com/wiki/display/XI/XMLFile2XMLFile

tutorial

http://help.sap.com/saphelp_nw2004s/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm for sender side JDBC configuration.

Follow this link

Fine-Tuning the Java Database Connection

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/412290ec-0201-0010-0790-dfd946ef...

inegrating with DATABASES made easy part1

Save time with generalized JDBC datatypes

http://help.sap.com/saphelp_nw04/helpdata/en/21/68f1f860454a2396aa709f9b91a685/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ada5ef-0201-0010-1f8b-c935e444...

http://www.j-nine.com/pubs/optjdbc/optjdbc.html

http://www.experts-exchange.com/Database/MySQL/Q_23300739.html

http://www.onjava.com/pub/a/onjava/2001/12/05/optimization.html

cheers

[Former Member]

JDBC ADAPTER

performing sql joins in xi

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken]

how to install and configure external drivers for JDBC and JMS adapters

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Connecting to MS Access using receiver JDBC Adapter (Without DSN)

JDBC Receiver Adapter -- Synchronous Select u2013 Step by Step

JDBC Stored Procedures

XI : Recent Enhancements to JDBC Adapter

JDBC Adapter execution mode Chained or Unchained ??

Using JDBC Connection Pool in XI Message Mapping

XI JDBC Adapter managing XML fields

RDBMS system integration using XI 3.0 JDBC Sender/Receiver adapter

XI: How-to on JDBC receiver response

calling stored proc s in MAXDB

inegrating with DATABASES made easy part1

Tips and Tutorial for Sender JDBC Adapter

Save time with generalized JDBC datatypes

REGARDS

kummari

http://help.sap.com/saphelp_nw04/helpdata/en/0d/00453c91f37151e10000000a11402f/frameset.htm

[Former Member]

Hi,

hope it's helpful:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards

Patrick

[Former Member]

Example JDBC scenario