Creating cross-database table relationships

Applies to: Dataedo 10.x versions, Article available also for: 24.x (current), 23.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

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

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

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

Add relation button

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

New cross-db relation form

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 current documentation and objects related to objects currently on ERD from any documentation.

Cross database ERD