jdbc adapter

[Former Member]

hi all,

at what situations jdbc adapter is used?

[Shabarish_Nair · Accepted solution]

in case you want to connect to any database system, the JDBC adapter is used.

for more ref: http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

[Former Member]

Hi Keerthi,

We can devide xi adapters into following four categories

Technical Adapter, such as HTTP, SOAP, JDBC, Mail, etc.

SAP Application Adapters, such as RFC and IDoc.

Non-SAP Application Adapters, such as Oracle, Seibel, PeopleSoft, etc.

Industry Standard Adapters, such as CIDX, RosettaNet, EDI, etc.

We use this adapter to connect database systems using the JDBC driver. We need to deploy JDBC driver Deploy JDBC Driver using the link

http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

U will find all the details including how to configure sender JDBC adapter + receiver JDBC adapter:

http://help.sap.com/saphelp_nw04/helpdata/en/e2/cb610b230c9c4cb4b800989196b63a/frameset.htm

U can Start your hands on with:

FILE to JDBC Adapter using SAP XI 3.0-

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

Hope this was helpful.

kanan

[prateek]

To connect to databse, JDBC adapter is used. Database e.g Oracle, SQL, MS Access, MaxDB

It could be used

1. at the sender end

2. at the receiver end

3. as a part of lookup from the database through mapping

Regards,

Prateek

[Former Member]

Hi ,

When you want to read or insert/update data into database you should use the jdbc adapter . Also when you want to do the lookup into data base table from UDF( user defined function) you should use jdbc adapter .

For mode details on jdbc adapter refer the following link .

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

Thanks ,

Suvarna

Award pts if it helps you .