Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema?

Hello everyone,

 

I am aware of Dynamic Schema feature in Talend DI as per this article usign MySQL input database.

 

https://community.talend.com/t5/Troubleshooting-Development/How-to-process-changing-data-structure/t...

 

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.

 

Thanks

 

Labels (1)
1 Solution

Accepted Solutions
ashif2
Creator II
Creator II

dynamic schema feature is available only in Talend Enterprise Edition not on Open Studio.. 

View solution in original post

2 Replies
ashif2
Creator II
Creator II

dynamic schema feature is available only in Talend Enterprise Edition not on Open Studio.. 

Anonymous
Not applicable
Author

many thanks,

it appears that writing a Java/JDBC Generic-Table-Unload library and plugging it into "free" Talend DI would be the next best option?

Opinions? Thoughts?