Get started Bring yourself up to speed with our introductory content.

Oracle ETL tools tutorial

In this Oracle Extract, Transform and Load (ETL) tutorial, learn how to evaluate Oracle ETL tools, understand ETL concepts and read advice on ETL basics from our panel of experts.

In this Oracle Extract, Transform and Load (ETL) tutorial, learn how to evaluate Oracle ETL tools, understand ETL concepts and read advice on ETL basics from our panel of experts.

 


Read the other sections of this guide on Oracle business intelligence and data warehousing:

Oracle data warehousing tutorial
Oracle business intelligence guide
Oracle ETL tools tutorial
 


  • Rating ETL tools: Data warehousing expert Ian Abramson provides weighted descriptions of criteria for evaluating ETL tools.

    More on Oracle data warehousing

    Learn about real-time data collection with Oracle data warehouses

    Read about the cost and features of Oracle's Big Data Appliance

    Watch this video of Rich Niemiec discussing Oracle database 12c

  • When managing database environments, integration is key: This tip describes the importance of ETL tools to integration, a key process for managing complex database environments.
  • Questions about ETL and business intelligence tools: A reader asks what ETL tool should be used to ETL data from Oracle to Sybase IQ, and what tool should be used for business intelligence.
  • Can ETL tools handle complicated business logic?: Ian Abramson answers the question, "We extract/transform/load into our data warehouse using SQR programs. One of the main reasons why we have not purchased an ETL tool is that we have complicated business logic embedded in many of our tables. Can ETL tools handle this?"
  • Custom development versus ETL tool: What are the pros and cons of custom development versus an ETL tool?
  • Engine-based versus code-generating ETL tools: Ian Abramson addresses the following remarks: "Why would you choose an engine-based ETL tool only? Code-generating tools (like Oracle Warehouse Builder) are supposed to be faster. You may not want a tool that generates legacy code like COBOL for some obvious reasons, but code-generating tools can achieve a much faster load throughout, as the data does not have to go through the engine bottleneck."
  • Can you use ETL successfully as part of the process to migrate from OS/390 to Unix or NT?: This expert response discusses the merits of using an ETL tool to migrate data from one server to another.
  • A simple way to reorganize a table and release the unused space: This tip offers a simple solution to better manage table space and performance during ETL operations.

 

Next Steps

Spark promises new platform for ETL

Dig Deeper on Oracle business intelligence and analytics

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close