Working With Data Model Files in Online Mode

You can create and edit a data model online and later commit it to the database. For more information about working with data model files in the Online mode, see the following topics:

Exporting Data Model

You can export data model information either exporting a hierarchy or by exporting data in the System Administration classes. For more information about exporting a data model, see the following topics:

Note: Data in the System Administration folder can be exported in all the available formats, while a hierarchy can be exported either in xml or .xar format.

Exporting Hierarchy

The Export Hierarchy option exports the selected class and its subclasses to a specified file. You can export files either in the xml format or xml archive format.

This task explains how to export the selected class and its hierarchy:

  1. From the menu bar, select Model > Export Hierarchy.

    The Export Hierarchy window appears.

This describes the options, lists, and fields available in the Export Hierarchy window:

Options, Lists, and Fields

Description

Child Classes

Select to export the child classes for the selected class.

Pointer

Select to export the pointer class property and pointer valid class for the selected class.

Notes

Select to export the class level notes for the selected class.

Export MetaData

Select to export metadata of the selected class. For example, UOM, LDD, Auto Sequence, Class Alias, and so on.

Property

Select to export class properties for the selected class.

Custom Functions

Select to export custom functions for the selected class.

Attachments

Select to export the class level attachments defined for the selected class.

Save All

Select to export all data model elements in the selected class.

Target Vendor

    Select Oracle if the target database for import is oracle, or

  • Select DB2 if the target database for import is DB2.

File Format

Select:

  • XML format for the file type to be .xml.

  • XML Archive Format for the file type to be .xar (XML Archive Format).

  • dbload Format for the file type to be .dbload.

  • dbload Archive Format for the file type to be .dar (DBload Archive Format).

Note: Select the archive format (XML Archive Format or DBload Archive Format) only if the size of the model is huge and needs to be archived.

File Name

Enter the name of the file or click Browse, to select an existing file.

  1. Click OK.

    The selected class and its hierarchy are exported.

Exporting System Administration Data

You can export data in the System Administration folder.

This task explains how to export the System Administration Data:

  1. From the menu bar, select Model > Export Configs.

    The Export Configurations window appears.

Note: Alternately, you can select Model > Export Hierarchy > Export Configs to display the Export Configurations window. If you do not select at least one of the available options in the Export Configurations window, no data is exported.

  1. In the Select list, select your option.

    This table describes the several options available:

    Option

    Description

    User

    Select to export all the data pertaining to users present in the current database.

    Configurations

    Select to export the user defined configurations present in the current hierarchy.

    Search Pattern Values

    Select to export all the search and edit patterns defined for the properties in the current hierarchy.

    Organizer

    Select to export all the organizer items that are owned by the hierarchy.

    File Format List

    Select:

    1. XML format, for the file type to be .xml.

    2. XML Archive format, for the file type to be .xar (XML Archive Format)

    3. .

    4. dbload format, for the file type to be .dbl.

    5. dbload Archive format, for the file type to be .dar (DBload Archive Format).

    6. Note: Select the archive format (XML Archive Format or DBload Archive Format) if the size of the model is huge and needs to be archived.

    Target Vendor

    • Select Oracle if the target database for import is oracle, or

    • Select DB2 if the target database for import is DB2.

    Note: If you choose to export data through the Model > Export Hierarchy > Export Configs option, data in the System Administration folder is stored in filename_sysadmin.xml> <filename_sysadmin.xar> formats, while data  model information is stored in <filename_xml> format.

  2. Enter 2 and 6 in the From and To fields respectively to export rows 2 through 6. Click Select All to select all the rows displayed to be exported.

  3. In the File Name field, enter the name of the file, or click Browse to select an existing file, and then overwrite data on to it.

  4. Select Cascade Export to export the related pointer information. This option is selected to export User information, Configuration information, Organizer items, or search pattern values. If you do not select the Cascade Export option, the related pointer information is not exported.

  5. Click OK.

    The system administration data is exported.

Importing Data Model

Use this option to import a data model to your database directly, and commit the changes automatically.

This task explains how to import a data model:

  1. From the menu bar, select Model > Import.

    The Import Model window appears.

  2. From the Select Format list, select:

  • XML format, for the file to be imported in .xml format.

  • XML Archive format, for the file to be imported in .xar format.

  • dbload format, for the file to be imported in .dbl format.

  • dbload Archive format, for the file to be imported in .dar format.

  1. In the File Name field, enter the name of the file, or click Browse, and then select the file to be imported.

  2. Click OK.

    The data model is committed to the database.

Verifying Data Model Before Importing

Use this option to verify a data model without committing changes to the database. You can also use this option to check the integrity of the data model.

This task explains how to verify the data model:

  1. From the menu bar, select Model > Verify.

    The Verify Model window appears.

  2. From the Select Format list, select:

    • XML format, for the file to be imported in .xml format.

    • XML Archive format, for the file to be imported in .xar format.

    • dbload format, for the file to be imported in .dbl format.

    • dbload Archive format, for the file to be imported in .dar format.

    Note: The Model > Verify option is disabled for XML Archive Format (.xar) and Dbload Archive Format (.dar) files for DB2 databases.

  3. In the File Name field, enter the name of the file, or click Browse, and then select the file to be imported.

  4. Click OK.

    The selected data model is imported, without being committed to the database.

    If any errors are encountered, the error messages are displayed in the Output Messages area. You can save the error log information into a text file. To save and view the error log information:

    • Right-click and select Save Output Messages to save the error log information into a separate text file.

    • Select Copy Output Messages to copy the error log information in to another application.

    The error messages and error log information are stored in the .err and .log files in the same directory in which the file is imported.