You are not logged in.
I have seen a similar question asked a number of time across the forum with no response, therefore I wanted some clarity if this is a supported use case or not for Talend Open Studio.
I need to do what ever is required to support ETL jobs from standard data sources (DBs Web service etc) into a custom service, I want to be able to use Talend for this. However to accomplish this I need Talend to be able to work with my custom data store.
As I understand it I can write a simple component that allows a Talend job to be defined to pass (and transform) the data through.
My data store is extensible, as such the schema for the data stored can change.
Logically this is a similar scenario to the supported data stores, Talend allows a DB connection to be created which then supports extraction of the table schemas into the tool for use in a Job.
I would like to be able to do a similar thing for my custom data source, to retrieve a schema and populate it in the Metadata view in TOS, and link it as appropriate to input and output components. One of the key features is that the user building the job should be mapping input data to the schema retrieved from my custom data source.
My question is, is this supported in TOS?
If not , then what is Talendís view on this kind of use case?
Last edited by jpsmith (2011-11-01 15:49:09)
I am not sure how the data stored changes, it is the database type or the table schema changed? You can create a JDBC connection under metadata for all the database types which support JDBC way, but you have to change the connection information each time if the database type changes. If it is the changes on table schema, you can define a dynamic schema, this feature is only available in commercial version Talend Integration Suite.
You are able to retrieve the schema of table and populate it in the metadata, link it as appropriate to input or output component by drag and drop it to the job editor.
I am new to Talend. Have successfully connected to local Access DB. However, when I try to add a 2nd DB connection to a SQL Database, nothing happens after the right clich on Db Connections and then Create connection. Any ideas?