Data Objects
Data Objects are the tables, views, methods, stored procedures, functions and custom SQL made accessible from the Data Sources for reports. This article applies to the Admin Console > Data > Objects settings.
Data
REST – Data Objects
Endpoints for the manipulation of Data Objects (also known as "Entities") in the REST API.
Data Sources
Data Sources establish the connection between Exago and a database or a web service. Although typically only one database is used, Exago can join data from different sources into a single report.
REST – Data Sources
A Data Source is a resource which contains or accesses the information which is reported on. Often this is a database, but a variety of types are supported. Data Sources are accessed using a connection string, which passes the location of the resource and authentication params. This ...
Database Aggregation
Exago can aggregate data in memory, but it will attempt to push calculations to the database whenever possible to improve performance. This feature is referred to as Database Aggregation.
Aggregating in memory can be under-performant for large sets of data for two reasons:
The application ...
Database Settings
The Database Settings allow administrators to adjust how Exago interfaces with its Data Sources. Additional type-specific settings allow you to specify which driver to utilize when connecting to each data source.
Execution Caching
Execution Caching allows the data from a report execution to be saved so that reports can be viewed more quickly and with less stress to the data source. The frequency and schedule of data source updates is customizable for each report. Updates can be scheduled for off-hours in order to better ...
ExpressView: Data Categories and Fields
Add, edit or remove data objects and fields from the ExpressView with the Data Objects pane. This article applies to versions of the application released prior to v2021.1.
Advanced Reports: Joins
Joins describe how the Data Objects on a report are related to each other. When two objects are joined, a field in the first object is associated with a field in the second object. Wherever a value in the first object's field matches a value in the second object's field, that value's rows from each object come together to form a composite row. The table produced by all the composite rows is the resulting data that appears on the report.
Advanced Joins
The v2017.2 release of Exago BI features several Join Enhancements, including the ability to join on inequalities, nested join expressions, and subqueries. Additionally, data objects can now be cloned, which allows for multiple different joins between objects, as well as the ability to join ...
CData Drivers
Additional database connection types are available using ADO.NET drivers provided by CData Software Inc., in partnership with Exago Inc., to connect to database types not natively included in the application.
Advanced Reports: Categories (pre-2021.1)
Use the Categories window to select which data to use on the report. This articles applies to versions of the application released before v2021.1.
Automatic Database Discovery
This article applies to the Admin Console > Data > Sources settings.
To discover and add data objects, joins and metadata to the configuration automatically use:
Add All Complete Objects, Joins and Metadata tool, or
Discover Database Metadata tool
Automatic Database Discovery is ...
Assembly Data Sources
Exago supports the ability to retrieve data from .NET assemblies. Assembly Data Sources are custom programmatic .NET Framework binaries for transforming and exposing arbitrary data in a format that can be read by Exago BI.
Assembly Data Sources can be used as data connectors and drivers for ...
