Skip to Content
author's profile photo Former Member
Former Member

JDBC Adapter:- How does it work??

Dear Friends,

I would like to know the nuts and bolts of JDBC adapter.

1.)How does it work internally?Internally what does sap use?

2.)In my scenario i just need to access a sap table so Can i write my Java JDBC program to access it.?

3.)Is there any other way to sent data from Idocs to map to a external database with out using XI.?

thx,

jeevan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2008 at 12:58 PM

    Hi Jeevan,

    As far as the JDBC adapter goes, internally it uses, obviously JDBC (Java DataBase Connectivity). Thus all the calls from this adapter are internally SQL Queries (Either Select, Insert, Update, Delete, Execute Stored Procedure) that are sent using Java JDBC API.

    In Sender Configuration, it needs a Select and an Update query to be configured into it. It polls the External Database at specific intervals (Polling Interval in the Channel Configuration),i.e., it connects to the Database via a JDBC Connection and runs the select query. The data from the query is sent to XI as an XML Document. The update query is used to update the DB such that the same data is not picked again in the next poll. This is generally done through a status field. The select query's Where clause should pick records with one status and the update should change all those statuses so that the select does not pick them again. Click [Here|http://help.sap.com/saphelp_nw70/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm|SAP Help on JDBC Sender Adapter] for more details, including the format of the XML file sent.

    In receiver configuration, the channels creates SQL statements from the XML Document it receives. This can be either Select, Insert, Update, Delete or Stored Procedure Call Statements. This requires you to give the receiver channel an XML Document in a pre-defined Schema. Click [Here|http://help.sap.com/saphelp_nw70/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm|SAP Help on JDBC Receiver Adapter] for more details including correct XML Schemas. Note that the kind of SQL Statement generated (Select, Update, etc) is dependent on the schema provided.

    Hope this was helpful!!!

    Thanks,

    Guru

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2008 at 12:38 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2008 at 12:40 PM

    Hi,

    1. How does it work internally?Internally what does sap use?

    Ans: I am not sure about this, but according to my knowledge by using the derivers only it connects to the Jdbc.

    2. In my scenario i just need to access a sap table so Can i write my Java JDBC program to access it.?

    Ans: No in the sender Jdbc communication channel you mention the drivers and write the select statement.

    3. Is there any other way to sent data from Idocs to map to a external database with out using XI.?

    Ans: If the receiver side is SAP R/3 then by using the ALE we can send.

    For sender side Jdbc adapter

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

    For Receiver side Jdbc adapter

    http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2008 at 12:44 PM

    Hi Kumar,

    1.)How does it work internally?Internally what does sap use?

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

    Database content can be read with any SQL statement, including stored procedures. A special XML format is defined for content coming from the Integration Server or PCK. 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.

    2.)In my scenario i just need to access a sap table so Can i write my Java JDBC program to access it.?

    A) No it is not possible there should some interface so that it can understand that format

    3.)Is there any other way to sent data from Idocs to map to a external database with out using XI.?

    a) Yes u can go with ALE

    Thanx

    Sampath

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2008 at 11:51 AM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.