Load Data into the Warehouse

Perform these tasks to load data into Oracle Autonomous Data Warehouse.

  1. Consider these factors when selecting the pipeline tool for populating the warehouse with data:
    1. The data volume for the initial load.
    2. The data volume for incremental loads.
    3. The frequency of incremental loads.
    4. The complexity level of required transformations.
    5. The ETL tool in place, if any.
  2. Based on the factors you considered while selecting the pipeline tool, evaluate these three options to select the tool:
    • Data Flow: This is a utility within the visualization area of Oracle NetSuite Analytics Warehouse that you can use to move data from various sources into the tables in the destination schema of Oracle Autonomous Data Warehouse. See Curate Your Data Using Data Flows.
    • Data Integration on Oracle Cloud Infrastructure: Data Integration is a fully managed, server-less, and native cloud service that helps you with common extract, load, and transform (ETL) tasks such as ingesting data from a variety of sources, cleansing, transforming, and reshaping your data, and efficiently loading it to target data sources on Oracle Cloud Infrastructure. See Data Integration.
    • Custom ETL: You can use any third-party ETL tool to move data into Oracle Autonomous Data Warehouse.
  3. When the pipeline tool is ready, use it to load the data into Oracle Autonomous Data Warehouse.