Adding Databases Synchronized with RDM
RDM can synchronize reference data in its repository with any other defined databases. This article explains how to add such a database to your RDM project and define a data model for it, that is, specify tables in that database that will be synchronized. The synchronization task itself is described in Configuring Synchronization with External Databases.
Step 1 Define a new connected system
-
Define a database connection in ONE Desktop: switch to the File Explorer view, right-click Databases > New Database Connection. See Databases, section Connect to a Database.
-
Switch back to the Model Explorer and in Connected Systems > Databases, right-click Databases > New system.
-
Fill in External database attributes.
-
Select OK to save changes.
External database attributes
Attribute | Mandatory | Description |
---|---|---|
System name |
Y |
Name of the external database. |
Database connection |
Y |
Name of a previously defined external database connection. |
Description |
N |
Description of the database. |
Tables |
Y |
Allows adding external database tables (can be added via XMI or database metadata import). See the next step. |
Relationships |
N |
Allows adding relationships between external database tables (can be added via XMI or database metadata import). See the next step. |
Step 2 Build the external database data model
After defining a database to synchronize with, it is necessary to build and define the data model for it. At least one table should be defined.
As with the RDM data model, this can be done in three ways:
-
Manually create the model by creating tables and relationships between them.
-
Import database metadata.
-
Import the model from a modeling tool.
See Creating the RDM Data Model for more information.
External database table attributes
Attribute | Mandatory | Description |
---|---|---|
Table name |
Y |
Name of the table in the external database. |
Synchronize with RDM table |
Y |
Name of the corresponding table in the RDM model. |
Synchronize periodicity |
N |
Specifies the frequency of synchronization. For documentation purposes only. |
Description |
N |
Description of the table. |
Input columns |
Y |
Allows defining external database attributes:
|
RDM Key |
Y |
Attributes (ideally primary keys) that allow determining corresponding records in the RDM table and the external database table:
|
External database relationship attributes
Attribute | Mandatory | Description |
---|---|---|
Name |
Y |
Name of the relationship. |
Parent table |
Y |
Name of the parent table. |
Child table |
Y |
Name of the child table. |
Foreign key |
Y |
Defines the relationship between the parent and child system table:
|
Make sure you add database connections to the Runtime Configuration of your Runtime Server to have them available to the server. You can always export this configuration as a valid runtime configuration XML via File > Export > search for Runtime Configuration. See Export and Import Runtime Configuration. |
Was this page useful?