Data sources
Data sources allow you to set up connections to get the information needed to build reports or dashboards.
Data sources can be configured with SQL Server or Oracle provider.
Configuring SQL Server Data Sources
1. Once you have logged into the AQM console, in the General Settings from the main menu, select the Data Sources.
2. In the information view, the list of data sources is displayed. Select the New And in the detail view you can configure the information of the data source, enter the requested data. Test the connection by clicking the 
before Save the information.
⚐ Note
- For this configuration, select the SQL Server provider.
- The default value of the field supplier is SQL Server.
- The requested parameters change for each type of provider (Microsoft SQLServer or Oracle).
| Fields | Description |
|---|---|
| Name | Enter a name for the data source. |
| Supplier | This is the SQL Server or Oracle provider type (For this configuration select the SQL Server option). |
| Data source | Enter the name of the SQL Server database server. |
| Initial catalog | Enter the name of the SQL Server database. |
| User ID | Enter the user with whom you connect to the SQL Server database server. |
| Password | Define the password with which you connect to the SQL Server database server. |
| Connect timeout | Set the maximum time in seconds for AQM to wait for the connection. |
3. When you finish configuring the data source, click on Save icon 
in the Detail View of the AQM Configuration Console, to confirm the changes made.
Configuring Oracle Data Sources
1. Once you have logged into the AQM console, in the General Settings from the main menu, select the Data Sources.
2. In the information view, the list of data sources is displayed. Select the New And in the detail view you can configure the information of the data source, enter the requested data. Test the connection by clicking the before Save the information.
⚐ Note
- For this configuration, select the Oracle provider.
- The requested parameters change for each type of provider (Microsoft SQLServer or Oracle).
| Fields | Description |
|---|---|
| Name | Enter a name for the data source. |
| Supplier | This is the SQL Server or Oracle provider type (For this configuration, the Oracle option is selected). |
| Data source | Enter the TNS name of Oracle. |
| User ID | Enter the user with whom you connect to the Oracle database server. |
| Password | Define the password with which you connect to the Oracle database server. |
3. When you finish configuring the data source, click on Save icon in the Detail View of the AQM Configuration Console, to confirm the changes made.
⚐ Limitations
- The data sources allowed for the reporting system in the product will be SQL Server and Oracle. Data sources from plain text and csv files are not allowed, even if they appear when editing reports.
- To connect to Oracle databases, copy the tnsnames.ora file to the AQM web application path.