Database Provider Configuration

Database providers allow you to configure connections to get the information needed to build reports or dashboards. Each provider can Supply data to multiple applications, but only one application can be related to a single supplier.

1. To configure providers, log in to the AQM Configuration Console as an administrator, in the General Settings from the main menu, select the Data Sources. In the information view, the list of data providers is displayed. Select the New and in the detail view you can configure the supplier’s information, enter the requested data and indicate which products it applies to. Test the connection when finished.

The requested parameters vary for each type of provider (Microsoft SQLServer or Oracle).

• Specify the maximum time in seconds for AQM to wait for a connection.
• If you use query editors, AQM can filter objects by tables, views, or procedures, so that it loads only the objects that it deems necessary. In the filter, you can separate the search criteria with semicolons.
• In the case of the Oracle provider, the data source corresponds to the DESCRIPTOR of the Oracle connection.

2. When you finish configuring the data providers, click Save in the Detail View of the AQM configuration console, to confirm the changes you have made.

⚐ Note: About Data Sources in the Report/Dashboard Editor desktop app

Support for report and dashboard editing apps for windows will not continue as of January 2023. The aforementioned applications are maintained in the product versions without reflecting the improvements of each update.

The data sources allowed for the reporting system in the product will be MSSQL and ORACLE. Data sources from plain text and csv files will not be allowed even if they appear in the aforementioned Windows editors.

The invitation is to use the web version of reporting that integrates more functional elements.