About Data Pipeline Options to Extract and Load

Use the information in this section to assess the data pipeline options to extract and load data.

Pipeline Advantages Limitations License and Fees
Data Flow and Data Preparation
  • Easy to use. Drag and drop data to create and schedule data flows.
  • No SQL code needed.
  • Select from a long list of connectors.
  • Intended for repetitive data requests.
  • Supports all standard databases.
  • Can support only a few gigabytes of data. Limited to 1.1 million rows.
  • Incremental: Only based on one specific field.
 Embedded in Oracle Analytics Cloud.
Oracle Cloud Infrastructure Data Integration Supports large volumes of data. Need to know how to browse data in Data Integration. Additional license and fees required.
Existing ETL tool, if any Ease of use, comfort and convenience. General limitations of connectors. Owned by customers.