Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2012-01-02 07:07 AM

How to create a dynamic schema mapping using Talend by reading schema.

Hi All,
i have to develop one such job which will be use to load all kind of file based on my distention table schema . i will have a XML file which has all the details of Input Type , File Type, Delimiter Type, Number of Columns, Columns Validation ( Trim, data Type, remove unwanted char), out put, table schema, columns data type, constraints. etc.
So the thing is whenever i am load file it should pic all the details from config. file, and then apply validation to convert or correct the data types with other validation to remove or format the data. then again read the destination table schema and map with source schema and then load to destination. this is sort of information. so please any one can tell how to and what to use to accomplish this task.
Labels (3)
Labels
1,179 Views
0 Likes
20 Replies
Anonymous
Not applicable
‎2012-01-04 03:08 AM
Author

Hi
Talend Open Studio doesn't support dynamically retrieve schema from an exist XML file.
I'm afraid you have to set all manually.
Besides, Talend Trade Version now supports dynamically retrieve schema from DB and files.
It is still impossible to retrieve from a XML file.
Best regards!
Pedro
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-04 11:22 PM
Author

Thank you Pedro,
i am having enterprise version, and i can use DB also, so is it possible in enterprise version if yes then, can you please suggest any link or demo so i can move ahead.
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-05 12:11 AM
Author

Hi
Even exterprise version can't support you retrieve schema from a XML file dynamically.
Best
Pedro
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-05 01:31 AM
Author

Maybe an experienced developer can create a custom component for this purpose?
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-05 03:59 AM
Author

Is there a sample job or any other sample available that shows us how this dynamically retrieval from DB schemes works?
Regards,
Arno
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-05 04:04 AM
Author

Hi Arno
If you are the user of Commercial Version, you can get some explanation and scenarios in the document.
Serch the chapter 'Dynamic Schema'.
Best regards
Pedro
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-05 04:22 AM
Author

Hi Pedro,
I already know about this possibility, but was hoping there were some new options which make it possible to have dynamic schema, on which you can perform transformations and such.
The Dynamic schema functionality offered by Talend right now does not match our requirements for dynamic schemes I suppose...
Thanks anyway!
Regards,
Arno
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-05 04:27 AM
Author

0683p000009MA9p.png I will communicate with our development team for this feature.
From user respect, creating issue at BugTracker for new feature will be more effective.
Regards,
Pedro
605 Views
0 Likes
Anonymous
Not applicable
‎2012-01-05 04:56 AM
Author

Yeah, maybe we should create an issue... I'll reconsider that!
Thanks
Arno
605 Views
0 Likes