How to generate schema dynamically in talend

One Star

How to generate schema dynamically in talend

Hi,
how to generate the schema dynamically in talend open studio.
i have import the data from sql server to mysql using talend studio.
how to create the schema dynamically in mysql output what are the columns available in sql server input.
i cannot create the table schema at every time in mysql.
Regards,
Abdul Khadir.
One Star

Re: How to generate schema dynamically in talend

Hi,
You can simply copy the schema from mysql component & paste that in SQLServer input component by using copy & paste schema button. You can also use short cut keys
Select all columns (Schema) --> Ctrl + A
Copy --> Ctrl+C
Paste --> Ctrl +V
These short cut does work here for copying the schema from one component to another.
Best Regards,
Mayur
Seventeen Stars

Re: How to generate schema dynamically in talend

There is a dynamic schema column type in the enterprise editions what fits to your needs. This data type is in fact a map which contains all columns and values per row. You can read from a database using this type and write into another database without knowing anything about the schema columns.
Moderator

Re: How to generate schema dynamically in talend

Hi,
Dynamic schema feature is only available in Talend Enterprise Subscription Version. It allows you to design schema with an unknown column structure (unknown name and number of columns).
Please see this related reference: https://help.talend.com/pages/viewpage.action?pageId=5671283.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to generate schema dynamically in talend

Hi,
Is dynamic schema feature  available in  Talend Bigdata Sandbox Tool for trial version or Talend Enterprise Subscription Version ??
if yes is it available for BigData Batch job?? 
Any one from Talend team please reply.
Thanks
Rajnish