cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC adapter

Former Member
0 Kudos

Explain in detail about jdbc adapter framework?

Accepted Solutions (1)

Accepted Solutions (1)

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

did you seach in HELP Sap?

why do you post this kind of dump question?

you can do it by yourself??

Former Member
0 Kudos

i want step by step scenario of this.

Answers (4)

Answers (4)

Former Member
0 Kudos

the jdbc interface can read the statements like select , insert , delete , alter commands with in the db

Former Member
0 Kudos

In addition to above replies, first you need to deploy the JDBC driver to work with it.

Go through "How to install & configure JDBC dirvers" as mentioned below.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Former Member
0 Kudos

Hello,

please have a look here:

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

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

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Regards

Patrick

Former Member
0 Kudos

The JDBC adapter enables you to connect database systems to the Integration Server. The adapter converts database content to XML messages and the other way around.

A special XML format is defined for content coming from the Integration Engine. This format enables SQL INSERT, UPDATE, SELECT, DELETE, or stored procedure statements to be processed. A message is always processed in exactly one database transaction

JDBC Drivers

SQL:com.microsoft.jdbc.sqlserver.SQLServerDriver

Oracle: oracle.jdbc.driver.OracleDriver

Connection

SQL - jdbc:microsoft:sqlserver://<server>:1433;DatabaseName=

<DB Name>

Oracle - jdbc:oracle:thin:@<ip address of the server>:1521:<s06>