Exporting data to Oracle

The Open Data Export Centre allows data to be exported from InfoWorks WS Pro to a variety of formats including Oracle database.

Please Note

The minimum version of Oracle supported for export without spatial data is Oracle 8i. To export spatial data a minimum version of Oracle 9.2 is required.

In addition to exporting data to a new Feature Class, the Open Data Export Centre can be used to update an existing Feature Class.

Exporting to a New Feature Class

The Open Data Export Centre can be used to export InfoWorks WS Pro tables to a new Feature Class in an Oracle database. Further details of export options are listed in the Open Data Export Centre topic.

To export to a new Feature Class:

  1. In the Open Data Export Centre dialog select the InfoWorks WS Pro table to be exported from the Table To Export Data From dropdown.
  2. Select the Oracle option from the Export Type dropdown in the Export Data To section.
  3. Use the File browse button to connect to an existing database. The Select Oracle Data dialog will be displayed. ClosedShow image

  4. In the Select Oracle Data dialog, connect to an existing database, select the user tables to view and click OK.
  5. In the Open Data Export Centre, type in the name of a new Feature Class to which the data is to be exported.
  6. Map InfoWorks WS Pro internal fields to Feature Class export fields by loading a configuration file or by manually mapping the fields in the Field Mapping Grid.
  7. Click the Export button.

The specified Feature Class will be created and InfoWorks WS Pro data will be exported to it.

Updating an Existing Feature Class

In addition to exporting data to a new Feature Class, the Open Data Export Centre can be used to update an existing Feature Class.

In order to update an existing Feature Class, the user must either own the table, or have been granted the appropriate permissions in Oracle to update the table. Tables for which the user does not have the appropriate permission will not be available for selection in the Open Data Export Centre.

ClosedShow image

To update an existing Feature Class:

  1. In the Open Data Export Centre dialog, use the File browse button to connect to an existing database. The Select Oracle Data dialog will be displayed. ClosedShow image

  2. In the Select Oracle Data dialog, connect to an existing database, select the user tables to view and click OK.
  3. In the Open Data Export Centre, select an existing Oracle Database Feature Class from the Feature Class dropdown list. The Updating and Delete Options section will become enabled.
  4. Map InfoWorks WS Pro internal fields to Feature Class export fields by loading a configuration file or by manually mapping the fields in the Field Mapping Grid. In the Field Mapping Grid:
  5. Map update keys - select the fields to be used to locate items for update in the specified Feature Class. The Update Based On dropdown list contains all update mapping options applicable to the current Table to be Exported:
  6. Set Only Update Existing Objects option:
  7. Set Delete Missing Objects option:
  8. Click the Export button to export data from InfoWorks WS Pro to the specified Feature Class. All fields, except mapped update keys will be updated in the Feature Class.

Notes

Errors and warnings may be displayed after export listing details of row objects that have not been updated. Examples of reasons for update failures are listed below.

After carrying out a deletion, a summary of the export process is displayed including a count of items deleted from the target database. ClosedShow image

The summary provides information on the following:

Exporting Spatial Data

When connected to an Oracle server with Oracle Spatial loaded, the geometry of InfoWorks WS Pro objects can be exported by including an export field of field type Geometry in the Field Mapping Grid of the Open Data Export Centre dialog.


Open Data Export Centre

Exporting SQL Expressions

Exporting Array Data

Exporting Data to XML

Exporting Data to GeoDatabase

Using a Script to Control Export