Exago Logo
Search
Generic filters
Exact matches only
Installation and Configuration

Set Up Exago in a Web Farm

One method for running Exago in a distributed environment is using a Web Farm to run multiple instances of the Web Application. This may be desirable for load balancing purposes.There are several guidelines for setup. Each will be discussed in detail in separate sections.Load Balancer: ...

Step 1: Install and Configure

Installation Exago was designed as a simple installation, aimed to be running as quick as possible with little configuration. The first step is in this process is to download and run the appropriate installer. If you are installing Exago as part of a web farm or you ...

Step 2: Integrate

Using the API With the basic setup of Exago complete, it's time to integrate Exago into your web application by using custom styling, and Exago's API through either .NET or REST. The basic flow is to create an Exago API object within your application code, modify parameters that ...

Roles

Roles control access to data and override the General Settings.

Step 3: Install and Configure the Scheduler Service

Exago's Scheduler Service is used to regularly execute and deliver reports in an automated fashion. It can also be used to turn a machine into a "remote execution" engine to add additional execution resources to Exago. In Step 3 of the Getting Started Guide, we review installing and configuring this service.

Storage Management

This article applies to the Admin Console > Storage Management settings.Assembly Location The path and filename of the DLL that implements the IStorageManagement interface. The default value is <WebApp>binWebReports.ContentDatabase.dll, which will use Exago's Storage Management ...

Step 4: Administration Console and API

Understanding the Administration Console and API When configuring the Exago environment on a per-user basis, it is useful to use the Administration Console to create a "base" configuration from which individual user configurations are established through the API when Exago is launched. ...

Step 5: Extensions

Exago comes with a high degree of extensibility. For a quick overview of some of the ways an administrator can configure Exago to have custom functionality, see the article below:An Overview of Exago ExtensionsFollowing are some of the methods by which custom behavior can be added to ...

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 ...

Scheduler Settings

Reports can be emailed or scheduled for recurring automated delivery to an email address. The Scheduler Settings are used to configure these services.

Technical Specifications

Operating Systems WindowsWindows Server 2012+ / Windows 10 Internet Information Services (IIS) 7+ .NET Framework 4.6.1+, version 4.7.2 recommendedLinux Supported/Recommended DistributionsUbuntu 14+Additional DistributionsRed Hat Enterprise Linux 7 SUSE Linux Enterprise ...

User Settings

The User Settings give administrators choices about how to store and utilize users’ preferences, such as which Dashboards and/or Reports to execute when they enter Exago.

Storage Management: Transitioning from Legacy Storage Methods

Exago's Storage Management system replaces the legacy file system, cloud storage, folder management and web service (SOAP) storage methods with a relational database. All reports, templates, folders and themes are stored in this database. Microsoft SQL Server, MySQL, Oracle and PostgreSQL ...

User Identification

User logins must be handled by a security layer in the embedding host application. After a user logs in, the host application should pass identification parameters to the Exago API, which can be used to set permissions on content and data objects within Exago.

Using SQLite Data Sources

Native Support Now IncludedBeginning with v2021.1.7+, 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 ...

Scheduler Service Configuration

There are several properties of the Scheduler Service that must be configured on a per-service level.

Storage Management: Utility (v2020.1)

Exago provides the Storage Management Utility (SMU) to view and manage the content access records and permissions on content items. It is a WPF application and will only run on the Windows family of operating systems. It is only available in English language. The SMU can be downloaded from ...

Storage Management: Utility (v2021.1+)

Exago provides the Storage Management Utility (SMU) to view and manage the content access records and permissions on content items at a low level. Based on .NET Core 3.1, it will run on supported versions of Windows, Mac and Linux. It is only available in English language. The SMU can be ...

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 ...

Vertical Table Support

Vertical tables are a table format which differ from relational tables in the way the data is organized. Exago BI supports vertical tables, but they require some special configuration to be used. Relational Tables vs. Vertical Tables The following sections describe the differences between ...