Process the Insert Request

To process the Insert Request, click File > Run from the Insert Request Editor.

Note: If you are not authorized to create new tables, you may be unable to continue this scenario. Check with the site management for the destination tables to use.

Insert Progress

The Insert Request Progress dialog is displayed while the Insert Request is processed. The Insert Process populates the tables with the data from the Extract File.

Insert Request Progress dialog

Create Utility

If the status of any table in the Table Map is Unknown, meaning it does not exist, the Create Utility is opened. The Create Utility uses the object definitions in the Extract File to create those objects in the database.

When the Create Utility is opened, the Create dialog lists all objects in the Extract File that do not exist at the destination. Objects that do not exist at the destination are selected for the Create Process by default, unless a conflict exists.

In this scenario, the object types PK (for Primary Key) and FK (for Foreign Key) are in conflict. The Object Names of the Primary Keys and Foreign Keys in the Extract File conflict with names that already exist in the database.

Note: The Create dialog may differ slightly from the example shown, depending on the database you use. For this scenario, the Oracle version is displayed.
Create dialog

For this scenario, resolve the conflicts by changing the Object Name for the objects in Conflict status. For example, insert T_ before each name, as shown below.

Conflicts resolved by changing the Object Names for the objects in conflict

To create the objects, click Tools > Create All Selected Objects from the Create dialog, or right-click and select the command from the shortcut menu.

Note: You can also create each object individually using Create Object from the shortcut menu.

Review SQL

The Review SQL dialog is displayed by default to enable you to examine the SQL produced to create the objects. The SQL can be edited, if necessary.

For this scenario, click Proceed to create the objects.

Note: If there are errors, the Review SQL dialog displays again. You can edit the SQL to try to correct the problem, or abandon the Create Request.
Review SQL dialog

After the objects are created, the Browse SQL dialog is displayed, enabling you to browse the SQL statements and the results of the Create Utility. Click Continue to return to the Create dialog. The objects successfully created are displayed with the status of Created.

After the new objects are created at the destination, click File > Close from the Create dialog.

Insert Process Report

When the Insert Process has completed, the Insert Process Report is displayed. The report provides statistics and general information about the Insert Process.

Insert Process Report
Note: The report information displayed in the sample illustration may vary from the results displayed on your workstation.

You can optionally save or print the Insert Process Report. Click File > Save As to save the report or File > Print to print it. To return to the Insert Request Editor, click File > Close.