Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema?

Anonymous — Thu, 05 Oct 2017 04:08:28 GMT

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/ta-p/21702

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

Re: Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema?

ashif2 — Thu, 05 Oct 2017 05:11:13 GMT

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

Re: Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema?

Anonymous — Thu, 05 Oct 2017 05:29:02 GMT

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?

topic Re: Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema? in Talend Studio

Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema?

Re: Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema?

Re: Talend DI 6.4.1 PostgrSQL (RDS AWS) dynamic schema?