Sync data from Oracle to Redshift

by

Want to sync data from Oracle to Redshift?

Try Withdata DBCopier, a Oracle to Redshift converter for Windows, Mac, and Linux, Synchronize Oracle to Redshift, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Synchronize data from Oracle to Redshift

Login to Oracle and target Redshift -> Select source Oracle tables -> Set target Redshift tables -> Sync Oracle data to Redshift

Choose source Oracle database and logon.

sync Oracle to Redshift - Choose Oracle and logon

Choose target Redshift database and logon.

sync Oracle to Redshift - Choose Redshift and logon

Click “Wizard – Import All Tables” at task dialog.

sync from Oracle to Redshift - Task Window

then show the wizard.

1. Select source Oracle tables to sync.

sync from Oracle to Redshift - Open source database

2. List target Redshift tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from Oracle to Redshift - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from Oracle to Redshift - upsert synchronization

3. Select Redshift tables to sync.

sync from Oracle to Redshift - select tables

4. Sync Oracle data to Redshift.

sync from Oracle to Redshift - sync


More about Oracle to Redshift converter

See also: