Data Source Drivers
A list and the associated links for recommended ADO.NET drivers for each type of data source, and notes about any applicable caveats or exceptions when using certain drivers.
Data
Configuring a Stored Procedure Pt 2
This video explains how to configure parameters and column metadata for a stored procedure in Exago. Complete the configuration of your stored procedure by watching this video after ‘Configuring a Stored Procedure Pt 1’ and ‘Programmable Object Settings’.<< Programmable Object Settings ...
Programmable Object Settings
This video explains how to configure your programmable object settings for use with a stored procedure. Watch this video along with ‘Configuring a Stored Procedure Pt 1’ and ‘Configuring a Stored Procedure Pt 2’ to set up your Stored Procedure start to finish.<< Configuring a Stored ...
Configuring a Stored Procedure Pt 1
This video explains how to add a stored procedure to the Exago configuration. Learn about the various settings available for each data object. Then continue to ‘Programmable Object Settings’ for the next step in your Stored Procedure setup.<< Configuring a Table or View Pt 2 Previous ...
Configuring a Table or View Pt 2
This video explains how to configure column metadata for a data object in Exago. Complete the configuration of your table and view by watching this video after ‘Configuring A Table or View Pt 1’.<< Configuring a Table or View Pt 1 Previous VideoNext Video Configuring a Stored Procedure ...
Configuring a Table or View Pt 1
This video explains how to add a table or view to the Exago configuration. Learn about the various settings available for each data object.<< Adding a SQL Datasource Previous VideoNext Video Configuring a Table or View Pt 2 >>Transcript
Welcome back to the Exago Technical Training ...
Adding a SQL Datasource
This video explains how to add a SQL Data Source to the Exago configuration.
<< Configuring the Scheduler [Windows] Previous Video
<< Configuring the Scheduler [Linux] Previous Video
Next Video Configuring a Table or View Pt 1 >>Transcript
Welcome back to the Exago Technical ...
WebReports.Api.Data
The Data namespace contains classes used to interact with data sources and admin console config settings.
Report-Level SQL Objects
This article applies to the Admin Console > General > Feature/UI Settings > Allow Creation of Custom SQL Objects setting.
Beginning with v2018.1, administrators have the ability to allow end-users to create reports using custom report-level SQL objects written in the end-user ...
Stored Procedures
Topics Discussed
Benefits and limitations to stored procedures
Using programmable data object parameters
Resources
Data Objects - Stored Procedures
Programmable Object Settings
Table-Valued Functions
Table-valued functions (TVF) are user-defined functions that return a table data type as output. Unlike views, table-valued functions allow for more than one SELECT statement.
Below is the TVF we'll be referencing in this guide. Note that the function RETURNS TABLE and takes the ...
Using SQLite Data Sources
Native Support Now IncludedBeginning with v2021.1.8+, native ADO.NET support for SQLite is included. To add a SQLite Data Source in these versions, skip this article and follow the instructions in Data Sources exclusively.SQLite is a relational database system which stores data directly in ...
Joins for Admins
Nick Cortina reviews adding complex joins to the configuration and to specific reports. Examples included in this lab will have joins with inequalities, as well utilizing sub queries. Finally, Nick discusses the various mechanisms available to us to apply these joins.
.NET Sample Code
Examples of how to use the .NET API for various features and functions.
Multiple Data Models
In some cases the same Data Objects may need to be joined together differently. To accomplish this, Data Objects and Joins can be placed into Categories/Folders to create multiple data models. When an end user selects a Data Object from a Category/Folder it indicates which joins to use.
The ...
Managing the dbconfigs.json File
The dbconfigs.json file contains database specific syntax related to formulas, data types, primary and foreign key discovery, datetime casting, and row limiting and range selection. This file is loaded by Exago during runtime and is required in order to provide database specific optimizations ...
User Support Lab – Joins for Report Writers
If you've ever wondered the following, this lab is for you!
What is a join?
What types of joins exist?
As an end user building reports, what benefit can understanding joins provide me?
Finally, how can I use this understanding to configure joins on the report level?
Travis will ...
Join Configuration
Joins specify to Exago the relationship between Data Objects. This article applies to the Admin Console > Data > Joins settings, where joins are defined at the base-configuration level.
REST – Data Joins
Joins are the relationship data objects have to each other. Join information is accessible and editable via REST.
Advanced Reports: Data Objects (v2021.1+)
A data object is a container for reportable information from a source of data. When creating a new Advanced Report, data objects will be added to the report with the Add Data Objects dialog, which will appears when launched for the first time.
