List of components that support dynamic schemas

Highlighted
One Star

List of components that support dynamic schemas

I am considering moving from TOS to TIS for a project I am working on, but dynamic schema capabilities would be a big part of the decision.

Which, if any, of the following components support dynamic schemas in TIS?

tFileInputDelimited
tFileOutputDelimited
tPostGresqlInput
tPostGresqlOutput
tPostGresqlSCD
tPostGresqlSCDELT
tMap
tConvertType
tAggregateRow
tWebServiceInput
tWebService


Thanks for the help,
Ben
One Star

Re: List of components that support dynamic schemas

Hi Ben

The components below support dynamic schema.
tFileInputDelimited
tFileOutputDelimited
tPostgresqlInput
tPostgresqlOutput
tMap
tAggregateRow

Regards,
Pedro
One Star

Re: List of components that support dynamic schemas

Thanks, Pedro.
Community Manager

Re: List of components that support dynamic schemas

Hi
The components which support dynamic schema are noted in a text file called supportDynamic.txt, which is located in <Talend studio install dir>\plugin\org.talend.core.tis_x.x.x.rxxxxx.jar. Such as, for example: org.talend.core.tis_5.0.1.r74687.jar.
To open the supportDynamic.txt file and view the supported components, simply follow these steps:
Unzip the org.talend.core.tis_x.x.x.rxxxxx.jar jar.
Go to <org.talend.core.tis_x.x.x.rxxxxx directory path>\resources and open the supportDynamic.txt file.

The list are:
tFileInputDelimited
tFileOutputDelimited
tAccessInput
tAS400Input
tDBInput
tDB2Input
tEXAInput
tFirebirdInput
tGreenPlumInput
tHSQLDBInput
tIngresInput
tInformixInput
tJavaDBInput
tJDBCInput
tLDAPInput
tMaxDBInput
tMysqlInput
tMSSqlInput
tNetezzaInput
tOracleInput
tPostgresqlInput
tPostgresPlusInput
tParAccelInput
tSQLiteInput
tSasInput
tSybaseInput
tVectorWiseInput
tVerticaInput
tTeradataInput
tJava
tJavaFlex
tJavaRow
tLogRow
tMap
tOracleOutput
tMysqlOutput
tMSSqlOutput
tPostgresqlOutput
tAS400Output
tDB2Output
tInformixOutput
tSybaseOutput
tTeradataOutput
tAggregateRow
tSortRow
tFilterRow
tWriteDynamicFields
tExtractDynamicFields

and the list will more and more long in the future.

Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: List of components that support dynamic schemas

Thank you for the more comprehensive list, Shong. I think between the current db/file components and the tJava component support of dynamic schemas it could make the current project solution much more manageable. Reducing hundreds of jobs to around a dozen. Pretty cool.
One Star

Re: List of components that support dynamic schemas

Hello,
i've just installed TOS_DI 6.1.0M2 but i can't find the component that you are mentionning here :
tWriteDynamicFields
Is it available for TOS_DI ? Or just for the entreprise edition ?

Thanks in advance for your help.
Community Manager

Re: List of components that support dynamic schemas

Hi hcountou 
tWriteDynamicFields component is only available in Talend enterprise subscription product.
Best regard
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog