Configuring Oracle Data Import

Use Oracle Data import to configure the data transfer and to create or edit the mapping definition. The Create New Mapping Definition dialog box and the Edit Mapping dialog box consist of several tabs: Overview; Feature Classes; Domains; Feature Attributes; Domain Attributes.

Create New Mapping Definition dialog box

Description

Overview tab

Displays a high level overview of the mapping definition.

Mapping Definition Name

Specifies a name. For example, the name is displayed in the Import Oracle Data dialog box, or when you select the mapping definition for the Oracle Data import.

Created From

If the mapping definition has been imported from a file, displays the (*.XML) file name. See also Importing an Oracle Data Mapping Definition.

Mapping Definition Status

Compares the selected configuration to the data structure of the current industry model.

Indicates whether the configuration of each element is complete. Click View to display the detail tabs.

Linked—Indicates completed mapping definitions.

Not Linked—Indicates missing mapping definitions. For example, if you have not added attributes to your feature classes.

Advanced Settings Status

Indicates whether SQL select statements that are executed before and after the Oracle Data import, or placeholders have been defined. Click View to open the dialog boxes to edit the settings. See Oracle Data Import: SQL Statements and Placeholder.

Coordinate Transformation

If checked, transforms the coordinate system of the source industry model to the coordinate system of the target. The source and target coordinate systems are shown. This option is available for the "Map API" or "SQL Loader" migration methods only. Select the Add As New Feature Using Map API or Add As New Feature Using SQL Loader option in the Edit Feature Class Properties dialog box to use this option.

Import

Imports a mapping definition from an (*.XML) file.

Export

Exports the mapping definition to an (*.XML) file. For example to backup your configuration.

Close

Quits the dialog box. The mapping definition is automatically saved.

Advanced Settings

Opens dialog boxes to create or edit SQL select statements, and placeholders. See Oracle Data Import: SQL Statements and Placeholder.

Feature Classes tab

Links the feature classes of the source industry model with the feature classes of the final industry model. See also Oracle Data Import: Mapping Feature Classes and Domains.

Link Feature Classes area

Displays the feature classes of the source, and of the final industry model. To link two feature classes, select the source feature class, then select the final feature class, and click the Link Feature Classes icon.

Links the selected feature classes.

Unlinks the selected feature classes.

Automatically links all feature classes with the same name.

Creates a copy of the selected feature class in the final industry model.

Linked Feature Classes (Shown In The Order They Will Be Mapped) area

Displays the feature classes that have been linked in the order they are mapped in the mapping definition. Use the icons on the right to modify the order.

Properties: Displays the migration method, such as SQL Loader, or API.

Unlinks the selected feature classes.

Opens the Edit Properties dialog box. See Oracle Data Import: Edit Feature Class Properties.

Domains tab

Links the domains of the source industry model with the domains of the final industry model.

Link Domains area

Displays the domains of the source, and of the final industry model. To link two domains, select the source domain, then select the final domain, and click the Link icon.

Linked Domains area

Displays the domains that have been linked. Use the icon to unlink the domains.

Feature Attributes tab

Links the feature attributes of the source industry model with the feature attributes of the final industry model.

Prioritized List Of Linked Feature Classes area

Displays the feature classes that have been linked in the Feature Classes tab. For each feature class, an icon indicates whether all attributes have been linked.

Link Feature Attributes

Displays the attributes of the selected feature classes.

Linked Feature Attributes (Shown In The Order They Will Be Mapped) area

Displays the feature attributes that have been linked. Displays properties that have been set.

See also Oracle Data Import: Edit Feature Attribute Properties.

Opens the Edit Properties dialog box. See also Oracle Data Import: Edit Feature Attribute Properties.

Automatically links all attributes as specified in the option.

  • Link all attributes with the same name.
  • Link all attributes that are not linked, to a NULL attribute, so that all attributes can be considered as Linked.
  • Link all attributes that contain no data to a NULL attribute.

Switches to the Domain Values tab. If the item is related to a domain table, activates the corresponding domain.

Domain Values tab

Links the domain values of the source industry model with the domain values of the final industry model.

Linked Domains

Displays the domains that have been linked in the Domains tab. For each domain, an icon indicates whether all values have been linked.

Link Domain Values

Displays the values of the selected domains.

Linked Domain Values

Displays the domains that have been linked. Use the arrow buttons to modify the order of the domain values.

Domain Settings

Opens the Domain Settings dialog box. See Oracle Data Import: Mapping Feature Classes and Domains.