Data Transforms enhancements

Use SQL Queries to Generate Data Flow

You can use SQL statements to build a data flow. The Data Transforms SQL Parser analyzes the SQL statement, generates the data flow, and displays it on the Design Canvas.

See Generate Data Flow from SQL Statements.

Materialized Views in Data Flows

Data Transforms supports the use of materialized views in a data flow. You can create a materialized view data entity, define the refresh settings of the view, and use it as a source in a data flow.

See Create and Use a Materialized View in a Data Flow.

Data Load support for Oracle Business Intelligence Cloud Connector

You can use an Oracle Business Intelligence Cloud Connector (BICC) connection to load data to Oracle Autonomous Database. For BICC data loads, you have two options - Incremental Merge, which updates the data in the selected column by comparing the source table with the target table and Incremental w/Deletes that deletes records from the target table that are no longer available in the source table.

See Create an Oracle Business Intelligence Cloud Connector Connection.

Data Load Job Details Enhancements

The Job Details page for data load jobs includes the Rerun Selected Tables option that allows you to rerun the job for selected tables. This is useful when you want to reload only a few tables instead of rerunning the entire data load job.

See Create and Manage Jobs.