Qlik Talend Data Integration: Which Talend components provide the Dynamic Schema feature?

[TalendSolutionExpert]

Dynamic Schema is an advanced feature in Talend subscription products. It allows you to design Jobs without having to know the structure (names, types, and number of columns) of the data to be handled. You can find more information about this feature at How to process changing data structure?

However, not every component supports the dynamic schema feature. You will get an error as shown below if you select the Dynamic type for a column in the schema of a component that does not support this feature.

You can find a list of components that support the Dynamic type by following these steps:

1. Go to the Talend Studio installation dir/plugins/ directory and find the jar file org.talend.core.tis_x.x.x.rxxxxxx.jar (for example: org.talend.core.tis_5.6.1.20141207_1530.jar).

2. Extract the the resources folder from the jar file,

3. Open the text file supportDynamic.txt in the folder. You will see a list of components that support the Dynamic type, such as:

tFileInputDelimited
tFileOutputDelimited
tAccessInput
tAS400Input
tDBInput
tDB2Input
tEXAInput
tFirebirdInput
tGreenPlumInput
tHSQLDBInput
tIngresInput
tInformixInput
tJavaDBInput
tJDBCInput
tMaxDBInput
tMysqlInput
tMSSqlInput
tNetezzaInput
tOracleInput
tPostgresqlInput
tPostgresPlusInput
tParAccelInput
tSQLiteInput
tSasInput
tSybaseInput
tVectorWiseInput
tVerticaInput
tVerticaOutput
tTeradataInput
tJava
tJavaFlex
tJavaRow
tLogRow
tMap
tOracleOutput
tMysqlOutput
tMSSqlOutput
tPostgresqlOutput
tAS400Output
tDB2Output
tInformixOutput
tSybaseOutput
tTeradataOutput
tAggregateRow
tSortRow
tFilterRow
tWriteDynamicFields
tExtractDynamicFields
tUnite
tUniqRow
tRunJob
tReplicate
tAggregateSortedRow
tFilterColumns
tJoin
tSampleRow
tHashInput
tHashOutput
tFileInputPositional
tFileOutputPositional
tAmazonMysqlInput
tAmazonMysqlOutput
tAmazonOracleInput
tAmazonOracleOutput
tSAPHanaInput
tSAPHanaOutput
tLDAPInput
INPUT
OUTPUT