What are Data Integration Application Templates


You can create an application by using an application template. Application templates are predefined tasks with parameters that provide out-of-the-box data integration solutions for common use cases.

Application templates enable you to quickly build and test your own applications. The out-of-the box templates and their specific purposes are:

Fusion Applications (BIP) to Autonomous Data Warehouse Incremental Load (Customer Managed): Implements a pipeline with SQL tasks and an integration task that use metadata stored in an ADW schema to pull incremental data from a BIP report and load into an ADW data entity.
Oracle Database to Autonomous Data Warehouse Incremental Load (Customer Managed): Implements SQL tasks, and integration and pipeline tasks that you can use to perform incremental loads from an Oracle Database source into an Autonomous Data Warehouse target after you remap data assets and connections.
Oracle Object Storage Management: Implements REST tasks that you can use to perform specific operations on Object Storage buckets and files. Each task has configured parameters for specifying the necessary resources that the REST endpoint uses to perform the operations such as creating or deleting a bucket, and copying or deleting a bucket object.
Load Files from Oracle Object Storage into ADW: Implements tasks that you can use to load data from different types of source files in Object Storage into an Autonomous Data Warehouse target. The file types are Avro, CSV, JSON, and Parquet. Each task has configured parameters for the source data asset, connection, bucket, and file (data entity ), and the target data asset, connection, schema, and data entity.
Oracle Vision Document: Implements REST tasks for analyzing and classifying images in Object Storage using Document AI features in Oracle Cloud Infrastructure Vision. The tasks use configured parameters to allow selection of namespace, compartment, bucket, and filename at runtime.
Oracle Vision Image: Implements REST tasks for detecting and classifying images in Object Storage using Image Analysis features in Oracle Cloud Infrastructure Vision. The tasks use configured parameters to allow selection of namespace, compartment, bucket, and filename at runtime.
Oracle Data Safe Masking: Implements REST tasks in pipelines to identify entity attributes that are subject to masking, and then mask the sensitive attributes based on the masking policy that is identified.
 Note



For detailed descriptions and prerequisites, and information about how to use a template, click Preview on the template that is available from the Create application page.

After you create your application by using a template, you can do the following from the application details page:

View the predefined tasks and their configured parameters: On the Tasks list, click a task name and then click View definition. On the task definition page, click View in the parameters section.

On the definition page of an integration task, you can click Save as to save a copy of the task.

Open the associated data flow of an integration task: On the task definition page, click the data flow name. Data Integration displays the data flow in read-only mode. To save a copy of the data flow, click Save as.

Open the associated pipeline of a pipeline task: On the task definition page, click the pipeline name. Data Integration displays the pipeline in read-only mode. To save a copy of the pipeline, click Save as.

Run the tasks: On the Tasks list, select Run from the Actions menu for the task you want to run. Data Integration prompts you to provide values for the task's configured parameters.

Schedule task runs: On the Tasks list, select Schedule from the Actions menu for the task you want to schedule task runs.

If supported by the template, you can use the References list to:

View and map the data assets, connections, and schemas that are referenced by the tasks in the application.
View and map the tasks that are referenced by the pipelines in the application.