Talend community forum / How to persist XML to another DB via Web service?

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.

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 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

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.

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 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: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 12:28:02

Done.
Thank you so much!

Announcement

Unanswered posts

#1 2012-03-26 05:06:24

How to persist XML to another DB via Web service?

#2 2012-03-26 08:45:30

Re: How to persist XML to another DB via Web service?

#3 2012-03-26 09:32:10

Re: How to persist XML to another DB via Web service?

#4 2012-03-26 09:59:33

Re: How to persist XML to another DB via Web service?

#5 2012-03-26 10:02:49

Re: How to persist XML to another DB via Web service?

#6 2012-03-26 10:28:54

Re: How to persist XML to another DB via Web service?

#7 2012-03-26 10:35:14

Re: How to persist XML to another DB via Web service?

Code:

#8 2012-03-26 12:28:02

Re: How to persist XML to another DB via Web service?

Board footer