You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » How to persist XML to another DB via Web service?
Post a reply
Topic review (newest first)
- ainiesta
- 2012-03-26 12:28:02
Done.
Thank you so much!
- pedro
- 2012-03-26 10:35:14
Hi Ainiesta
Code:
created from multiple Oracle Tables
According to what you said, I think there is no need to generate this XML file.
So I put tOracleInput here.
Or you can use tFileInputDelimited to read this xml file.
tFileInputDelimited-->tWebService-->tSybaseOutput
Save this xml file in a String Column.
Regards,
Pedro
- ainiesta
- 2012-03-26 10:28:54
Thanks Pedro,
By the way, the file to move is in XML file, why do i need tOracleInput and not tFileInputXML?
tOracleInput-->tMap-->tWebService-->tSybaseOutput
Regards,
Ainiesta
- pedro
- 2012-03-26 10:02:49
Hi
What's the function of this webservice?
No. This is not correct.
You'd better create job like this.
tOracleInput-->tMap-->tWebService-->tSybaseOutput
Use tWebService instead of tWebServiceInput and save XML file as a document column in tMap.
The document data type can support you create a XML structure in it.
Regards,
Pedro
- ainiesta
- 2012-03-26 09:59:33
My Problem here is where to put the tWebServiceInput.
so, from tFileInputXML ---> tWebServiceInput ---> tMAP ---> tSybaseOutput
This doesn't work.
- ainiesta
- 2012-03-26 09:32:10
Hi Pedro,
I already have the XML. What i want is to send this XML to Sybase DB via Web Service.
Is this correct?
tFileInputXML --> tWebServiceInput --> tSybaseOutput.
Regards,
Ainiesta
- pedro
- 2012-03-26 08:45:30
Hi
Have you gotten this web service?
If so, you can pass it by tWebService component. The xml file needs to be saved in a document column.
If not, you can use TOS for ESB to create a webservice.
Regards,
Pedro
- ainiesta
- 2012-03-26 05:06:24
Hi There,
I have an XML file (created from multiple Oracle Tables). Now, I want to persist this XML to another DB (Sybase DataBase) via a web service.
Is there any steps i need to accomplish this scenario?
Best Regards.