topic Re: How to generate schema dynamically in talend in Talend Studio

How to generate schema dynamically in talend

Anonymous — Sat, 16 Nov 2024 12:03:41 GMT

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.

Re: How to generate schema dynamically in talend

Anonymous — Tue, 09 Apr 2013 18:29:16 GMT

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

Re: How to generate schema dynamically in talend

Anonymous — Tue, 09 Apr 2013 20:02:17 GMT

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.

Re: How to generate schema dynamically in talend

Anonymous — Wed, 10 Apr 2013 03:42:50 GMT

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

Re: How to generate schema dynamically in talend

Anonymous — Wed, 15 Feb 2017 12:03:45 GMT

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