Data Agent¶
The Data Agent connects your databases with cloud installations of CxReports that are accessible via the Internet. It establishes a websocket connection to CxReports and waits for instructions from the server to execute database queries.
Installation¶
You can install the Data Agent using Docker or the Windows Installer.
Installation via Docker¶
Prepared Configuration Files
Prepared configuration files are available on GitHub.
To install the application using Docker, follow these steps:
- Create a
docker-compose.yml
file with the following content:
services:
app:
image: codaxy/cx-reports-data-agent:latest
restart: always
network_mode: host
secrets:
- source: appsettings_file
target: /app/appsettings.Production.json
volumes:
- ./data:/home/app
secrets:
appsettings_file:
file: ./appsettings.Production.jsonc
- In the same folder, create the
appsettings.Production.jsonc
file with the following content:
{
"Tunnels": [
{
"ServerUrl": "[url-of-the-cx-reports-instance]",
"AllowServerProvidedConnectionStrings": false,
"ConnectionStrings": {
"DB1": "[database-connection-string]"
}
}
]
}
-
Fill in the placeholders with actual values.
-
Start the agent using the command:
-
Copy the public server key from the console.
-
Start the application as a daemon using:
-
Register the agent in CxReports.
-
Head to your CxReports administration and go to the Data Agents page.
-
Register the agent using the public key provided.
-
Register new databases using the agent and try them out in your reports.
Installation on Windows¶
Follow these steps to install the Data Agent as a Windows Service:
- Go to CxReports Data Agent GitHub Repository and download the installer package.
- Install the application.
- Open
C:\Program Files\CxReports\DataAgent\appSettings.json
and configure tunnels and allowed connection strings using the instructions in the next section. Note that administrator permissions are required to make changes to this file as it is located inside the Program Files folder. - Navigate to
C:\Windows\System32\config\systemprofile\AppData\Roaming\CxReports\DataAgent\logs
and open the log file (agent permissions required here as well). - Copy the server public key from the log file.
- Go to your CxReports administration and navigate to the Data Agents page.
- Register the agent using the public key provided.
- Register new databases and test them in reports.
Agent Configuration¶
The appSettings.json
file looks like this:
{
"Tunnels": [
{
"ServerUrl": "[url-of-my-cx-reports-instance]",
"AllowServerProvidedConnectionStrings": false,
"ConnectionStrings": {
"DB1": "[connection-string-here]"
}
}
],
...
}
In this configuration:
ServerUrl
is the URL of your CxReports instance.AllowServerProvidedConnectionStrings
determines if the server can provide connection strings.ConnectionStrings
contains the connection strings for your databases.
Make sure to replace the placeholders with your actual values.
Configuration changes are automatically applied without the need to restart the agent.
By following these instructions, you can successfully install and configure the Data Agent to connect your databases with CxReports.