Use the Export and Import Utilities in Optim to migrate definitions of Optim™ Directory objects — including Access Definitions, Table Maps, Column Maps, Primary Keys, DB Aliases, Relationships, Calendars, and Convert, Delete, Extract, Insert, and Load Requests — from one Optim Directory to another.
Importing objects in UNIX has special considerations. See Import for UNIX.
To connect to an Optim Directory prior to exporting or importing, 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 recreate Optim objects manually and, more importantly, they promote consistent, reliable data handling. You migrate object definitions between Optim Directories in two steps:
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.
Copy object definitions from a file to the current Optim Directory. The Input File for Import is the Output File from Export.
The output from the Export Utility is a text file that you can view using 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 required by the Import Utility or inserting or removing special characters, may cause errors. Do not use wordwrapping.
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 has been imported using 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 has not been 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.