Creating Database Table Relationships

Article Summary

Share feedback

Thanks for sharing your feedback!

Creating a Database Table Relationship is integrating data from two separate database tables and pulling from them simultaneously.

In v7.14+, Postgres table names allow up to 63 characters. Going over this number will result in the relationship table integration not working.

Viewing Relationships

There is not a dedicated dashboard or other mechanism that displays database relationships in a diagram within Decisions.

Example

Navigate to System > Integrations > Databases and select a Database.
On the top action bar, click ADD RELATIONSHIP.
In the Add Relationship window, enter a name under Relationship Name. Under the FROM and TO categories, select the Table and Field(s) that should be related. Click OK.
In a Designer Project, click CREATE REPORT to create a new Report.
Under Data Sources, click Add. Expand Common and select one of the Tables from the relationship.
Because a relationship has been created, clicking Add will display an option called Add related table.
Select the second table so it can be added to the Report.

For further information on Integrations, visit the Decisions Forum.

Was this article helpful?

Table of contents