Administration Guide > Installation > New Installation > Installing the Agent for Database Variables

Installing the Agent for Database Variables

The following guide describes the installation process of the databaseA database is an organized collection of data including relevant data structures. agent for Variable objects with the source SQL. This agent is also referred to as the DB Service Agent.

This installation guide can be used for Windows and for Unix.

The agent for SQL variables (DB Service Agent) can access each supported database type. This type must be determined in a DB-type Connection object that can be assigned to Variable objects with the source SQL. In doing so, only one DB Service Agent is required for all SQL variables.
In this Connection object, you can also determine the database name and the connection parameters (such as Server name and port number). The agent is configured in the AutomationEngine's INI file and not in its own INI file.
The agent is only required for Variable objects with the source SQL. SQLI variables do not require an agent because they access the AE database directly via the Automation Engine.

The DB Service Agent must be installed on the same computer as the Automation Engine.
This includes that you can only log on to MS SQL Server databases via Windows authentication when the Automation Engine does not run on UNIX. The reason for this is that the library "sqljdbc_auth.dll" cannot be loaded under UNIX.

A DB Service Agent may always be used throughout the whole system, regardless of the authorization settings (Agent object > Authorizations tab).

The following guide describes how to install an agent in an AE system in which authentication is not used. Additional installation steps are required before the agent can be started and used if you intend to use one of the available authentication methods. More detailed information is provided in the document Advanced Security.

Automic strongly recommends installing the agent in a separate directory.

Before you start the installation, ensure that the Java agents can only connect to CP port numbers that are lower than 65536. If they use a higher port number, the agent cannot start and aborts with an error message. This limitation is caused by Java and affects the agents for JMX, Databases, SAP and RA.

Supplied Files

The files that belong to the database agent are stored in the directory IMAGE:AGENTS\SQL.

Additionally, two empty folders (Temp and JDBC) are supplied. The Temp folder stores log files, and the JDBC driver must be installed in the JDBC folder.



Procedure

1. Installing the Java Runtime Environment (JRE)

If JRE is already available in the required version, this step of the installation process can be ignored.

2. Installing the Agent
3. Installing the JDBC driver
4.

Additional important notes

5. Setting up the system environment
6. Starting the Agent

Use the ServiceManager to start or end the agent as a service.