Use to generate DDL scripts for your data models.
When a diagram or data model is designed or modified in Oracle Data Integrator, it may be necessary to implement the data model or the changes in the data server that contains the model implementation. This operation can be performed using DDL scripts generated by Oracle Data Integrator. The DDL scripts are generated in the form of procedures that contain DDL commands (create table, alter table, and so forth). This procedure may be executed on the data server to impact the changes.
Note: DDL scripts are generated based on the Action Group templates. Check that your have the appropriate action group for the technology of the model before starting DDL scripts generation. The action groups appear in the Topology Navigator.
Specify the following parameters in the Generate DDL Editor:
Action Group
The action group to be used to generate the DDL script.
Procedure Name
The name of the generated procedure.
Generation Folder
Oracle Data Integrator project folder in which the procedure is created.
You can click Search, to search for the project folder or click Clear Folder Selection if you want to remove the folder specified in this field.
Hierarchical/Linear View
The differences (new, deleted or modified) that exist between the data model defined in Oracle Data Integrator and the data server appear in a hierarchical or flattened view. In the hierarchical view, for example, a new column appears under a table node, and this table appears with a modified marker. In the flatten view, all the changes appear at the same level.
The differences that appear in these views depend on the filters that are checked in the Filters option group.
Select the changes you want to apply by checking the Synchronization column check box. You can also select or unselect all the differences currently displayed by using the buttons on top of the views.
Filters
Check boxes to filter the type of changes you want to display
For more information on how to create DDL Scripts, see "Generating DDL Scripts" in the "Creating Data Models with Common Format Designer" chapter in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator.
"Generating DDL Scripts" in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator