Administrators Archives

Administrators

Intro to Performance and Scaling

Welcome to the Performance and Scaling series. This is a series of articles and blog posts that aim to deliver advice and guidance for optimizing the performance of Exago BI. Internet software is very complex, often comprising dozens of servers and interconnected components. Taken ...

Measuring Database Network Latency

Part of the Performance and Scaling series. This article will discuss how to examine the Exago log file to determine the time it takes to retrieve data from a database. In this way you can isolate the performance of the network connection between the execution engine and the data ...

Monitoring Database Schema

The monitoring database has three tables that can be used to build reports. This article describes what data is stored, and how to interpret what you see. Entity-relationship diagram (ERD) for the monitoring database SystemStatistics The SystemStatistics table logs the available CPU ...

Monitoring Scheduler Load

The Monitoring Service can be used to capture Scheduler Service load and performance data.

Monitoring: Setup

Monitoring that allows report management, execution, and performance statistics for the web application and schedulers to be tracked in v2017.1+. Monitoring data is stored in local SQLite database files and can be reported on using Exago.

Monitoring: System Overview

The Monitoring system is structured in the following manner: Structure of the monitoring system Web Application Database The Web Application database stores data for report and user interface events. The type of data tracked depends on your configuration. At the Extract interval, the ...

REST – Config Settings

The Settings endpoint allows access to many for the current configuration and session.

REST – Data Joins

Joins are the relationship data objects have to each other. Join information is accessible and editable via REST.

REST – Data Objects

Endpoints for the manipulation of Data Objects (also known as "Entities") in the REST API.

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

Executing Reports with the API

NoteThis version of the .NET API documentation is deprecated. A new version can be found at https://www.exagoaccess.com/api-docs/. There are two different ways to use the Exago APIs to perform report execution. This guide discusses the main differences and provides ...

REST – Folders

Management of the folder and report tree is available with the REST Web Service API. Unlike other resources, managing the tree affects the base configuration, and is not temporary to a session. Therefore it also affects concurrent users. NoteAll requests require a Session ID URL ...

REST – Functions

Functions are custom formulas that can be used in reports to manipulate data. Only custom functions can be edited, not the built-in functions. NoteAll requests require a Session ID URL parameter and basic request headers. In the following document, headers are omitted in the interest of ...

REST – GetExecute

GetExecute is used to execute reports in the API, without opening an instance of Exago. If executing as text, i.e. HTML, CSV, or JSON, then the output data is returned directly in the ExecuteData property. If executing as binary (i.e. PDF, RTF, or Excel workbook), then ExecuteData will return ...

REST – Getting Started

This guide serves as a step-by-step walk through for installing and configuring the REST Web Service, verifying that it is working properly, and briefly demonstrating how it works. This article is a chronological series of steps that should be followed in this order: Installing the Web ...

REST – Introduction

The Exago API provides programmatic access to create session configurations based on user credentials. The REST API is an alternative to the .NET API for applications not built in .NET environments. REST web services provide access to API functions for any client capable of passing HTTP ...

List of REST Endpoints

The following REST Web Service API endpoint paths are available. All calls require the following headers: Content-Type: application/json Accept: application/json Authorization: {type} {authstring} For more information, review REST — Introduction /rest/Batch ...

REST — Parameters

Parameters are used throughout the application to store values.

Global Event: OnAfterLoadReportsList

Occurs after reports created in Exago have been loaded into the Report Tree, but before the Report Tree is drawn into the user interface. Signature For custom code the arguments array is structured as follows: args[] contains one object: a WebReports.UI.Controls.TreeNodeCollection, a list ...

Global Event: OnAfterReportExportSuccess

The OnAfterReportExportSuccess event (v2018.2.14+, v2019.1.1+) will be called after a report execution export file has been generated for a specified report. The server event implementation may load the export file from disk using the supplied file path, exportFilePath, modify the file, then ...