on 07-24-2008 11:15 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Repost
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Configure File to JDBC async scenario. Either u may pull the file from any FTP server or any shared drive.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.