Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Data integration using database dump files instead of connectors & SQL — Cloud Customer Connect
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
11
Views
1
Comments
edited Feb 16, 2019 6:15PM in Autonomous Database 1 comment

Content

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.

Register

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