You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

data loading

in Database 1 comment

Hi Masi,


For one of our new OCI onboarding projects, we have a requirement to load data only once from a PostgreSQL database into an Oracle database. The PostgreSQL database will be decommissioned after the migration.
We initially explored a DB Link approach from Oracle to PostgreSQL, but are encountering datatype conversion issues. We also noticed PostgreSQL has options such as Foreign Data Wrappers (FDW) and other connectors that may be able to push data into Oracle.
In this scenario, would you recommend:
Pulling data from PostgreSQL into Oracle (for example, via DG4ODBC/DB Link)?
Pushing data from PostgreSQL into Oracle using PostgreSQL-side tools/connectors?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!