Data migration from Oracle to Postgres

Highlighted
One Star

Data migration from Oracle to Postgres

Hello, is it possible to use Talend to migrate from Oracle to Postgres?
The schema includes about 100 tables and there are tables with BLOB data type.
If this is possible, it will migrate all the objects including indexes, procedures, triggers, etc..?
Highlighted
Moderator

Re: Data migration from Oracle to Postgres

Hi,
So far, we can support for migration tables from DB to DB.
See the related forum Forum 23678.
Forum18793, Forum 18572
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: Data migration from Oracle to Postgres

Thanks Sabrina for your reply, i succeeded in the migration of the table. In the output table (Postgres) now i have a column of bytea type but it's in an encrypted format. Is there any way to verify if the column exported contains exactly the data imported from the source? (in origin the clob column contains XML file)
Thank you again
Highlighted
One Star

Re: Data migration from Oracle to Postgres

Hi,
is there any way to migrate from one oracle db to another oracle db using dynamic schema in talend even when the tables had BLOB or CLOB datatypes data. and in case there are some null data in those columns.

Thanks,
Hari Babu
Highlighted
Moderator

Re: Data migration from Oracle to Postgres

Hi HariBabu_N,
Dynamic schema feature is only available in Talend Enterprise Data Integration, it allows you to design schema with an unknown column structure (unknown name and number of columns).
You can see the related article about How to process changing data structure?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: Data migration from Oracle to Postgres

Hi Sabrina,
I had completed the migration using Dynamic schema. But the job is not processing the BOLB or CLOB data items. So i am looking for the solution in case when we use dynamic schema and one table has clob/blob data type..

Thanks ,
Hari
Highlighted
Moderator

Re: Data migration from Oracle to Postgres

Hi,
But the job is not processing the BOLB or CLOB data items

What's the error? I have never migrated table with BOLB or CLOB data items before.
Without "dynamic schema", usually set the type as Byte[] and DB type as Blog on the schema of tOracleInput, convert the string to byte[] on tMap.
see my screenshots.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
One Star

Re: Data migration from Oracle to Postgres

can you help me resolve this ?
Highlighted
Moderator

Re: Data migration from Oracle to Postgres

Hi bishwajeet,
Could you please give us more information about your current job requirement and the problem you are getting?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog