I am aware of Dynamic Schema feature in Talend DI as per this article usign MySQL input database.
Howver, I am not able to get this feature working in PostgreSQL RDS AWS (PostgreSQL 9.6.x).
The "Dynamic" does not exist in the drop-down list in Edit Schema dialog under Type.
I am using the "Free" edition of Talend DI version 6.4.1 on Windows 10 64-bit.
Does anyone know if this feature is supported and if so how I can make it work on PostgreSQL RDS on AWS ?
Perhaps I need a different JDBC driver version installed in Talend (how?).
I have a simple requirement like so:
To write and use one single generic Talend job to copy data from any number of PostgreSQL RDS AWS database tables into a file per table or S3 object per table as output.
I don't need any transformations, I just need to get the data out into a delimited file format for loading into Redshift.
It looks like Dynamic Schema would be ideal for it, if it worked in AWS PostgreSQL RDS.
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema