Specify the JDBC_URL in the application filter. 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. The JDBC driver is a JAR file, which youll need to copy into your JBoss ASs. Download the JDBC driver for MS SQL Server. We assume you have already installed and running MS SQL Server. Jdbc:sqlserver://server:port DatabaseName=dbname You dont need to touch any code of your application. Specify the JDBC_URL in the Data Source application filter. 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 the agentparams.ini file.įor example, specify: CUSTOM_CLASS_PATH=C:\EPMAgent\lib\mssql-jdbc-6.4.0.jre8.jarįor more information about setting parameters in the agentparams.ini file, see Configuring the EPM Integration Agent Startup Parameters. The driver must be a JRE8 compatible driver.Ĭopy the jar file mssql-jdbc-6.4.0.jre8.jar to the EPM_AGENT_HOME/lib directory.įor example, copy the jar file to the C:\EPMAgent\lib directory. Download the Microsoft JDBC Driver 6.2 for SQL Server, a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Editions. To configure the Microsoft JDBC Driver for SQL Server:ĭownload the SQL server jar from the following website and unzip it: Download Microsoft JDBC Driver for SQL Server
MICROSOFT SQL SERVER JDBC DRIVER DOWNLOAD HOW TO
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.
0 kommentar(er)
