Inter-system relations

Inter-system relations are analogous to Intra-system relations. However, instead of associating two tables within the data model of a single system, they associate the Data models of two different Systems with one another.

To get started, Create an inter-system relation.

The primary purpose of inter-system relations is to let Filters operate between systems:

  • Without inter-system relations in place, a filter can only operate on data contained within a single system.

  • With inter-system relations in place, a filter can operate on data contained between multiple systems.

An inter-system relation works by matching a primary key column in a table of system X, with a foreign key column of a table of system Y. Typically, this is an employee ID number or other unique account identifier.

All inter-system relations exist on an N-N basis. A N-N relation means that for one (1) instance of entity X, there exist zero, one, or many (N) instances of entity Y; and for one (1) instance of entity Y, there exists zero, one, or many (N) instances of entity X. In this way, a single inter-system relation joins the two separate sets of 1-N and N-N intra-system relations already specified in each of the respective systems.


Alternatively, use Vault queries to share data between systems without creating inter-system relations.

However, this is a last resort. Only use a vault query when creating an inter-system relation is impractical or impossible. Too many vault queries can lead to a "spaghetti" configuration that is difficult to maintain.