Analytics Plus Agent
Analytics Plus agent is an independent software program used to import data from either files or relational databases that runs behind the firewall (i.e in your local network) into Analytics Plus. The databases should be JDBC compliant such as MySQL, SQL Server, Sybase, PostgreSQL, Oracle, SQLite or Firebird
Download, Install and Setup Analytics Plus Agent
Downloading Analytics Plus Agent
ManageEngine Analytics Plus Analytics agent can be downloaded from the following URLs. The agent can be installed on either a Windows or Linux operating system.
|Download Analytics Plus agent|
|Windows Download||Linux Download|
Once downloaded, extract the compressed files to a directory of your choice. You should see a 'bin' folder in the extracted contents.
The bin folder contains batch files and shell scripts required that upload data from CSV files (GUI/Console mode) and relational databases. The folder also contains configuration files used to set environmental variables. The following is a brief description of the files available in the /bin directory:
- CSVUploadGUI.bat / CSVUploadGUI.sh - Use this script to start the agent in GUI mode
- CSVUploadConsole.bat / CSVUploadConsole.sh - Use this script to start the agent in Console mode .
- UploadFromDB.bat / UploadFromDB.sh - Use this to upload data from relational databases into Analytics Plus
- setEnv.bat/ setEnv.sh -All Environmental variables are pre-defined in this script
Use the .bat files for Windows machine and the .sh files for Linux machine.
The conf directory contains all the configuration files of the agent. These files are as follows.
common_params.conf: This configuration file contains parameters that has to be specified for pushing data either from a CSV file or an in-house database. This file contains Connection Parameters for configuring proxy server details, if you are going to connect to the Internet through a proxy server. It also contains Import Parameters which has to be configured while uploading data from a CSV file.
database_connection_params.conf: This configuration file has to be setup if you are going to use the agent to connect to your local database to fetch data and upload the same into ManageEngine Analytics Plus. This file also contains the local database connection parameters like database type, name, local host name/machine name, port, user name, password etc.,
database_sql_queries.xml: This configuration is another file to setup if you are going to use the agent to connect to your local database to fetch data and upload the same into ManageEngine Analytics Plus. You need to specify the SQL SELECT Queries to be executed in the local database to fetch the required data to be uploaded into ManageEngine Analytics Plus. In this file you will also be configuring where the uploaded data has to be stored in ManageEngine Analytics Plus i.e., ManageEngine Analytics Plus database name and table name.
The lib folder contains the required executable JAR files to run the agent.
Proxy SettingsAnalytics Plus agent runs in your local environment (machine) and contacts ManageEngine Analytics Plus Reports application for pushing data either from a CSV file or a database.To push data from either a CSV or a database, there are a few common settings which need to be configured. The settings can be configured in the common_params.conf file, found under /conf/ directory"
Proxy Server Settings
If the Analytics Plus agent is going to be connected to the Internet through a proxy server , you need to specify your proxy server details in common_params.conf file.
Note:If you are using a Direct Internet connection, then this setting can be ignored.
To connect with the internet through a proxy server you need to provide the following CONNECTION PARAMETERS in the /conf/common_params.conf file. You can edit the file using the text editor such as Vi or Vim or Notepad.
USEPROXY - Set this to true, if you are connected through a Proxy server. Set this to false, if you are connected to the Internet directly. By default this value is set to false.
PROXYHOST - Specify the machine name or IP address where the proxy server is running in your network.
PROXYPORT - Specify the port in which the proxy server is running.
PROXYUSERNAME - Specify your proxy server user name to access the proxy server.
PROXYPASSWORD - Specify your proxy password to access the proxy server