#1 2011-06-16 22:49:33

alau
Guest

Migrate Data from other databases like Oracle to Greenplum

Hi,

I am working on Migrating the data from other databases like Oracle to the PostgreSQL Greenplum database in Job.

What I am thinking to do is using tOracleInput as input with a tMap and then tGreenplumOutput as output.

Any suggestions/tips on this?

Thanks,
A

#2 2011-06-17 03:52:22

shong
Talend team
Registered: 2007-08-29
Posts: 10353
Website

Re: Migrate Data from other databases like Oracle to Greenplum

Hi
Yes, you are on the right track, use a tOracleInput to query records from Oracle, do some transform on tMap if needed, and then load them  into target database Greenplum with tGreenplumOutput.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Online

Board footer

Powered by FluxBB