New Release for Data Integration

A new release for Data Integration is now available!

You can now:

  • Create a task to schedule and run an Oracle Cloud Infrastructure Data Flow application from within Data Integration.
  • Use a pivot operator and aggregate function expressions to transform unique row values from one attribute into multiple new attributes in the output.
  • Specify the action to take when no matching row is found or when multiple matching rows are found in the lookup source for a lookup operator.
  • Use a function operator to invoke Oracle Cloud Infrastructure Oracle Functions from within a data flow in Data Integration.
  • Use a SQL statement to define the source and shape of an Oracle Database data entity.
  • Use hierarchical data and complex types in Oracle Object Storage source and target data entities.
  • Fetch the latest schema metadata of existing target and source data entities while working on a data flow.
  • Select attributes to be excluded from output data when creating an expression in the Expression Builder.
  • Use a single output file for the target of an Oracle Object Storage data entity.
  • Create a project that includes data flows in a samples folder.
  • Move data flows, pipelines, and tasks from one project or folder to another project or folder in the same workspace.
  • Save as a copy the data flow, pipeline, or task you are creating or editing.
  • View workspace and Application statistics such as uptime, amount of data processed, and the number of task runs by status within a date and time range.
  • View and analyze task run details. You can:
    • Filter the list of task runs in an Application by a task type and a run status.
    • Compare the performance of two task runs of the same task type.
    • View the parameters and configured values used in a task run.
    • View the duration of a task run and the amount of data processed, and compare the current details with statistics from up to five previous runs.
    • View a pipeline graph with a pipeline task run. In the graph, you can see path and run statuses of tasks and activities from start to finish.

For details, see Data Integration.