Skip to main content
Feedback

Oracle walkthrough

Working with Oracle

Step 1: Creating a connection

Make sure you have appropriate credentials for establishing a connection with Oracle database server.

Step 2: Choose the Data Flow mode

Once you have successfully established a connection to Oracle, select the Data Flow mode to load data into a Target. You can choose from two available options:

  • Multi-Tables: Simultaneously load multiple tables from Oracle to your desired Target.
    • Standard Extraction - This Data Flow mode maps, transforms, and loads data from multiple tables into a unified schema. It uses SQL queries for transformations, and you can schedule it or trigger it manually.
    note

    Data Integration supports the use of Tables, Views, Material Views, and Synonyms Objects within Oracle. Synonyms enable you to incorporate data from synonym table names in Oracle databases into your Data Flows. Synonym tables are accessible in Standard Extraction mode. The Oracle's synonym feature is not compatible with Change Data Capture (CDC).

    If the schema does not display properly, try reloading the metadata and ensure the connection is correctly pointing to the appropriate database.

    • Advanced Options - Replace Newline Characters: This replaces newline characters with a selected replacement value or a custom value of your choice. Default Behavior: If you do not enable this option, Data Integration replaces newline characters with spaces by default.

    • Change Data Capture (CDC) - This mode monitors the Source database logs, capturing and transforming changes in real-time. This ensures minimal data loss and low-latency transfer when loading the transformed data into the target database, keeping it in sync with the Source.

  • Custom Query: Create a customized query and import it into your designated Target.

Step 3: Run the Data Flow

Once you have successfully configured the Data Flow mode, selected the extraction method, and set up the scheduling, you are ready to start the Data Flow and its operation.

Limitation

Data Integration does not support quoted table or column names that use lowercase or mixed case.

On this Page