Skip to Content
avatar image
Former Member

JDBC to XML to JDBC

Hi experts,

I am new at using XI and I have the following scenario : JDBC --> XML --> XI --> JDBC

- we generate an XML file containing data from a database

- we use this XML file to reinject the data in the target database via XI

Can any one tell me which is the best approach to design and configure this kind of scenario where the source is an XML file ?

Thanks a lot,

Jamal.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 24, 2008 at 11:36 AM

    use JBDC -XI-JDBC for your Approach...

    sender JDBC itself converts result of SQL Query in XML and feed it XI and based on tat XML, u can do mapping to forward it to Receiver JDBC Adapter

    No Need for File Adapter in your case...

    Edited by: ragu r on Jul 24, 2008 1:37 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2008 at 10:20 AM

    Configure File to JDBC async scenario. Either u may pull the file from any FTP server or any shared drive.

    Regards,

    Prateek

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2008 at 10:20 AM

    Repost

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 24, 2008 at 10:35 AM

    Hi,

    As you said that you have the XML file with data and you need to send it to the Database via JDBC adapter means.

    Use File Adapter to pick the file from the specified Source location and Use JDBC adapter to post the data into Dbase.

    File XI JDBC

    FILE to JDBC Adapter using SAP XI 3.0

    REgards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 24, 2008 at 11:54 AM

    Thanks a lot for your very helpful answers 😉

    I'll configure it that way.

    Ragu_r, to answer your post, we actually choose to use xml to transfer the data even though we could have avoid file adaptater : the xml file will only contain the newly created data.

    Regards,

    Jamal.

    Add comment
    10|10000 characters needed characters exceeded