Generate DDL Editor

Generate DDL Editor


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 that 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.

Specify the following parameters in the Generate DDL Editor:

Action Group

The action group to use to generate the DDL script.

Procedure Name

The name of the generated procedure.

Generation Folder
Oracle Data Integrator project folder into which the procedure will be 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 hierachical or flattened view. In the hierarchical view, for example, a new column will appear under a table node, and this table will appear 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 checkbox. 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