https://community.qlik.com/t5/Talend-Studio/Automating-Data-Migration-from-Oracle-to-PostgreSQL-Using-Talend/m-p/2362263#M126431 <P>It is possible but expects the empty tables in the target database.</P><P>You can do it with the custom component tPostgresqlTableTransfer. This component expects an arbitrary source connection (like tOracleConnection) and a tPostgresqlConnection.</P><P>You simply need the table name of the source and the target and do not have to take care about schema/columns.</P><P>You can write a job iterating through your tables and run for every table the transfer.</P><P>Please check out the component and the description here: <A href="https://github.com/jlolling/talendcomp_tDBTableTransfer" alt="https://github.com/jlolling/talendcomp_tDBTableTransfer" target="_blank">https://github.com/jlolling/talendcomp_tDBTableTransfer</A></P><P>Download of the ready to use component in the Release section at the right side of this page.</P><P>These components were developed exactly for this use case. </P> Thu, 19 Oct 2023 09:13:55 GMT jlolling 2023-10-19T09:13:55Z https://community.qlik.com/t5/Talend-Studio/Automating-Data-Migration-from-Oracle-to-PostgreSQL-Using-Talend/m-p/2362262#M126430 <P>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?</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 21:19:28 GMT https://community.qlik.com/t5/Talend-Studio/Automating-Data-Migration-from-Oracle-to-PostgreSQL-Using-Talend/m-p/2362262#M126430 FSimsek1695133620 2024-11-15T21:19:28Z https://community.qlik.com/t5/Talend-Studio/Automating-Data-Migration-from-Oracle-to-PostgreSQL-Using-Talend/m-p/2362263#M126431 <P>It is possible but expects the empty tables in the target database.</P><P>You can do it with the custom component tPostgresqlTableTransfer. This component expects an arbitrary source connection (like tOracleConnection) and a tPostgresqlConnection.</P><P>You simply need the table name of the source and the target and do not have to take care about schema/columns.</P><P>You can write a job iterating through your tables and run for every table the transfer.</P><P>Please check out the component and the description here: <A href="https://github.com/jlolling/talendcomp_tDBTableTransfer" alt="https://github.com/jlolling/talendcomp_tDBTableTransfer" target="_blank">https://github.com/jlolling/talendcomp_tDBTableTransfer</A></P><P>Download of the ready to use component in the Release section at the right side of this page.</P><P>These components were developed exactly for this use case. </P> Thu, 19 Oct 2023 09:13:55 GMT https://community.qlik.com/t5/Talend-Studio/Automating-Data-Migration-from-Oracle-to-PostgreSQL-Using-Talend/m-p/2362263#M126431 jlolling 2023-10-19T09:13:55Z