- Migration Workbench
- You can use Oracle Warehouse Builder (OWB) or any ETL toolset to move data between non-Oracle and Oracle databases.
- Unload data into CSV flat files from the non-Oracle source and load it into Oracle using SQL*Load, the Oracle external table feature or any ETL toolset (like OWB, Informatica, etc.).
Dig Deeper on Oracle data and application integration
Related Q&A from Harish Harbham
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server. Continue Reading
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication. Continue Reading
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?" Continue Reading