Conversion of file types dynamically using talend

[Nadz-Talend]

Hi

I am new to talend and I am finding a Transformation service fits with our organization.

My requirement is mainly transforming a given file to particular format.

Ex: JSON to XML

XML to JSON, etc

I need to expose a talend job as a common service and when running this service user should be able to give file path, file type and target file type.

Can I do this using talend?

Is there any way to define dynamic schema for xml and json files?

Is there any good documentations regarding those requirements.

Highly appreciate your response regarding this.

Thank You

[Anonymous]

Hello,

Are you trying to achieve this goal in a standard job(Data Integration) or talend ESB product with mediation route?

With talend data integration, you are able to convert XML to JSON with below design

tFileInputXML--main--tWriteJsonField--main-->tFileOutputDelimited

For JSON to XML, read your json file using tFileInput and pass to the tHmap and then create the XML.

Please give us more information about your input source and background which will be helpful for us to assistant you.

Best regards

Sabrina

[Nadz-Talend]

Hi

Thank you for your prompt response.

Since I need to expose the job as a web service, now I downloaded talend ESB but it is only showing 'standalone job' as the build type.

It is not showing 'Axis Web Services (WAR)' in build type dropdown.

I'm using talend ESB 7.3.1 version.

What is the reason for that?

Please answer to below questions also.

1. Is there any possibility for user to define their schema in run time using talend open studio? (ESB or Data Integration)
2. Is there any difference in designing jobs for transformation between talend ESB and talend Data Integration?
3. Is there any possibility to use talend open studio as a web plugin?

[Nadz-Talend]

@Xiaodi Shi​ 

Could you please tell how can I expose a talend job as a service.

talend ESB is only showing standalone job as the build type.

Other question is Is there any possibility to use talend open studio as a web plugin?

Highly appreciate your response regarding this.

[gjeremy1617088143]

Hi Nadz, if you use a ESB component like tResRequest to build a Restfull service, you can build it in a Bundle osgi instead of a Job standalone and you can deploy it on a Talend runtime to expose your job as a service.

[Anonymous]

Hello,

The Axis WebService (WAR) and Axis WebService (ZIP) build job types have been deprecated since V 6.5.1.

You can not define schemas at run time. The schemas must be defined during design, not at run time.

Note: If you are using Talend Enterprise software such as Talend Data Integration, you can define a dynamic column to map different schemas. For more information, refer to How to process changing data structure?.

For your last question, what's your job requirement? Could you please give us more description about web plugin?

Best regards

Sabrina

Best regards

Sabrina

[Nadz-Talend]

Ok Thanks.

I want to integrate talend open source tool with our web deployment.

Then, our users can create their own jobs when they need.

So, is talend open source tool exposed as a web plugin

[Nadz-Talend]

Ok Thanks, I'll try this

[Nadz-Talend]

@guenneguez jeremy​ If I explain my requirement,

Users of the our systems send the requests.

Some times we need to transform the request contents Ex: Json->Xml or XML->Json or any other transformation

What I am trying to do is creating a talend job which is exposed as a rest service and our system calls to that rest service when we need to do data transformation.

can I achieve this type of solution using talend open studio.

[Nadz-Talend]

@Xiaodi Shi​ If I explain my requirement,

Users of the our systems send the requests.

Some times we need to transform the request contents Ex: Json->Xml or XML->Json or any other transformation

What I am trying to do is creating a talend job which is exposed as a rest service and our system calls to that rest service when we need to do data transformation.

can I achieve this type of solution using talend open studio.