Export and Import

Use the Export and Import Utilities in Optim to migrate definitions of Optim™ Directory objects from one Optim Directory to another, including Access Definitions, Table Maps, Column Maps, Primary Keys, DB Aliases, Relationships, Calendars, and Convert, Delete, Extract, Insert, and Load Requests.

Importing objects in UNIX has special considerations. For more information, see Import for UNIX.

To connect to an Optim Directory before you export or import, select Optim Directory from the File menu on the main window to open the Optim Directory window.

The Export and Import Utilities eliminate the need to manually recreate Optim objects and, more importantly, they promote consistent, reliable data handling. You migrate object definitions between Optim Directories in two steps:

  1. Export

    Copy object definitions from the Optim Directory to an Output File. You can reuse this file to import object definitions to any number of Optim Directories. You must have read access to view and export secured objects.

  2. Import

    Copy object definitions from a file to the current Optim Directory. The Input File for Import is the Output File from Export.

Export Files

The output from the Export Utility is a text file that you can view with an appropriate text editor, such as Notepad. If objects are exported from a multi-byte or unicode-enabled Optim Directory, any text editor that you use must be compatible with UTF-8.

Although not encouraged, you can edit object definitions in the text file. Deviations from the format that is required by the Import Utility or inserting or removing special characters, might cause errors. Do not use word wrapping.

Secured Definitions

A secured-when-saved object is automatically secured, when imported, by an ACL modeled after the Optim Object Template ACL.

When you import a secured object, it is not secured in the importing directory unless the ACL for the object is imported with the Import Security Definitions Utility or the object is secured automatically with the Optim Object Template ACL. If the object is not secured after import, you can define an ACL or import the ACL that secured the object.

If an Optim Object Template ACL is not defined, you must define an ACL for each object that is secured automatically.

If Functional Security is enabled, you must have Create privilege for objects you import.



Feedback