on 03-07-2008 2:05 PM
Explain in detail about jdbc adapter framework?
did you seach in HELP Sap?
why do you post this kind of dump question?
you can do it by yourself??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the jdbc interface can read the statements like select , insert , delete , alter commands with in the db
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.