topic Re: How to make dynamic schema in talend in Talend Studio

How to make dynamic schema in talend

_AnonymousUser — Wed, 06 Jan 2016 14:16:28 GMT

We will select parameters at run time and make xml file accordingly.
Need to change the xml structure dynamically.

How do I do that ?

Please help me.

Re: How to make dynamic schema in talend

Anonymous — Thu, 07 Jan 2016 08:38:13 GMT

Hi,
A XML tree is defined at the design time, not the run time.
Best regards
Sabrina

Re: How to make dynamic schema in talend

_AnonymousUser — Thu, 07 Jan 2016 09:54:12 GMT

Hi Sabrina,

Based on requirement I need to pass the Parent and Child name as parameter, and it will invoke all the child(recursively) till leaf node and generate the xml.The node above parent node won't come in the output xml file.

Thanks
Babul

Re: How to make dynamic schema in talend

Anonymous — Thu, 07 Jan 2016 10:34:53 GMT

Hi,
Could you please set an example for us with input and expected result?
Best regards
Sabrina

Re: How to make dynamic schema in talend

_AnonymousUser — Thu, 07 Jan 2016 12:39:23 GMT

Hi,

Take an example

Company --> Project --> Client Project --> Project Details --> Manager --> Employee Details
Company --> Project --> Internal Project --> Project Details --> Manager --> Employee Details

Now if I pass Project as parent and Client Project as child.It will invoke
Project --> Client Project --> Project Details --> Manager --> Employee Details branch.

Now if I pass Project as parent and Internal Project as child.It will invoke
Project --> Internal Project --> Project Details --> Manager --> Employee Details branch.

Either way if I pass pass company as parent and project as child. It will invoke all the information related to client project as well as internal project.
I am to pass those parameter in run time and it will create xml file accordingly.

Thanks
Babul

Re: How to make dynamic schema in talend

Anonymous — Thu, 11 Jul 2019 12:52:46 GMT

We have developed Talend jobs for loading data from Rest API to Flat files , which were being picked up by a framework to load it into Database. Sample entities are Booking, Task, Customer etc.

1. The response from the API is in XML format, so for each and every entity we have developed a Talend job to read the response from the API and write it into a flat file which is feasible for loading into database.
2. To Describe more, we used
tRest--> tExtractXMLField-->tMap-->tFileoutputdelimeted

1. The tRest component will be unique for each object, which includes input parameters defined for each entity, the response will be picked using tExtractXMLField to extract each xml node and mapping to a flat file doing transformations.
2. Here the XML tree is defined for each and every entity in separate talend jobs.
3. What we are looking to do is, we need to place those input xml tree columns in a csv file with entity name as filename, and it should load the file run time and as per the entity specific it should create xml mapping dynamically and after handling transformations using tmap, the file is generated . This is what we are looking for.

Can anyone please help on solution approach.

Thanks,

Priyanka