Administrators Archives

Administrators

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

Exploring Exago Technology

Use this document to understand how the Exago platform works.

Storage Management: Getting Started

This guide aims to "bridge the gap" between learning about the Storage Management system and implementing the Storage Management system.

Hidden Flags

The following options are inaccessible from the Admin Console, but may be toggled on or off or otherwise modified by editing the field in the XML configuration file. <errorondbrowlimitexceeded> v2021.1.16+ — When True, if the Admin Console > General > Database Settings > ...

Inline Frame or JavaScript API?

Exago offers flexibility when integrating with a host application. This article aims to describe the differences between using inline frames (also known as iframes) and the Exago JavaScript API. This article will detail the pros and cons of each embedding method. As each application is ...

Installing and Configuring the REST Web Service API

This content has been moved to REST — Getting Started.

Installing Optional Features

Several features require additional configuration before they can be used.Google Maps Important Exago's Google Maps wizard uses the Google Maps API, which requires a paid license for commercial use. You must acquire a Google Maps API license in order to enable this feature. There are ...

Storage Management: Introduction

An introduction to the Storage Management system that stores all reports, templates, folders and themes are in a database. Introduced in v2020.1 of Exago. Content storage, schema, permissions, security, custom implementation and transitioning from a legacy content storage solution are covered among other topics.

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

Manual Application Installation

If the host application is deployed on site it may prove convenient and advantageous to integrate the installation of Exago into the host’s installer. This section will detail how to integrate the installation. To accomplish this task there must be an existing installation of the Exago Web ...

Moving Files Between Storage Management Databases

Exago recommends using a three-environment development, quality assurance and production paradigm. In this structure, it is often desirable to maintain unique Storage Management databases for each environment. Use the ImportExportStorageMgmt command line utility, available in v2020.1.17+ ...

Multi-Tenant Environment Integration

Exago supports a variety of approaches to make sure that users can only access the data that is assigned to them. These approaches can eliminate the need to create different reports for each user. This can be done in one of four ways. Using either column, schema, database, or custom SQL based ...

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

JavaScript API

The Exago JavaScript (JS) API allows Exago functionality to be embedded directly into HTML containers.

JavaScript API: Filters and Parameters

Runtime filters and parameters can now be modified via the JavaScript API prior to a report's execution.

JavaScript API: Proxy Incoming Requests

Note As of v2018.1, this is no longer necessary. Use Cookieless Sessions instead. It can be tricky to serve content from different domains as part of the same web page. To protect against malicious scripts, web browsers enforce a same-origin policy whereby scripts have permission to access ...

JavaScript API: Report and Dashboard Execution Timing

As of v2019.1.3+, Exago BI exposes a JavaScript API that may be invoked in the browser to execute reports and dashboards and retrieve information about how long they take to run. This makes it easier to do benchmarking, especially for dashboard executions where a test would need to wait ...

Configuration File Options and Optimizations

In order to decrease the amount of resources needed to handle the configuration information, especially in situations where a large number of complex database objects are present, the option to implement a static configuration has been introduced.

High Availability

This article will highlight recommendations for designing a highly available Exago environment. By creating multiple areas of redundancy, single points of failure can be eliminated. A system which is adaptable to component failures is highly available. This article will focus on how to make ...

Incremental Loading

Incremental loading limits the amount of data that is returned for each database query. This allows users to load reports incrementally, starting with a small set of rows and adding more in steps as desired. Incremental loading can shorten the amount of time it takes a report to load and be usable. It can also help reduce continuous load on a database which may improve load balancing performance.