ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
latest (15.3.0) 15.2.0 15.1.x 14.5.x 13.9.x 13.8.x 13.7.x 13.6.x 13.5.0 13.4.x 13.3.x 13.2.x
User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Creating the RDM Data Model

The RDM Logical Model can be created in three ways:

  • Manually.

  • Importing database metadata (table and attributes names and attribute data types).

  • Importing the model from a modeling tool (XMI file).

RDM supports incremental importing: when importing a model from an external source, such as an XMI file or a database schema, RDM computes the difference between the external and current RDM model and presents elements to add and delete.

Manual model definition

Manual model definition is done by adding domains, tables, and relationships between tables.

Importing database metadata

  1. Right-click RDM Logical Model > Import database metadata.

  2. Select one of previously added database connections and expand to the needed schema. Then choose tables to import in the Tables section and select Next.

    Create the RDM data model from database metadata

  3. Review the columns that will be added and removed and adjust as necessary.

    The Allow deleting tables and relations option allows the importer to delete unmatched tables and relationships from the current RDM model.
    Create the RDM data model from database metadata

  4. Select Finish to complete the import.

  5. Fix any problems that appear on the Properties tab of the Status Panel, for example, invalid domains. See rdm-domains.adoc.

    Correct errors

  6. Add relationships between tables. See Relationships.

Importing from a modeling tool

RDM supports importing the data model definition from data modeling tools like ERwin and SAP PowerDesigner.

  1. Right-click RDM Logical Model > Import XMI.

    Some ERwin models might require using RDM Logical Model > Import from XMI - configurable. The dialogs are slightly different than those shown here.
    For models made in SAP PowerDesigner (.pdm extension), it is also possible to import domains in addition to tables and relationships. Use the RDM Logical Model > Import from XMI - configurable option.

  2. Browse for an XMI/XML file in the File name field.

  3. Select tables in the Tables section and select Next.

    Create the RDM data model from a modeling tool

  4. Review the tables, columns, and relationships that will be added and removed (adjust as necessary).

    The Allow deleting tables and relations checkbox lets the importer delete unmatched tables and relationships from the current RDM model.
    Create the RDM data model from a modeling tool

  5. Select Finish to complete the import.

  6. Fix any problems that appear on the Properties tab of the Status Panel, for example, invalid domains. See rdm-domains.adoc.

Viewing the data model

You can view the created or imported data model by right-clicking the RDM Logical Model node and selecting Edit schema.

RDM logical model schema

Adding tables and relationships is described in Tables and Relationships.

Was this page useful?