You are not logged in.
I wanted to start my own joblet/component (don't really know the difference between the two) and i'm kind of stuck because of the DYNAMIC SCHEMA thing.
What i want to do ?
- Extract some data from a database into a CSV file on my server.
- Send the file via mail
- Delete the file
But the thing is that i don't want to do the guess schema each time. Because it changes the joblet. So i was wondering if there was a component that could read a schema. Or extrapolate it. The same way that TALEND itself asks if you want to recover the schema from the previous component.
Is there a way to do that ?
Or is there a way to emulate "click and validate" on the guess schema button for a component ?
Thanks by advance.
There's no way for what I know to have a dynamic schema inside Talend, except the actual dynamic schema feature in Talend Enterprise (the subscription version of Talend). This feature allows you to go over the fact that you need to define a schema. I've used it to do some db migrations like that:
tDbInput tDbInput tDbOutput
Request to Get Table Names ---->Iterate ----> Dynamic Schema ---------------> Create Table
For a Db Select * from table_name
Pretty useful :-)
Then you should be able to see it. Just create one column in your schema, and choose as a type the type "Dynamic".
This is what I'm saying...
Say you have a table with 3 columns:
And you want to load the content of that table into a file.
Use you DbInput, and in the schema just put a single column (the name doesn't matter) of type "Dynamic". All your columns will automatically be stored into that column.
Do you know if there's any chance this Dynamic functionality as it is available to (some) database input components, will be ever made available for file input components (tFileInputExcel for example)?
To answer both of you:
Indeed the dynamic type is currently limited to some components only. I don't have the estimate right now on when they plan on making it available at a larger scale.
Arno: I think it's available for tFileInputDelimited, so you could transform your excel files in csv files and use this component.
ffwrude: I guess then it means that the Joblet components aren't developed with the Dynamic type feature in them yet! If you want to use Dynamic types, you can't use Joblets.
Both of you could make a feature request on our bugtracker to get that changed. Usually our developments are based on the customer needs, and by making the request on our bugtracker you will have an estimate of which release the feature will be included in.