Configuring the Microsoft JDBC Driver for SQL Server in the EPM Integration Agent
If you plan to use the Microsoft Java Database Connectivity (JDBC) driver to connect to the SQL Server in the EPM Integration Agent, this section describes how to download and configure the driver.
To configure the Microsoft JDBC Driver for SQL Server:
-
Download the SQL server jar from the following website and unzip it: Download Microsoft JDBC Driver for SQL Server
The driver must be a JRE8 compatible driver.
-
Copy the jar file
mssql-jdbc-6.4.0.jre8.jar
to theEPM_AGENT_HOME/lib
directory.For example, copy the jar file to the
C:\EPMAgent\lib
directory. -
Specify the location of the
mssql-jdbc-6.4.0.jre8.jar
in the EPM Integration Agent by setting the CUSTOM_CLASS_PATH parameter in theagentparams.ini
file.For example, specify:
CUSTOM_CLASS_PATH=C:\EPMAgent\lib\mssql-jdbc-6.4.0.jre8.jar
For more information about setting parameters in the
agentparams.ini
file, see Configuring the EPM Integration Agent Startup Parameters. -
Specify the JDBC_URL in the Data Source application filter.
THE JDBC_URL must be in the format:
jdbc:sqlserver://server:port;DatabaseName=dbname
-
Specify the JDBC_URL in the application filter.
THE JDBC_URL must be in the format:
jdbc:sqlserver://server:port;DatabaseName=dbname