We’ll be using the Extensions approach, which is pretty simple as the other is just the way of pain! Useful Using Extensions approach with sub-folders in the connection-server folders.sbo files in the connection-server folders They both involve changes to the SAP BI 4.x connection-server files. Note that as far as SAP BI 4.x connectivity is concerned, and this is documented in the SAP BI 4.x DataAccess Guides, there are two main ways of configuring JDBC connectivity. As it is a WIP I hope to keep on updating it going forward. This is my first blog post and there are a couple of supporting blog posts I need to put together to help with the basics on this one. The target audience are those among us who don’t necessarily do ‘techie work’ day2day but have some task put on them that they just need to get done. There are a number of useful blog posts covering this topic but hopefully I can add some useful information and troubleshooting. Specify the JDBC_URL in the application filter.This blog post describes setting up JDBC connectivity to various databases, from SAP BI 4.x client and server machines on MS Windows and linux. Jdbc:sqlserver://server:port DatabaseName=dbname 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. 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 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)
