Joins specify to Exago the relationship between Data Objects.
All existing Joins are listed in the Main Menu under Data. All the joins you are adding or editing will be displayed in a Tab entitled 'Joins'.
NOTE. Joins can be added quickly using Automatic Database Discovery.
Each join has the following properties:
The first Data Objects you would like to join.
The other Data Object you would like to join.
Specify the field(s) of each Data Object that must match to join an entity in the From Object to an entity(s) in the To Object.
Specify whether rows from either Data Object that do not have a match should or should not be included.
Specify if the join type is one-to-one or one-to-many.
Give a join weight in order to set its precedence when multiple join paths exist between Data Objects. The path with the higher weight will be utilized.
Although joins are created in the Administration Console, they are saved within each individual report. For Join changes in the Administration Console to take effect, edit the report and use the ‘Recreate’ button in the Advanced Options menu. For instructions on how to access the Advanced Options please see this article.
IMPORTANT. It is important to make sure that all of the joins are set to your desired specifications in the Administration Console before you begin building numerous reports.
Data Objects from different Data Sources can be joined in Exago. Because the Data Objects come from distinct databases they must be joined through code by Exago.
IMPORTANT. Though Exago strives for efficiency, this process may be memory intensive for large data sets.