cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC to XML to JDBC

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (4)

Answers (4)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

FileXIJDBC

REgards

Seshagiri

prateek
Active Contributor
0 Kudos

Repost

prateek
Active Contributor
0 Kudos

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

Regards,

Prateek