topic Re: Data migration from Oracle to Postgres in Talend Studio

Data migration from Oracle to Postgres

Loneliness — Mon, 03 Jun 2013 09:33:25 GMT

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..?

Re: Data migration from Oracle to Postgres

Anonymous — Mon, 03 Jun 2013 10:22:31 GMT

Hi,
So far, we can support for migration tables from DB to DB.
See the related forum https://community.talend.com/t5/Design-and-Development/resolved-DB-migration-using-dynamic-schema/td-p/61627.
https://community.talend.com/t5/Design-and-Development/complete-migration-from-oracle-to-sql-server/td-p/106789, https://community.talend.com/t5/Design-and-Development/Copy-a-database/td-p/106219
Best regards
Sabrina

Re: Data migration from Oracle to Postgres

Loneliness — Mon, 03 Jun 2013 13:37:51 GMT

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

Re: Data migration from Oracle to Postgres

_AnonymousUser — Wed, 17 Jul 2013 05:44:49 GMT

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

Re: Data migration from Oracle to Postgres

Anonymous — Wed, 17 Jul 2013 06:41:38 GMT

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

Re: Data migration from Oracle to Postgres

_AnonymousUser — Wed, 17 Jul 2013 09:00:48 GMT

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

Re: Data migration from Oracle to Postgres

Anonymous — Thu, 18 Jul 2013 04:40:17 GMT

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

Re: Data migration from Oracle to Postgres

Anonymous — Wed, 10 Aug 2016 10:58:33 GMT

can you help me resolve this ?

Re: Data migration from Oracle to Postgres

Anonymous — Thu, 11 Aug 2016 10:55:16 GMT

Hi bishwajeet,
Could you please give us more information about your current job requirement and the problem you are getting?
Best regards
Sabrina