topic Re: [resolved] Oracle -> PostgreSQL in Talend Studio

[resolved] Oracle -> PostgreSQL

_AnonymousUser — Sat, 16 Nov 2024 13:36:24 GMT

Hi!!
Can I use Open Studio to extract data from an Oracle 10.2.0.4 Db and load it on a PostgreSQL 8.2.4?
My Oracle server is RHEL4 and the Postgres one is RHEL5.
Thanks a lot!
Daniela.

Re: [resolved] Oracle -> PostgreSQL

Anonymous — Fri, 15 Jan 2010 17:40:32 GMT

Hi Daniela,
Yes you can; Talend offer components and connectivity to Oracle (version 8i to 11g), to PostgreSQL. Our solution is based on a CodeGenerator engine; it means that the code produce by our solution (Java, Perl, SQL) will be deploy and will be execute on several machine (Linux, Unix, Windows, AIX, ...) in 32 or 64bits architecture.
Best regards;

Re: [resolved] Oracle -> PostgreSQL

_AnonymousUser — Fri, 15 Jan 2010 18:20:48 GMT

Thanks Cantoine!
Do I need to use a graphical interface? ... or is it the same without one?
Thank you!
Daniela.

Re: [resolved] Oracle -> PostgreSQL

Anonymous — Sat, 16 Jan 2010 03:04:19 GMT

Hello

Do I need to use a graphical interface? ... or is it the same without one?

You don't need any other GUI, Talend offers corresponding components to to that, the job looks like:
tOracleInput--main-->tPostgresqlOutput
tOracleInput: extract data from oracle db
tPostgresqlOutput: load data into postgresql db.
Best regards
shong

Re: [resolved] Oracle -> PostgreSQL

_AnonymousUser — Mon, 18 Jan 2010 13:32:02 GMT

Thanks for your answer Shong!!

Re: [resolved] Oracle -> PostgreSQL

_AnonymousUser — Wed, 20 Jan 2010 13:57:23 GMT

Hi All!!
Can Talend be used to interchange data between the Oracle Db and th Postgres Db? I mean, send data from Oracle to Postgres and back from Postgres to Oracle whenever there's an update in the Postgres database.
... Can data be synchronized?
Thank you!
Daniela.

Re: [resolved] Oracle -> PostgreSQL

Anonymous — Wed, 20 Jan 2010 14:28:21 GMT

Hi Daniela,
Talend Integration Suite (our supported version of Talend) has some additional features to help our users to work in collaboration projects, deploy/run/schedule their process on production and also to have more real time and professional features like the CDC (Change Data Capture).
The Change Data Capture in your case would be great; we have the capabilities to extract from the Oracle only the new/updated/deleted rows to load your PostgreSQL; and also to do the same CDC on your PostgreSQL to load the ORACLE in case of Update/Insert/Delete in your PostgreSQL.
This feature is very helpful and easy to use.
Best regards;

Re: [resolved] Oracle -> PostgreSQL

_AnonymousUser — Wed, 20 Jan 2010 14:36:36 GMT

Hi Cantoine!
Is this product free or does it have a license?

Re: [resolved] Oracle -> PostgreSQL

_AnonymousUser — Mon, 25 Jan 2010 20:29:26 GMT

Hi Cantoine!!
I've come to the conclusion that CDC is licenced.
Does Integration Suite have anything that would work in some way like CDC?
We are looking for non payed software.
Thanks a lot!
Daniela.

Re: [resolved] Oracle -> PostgreSQL

Anonymous — Tue, 26 Jan 2010 03:46:56 GMT

Hello Daniela

Does Integration Suite have anything that would work in some way like CDC?
We are looking for non payed software.

Talend Integration Suite is commerial version, you need pay for it.
Best regards

shong

Re: [resolved] Oracle -> PostgreSQL

_AnonymousUser — Wed, 27 Jan 2010 13:06:14 GMT

Oh! I'm sorry... I ment Open Studio!!
Does it have anything that would work in some way like CDC?
Thanks,
Daniela.

Re: [resolved] Oracle -> PostgreSQL

Anonymous — Wed, 27 Jan 2010 13:20:00 GMT

Hello

Does it have anything that would work in some way like CDC?

No, unfortunate!
Best regards

shong

Re: [resolved] Oracle -> PostgreSQL

_AnonymousUser — Wed, 27 Jan 2010 15:27:41 GMT

Ok!
Thanks a lot!
Daniela.