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 integration using database dump files instead of connectors & SQL

Received Response
edited Feb 16, 2019 6:15PM in Autonomous Database 1 comment


Need advice or examples for data migration and/or integration at the full database level, a bit like ELT from cloud transactional to cloud analytic.

I saw there's a tool in ADW called DBMS_CLOUD that I believe is the most flexible way of loading data exported from another database environment or technology.  There's also an entire appendix of how to move from Amazon to Oracle using connectors.  Those two methods have pros and cons such as SQL needed to coerce data types to match Oracles and ingress and egress costs to have the client connector move data.  Pros are How would I move from PostgreSQL.  I'm not sure if GUI tools have really become cloud capable or native enough for cloud to cloud migration but

Howdy, Stranger!

Log In

To view full details, sign in.


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