Deploy the Design and Execute the Data Integration Solution

Deployment is the process of copying the relevant metadata and code you generated in the Design Center to a target schema. This procedure is necessary to enable the target schema to execute ETL logic such as mappings.

To deploy and execute the generated code: 

1. Deploy objects from either the Design Center or Control Center Manager.

   In this step, you define the objects in the target schema. You need do this only once.

   The simplest approach is to deploy directly from the Design Center by selecting an object and clicking the Deploy icon. In this case, OWB deploys the objects with the default deployment settings.

   Alternatively, if you want more control and feedback on how OWB deploys objects, from the Design Center menu select Tools, then Control Center Manager.

   Whether you deploy objects from the Design Center or the Control Center Manager, be sure to deploy all associated objects. For example, when deploying a mapping, also deploy the target data objects such as tables that you defined and any associated process flows or other mappings.

   For more information, see Deploying to Target Schemas and Executing ETL Logic in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.

2. Execute the ETL logic to populate the target warehouse.

   In this step, you move data for the first time. Repeat this step each time you want to refresh the target with new data.

   You have two options for executing the ETL logic in mappings and process flows. You can create and deploy a schedule as described in Defining Schedules, or you can execute jobs manually as described in Starting ETL Jobs in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide.