Creating cross-database table relationships

Dataedo 6.0 brought the unique capability of defining relationships across databases. Both databases need to be imported into the same Dataedo repository.

Once you have all required databases and tables in place and want to create a new cross-database relationship, go to the foreign key table.

In the Relations tab, click the Add relation button in the ribbon or in the right-click context menu.

The New relation form will open. Choose the primary key table database from the PK Database dropdown list and the table you want to define the relation to in the PK Table list.

Then define columns and save with OK.

This way you can also create cross-database ERDs. When you go to the ERD tab of a module, the available entities list contains objects from the current documentation and objects related to objects currently on the ERD from any documentation.