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.
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
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.
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.
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