Automating Data Migration from Oracle to PostgreSQL Using Talend.

[FSimsek1695133620]

We have a large data warehouse on Oracle that we need to migrate to PostgreSQL using Talend Open Studio. However, we want to avoid creating separate mappings for each table and manually entering table names. Is it possible to write a script or code snippet in Talend to automate this process?

[jlolling]

It is possible but expects the empty tables in the target database.

You can do it with the custom component tPostgresqlTableTransfer. This component expects an arbitrary source connection (like tOracleConnection) and a tPostgresqlConnection.

You simply need the table name of the source and the target and do not have to take care about schema/columns.

You can write a job iterating through your tables and run for every table the transfer.

Please check out the component and the description here: https://github.com/jlolling/talendcomp_tDBTableTransfer

Download of the ready to use component in the Release section at the right side of this page.

These components were developed exactly for this use case.