Locate the sqlsvr.sbo file under this Windows file path: To keep the file path short navigate to the \Documents\Microsoft_JDBC\Windows\sqljdbc_4.0\enu file path and copy the sqljdbc4.jarĭirectly under the Documents\Microsoft_JDBC folder. In the Linux folder save and extract the sqljdbc_.100_. Save and extract the sqljdbc_.100_enu.exe file in the Microsoft_JDBC folder. Under the Microsoft_JDBC folder create a folder named Linux. So take care when downloading and extracting them into the separate folders. Both the Windows and Linux jar file have an identical naming scheme. The best scenario is to use a short naming schema, since Long name sequences and special characters or spaces may end up creating problems. This will prompt you for a file location. It is Important to note that you will the Windows Client (.exe) and one for the Linux/Unix/Aix (.tar.gz) Scroll down and click on the section Microsoft® JDBC Driver 4.0 for SQL Server® Download The Appropriate Software Drivers From Microsoftĭownload the drivers from Microsoft for Sql Server 2012 HERE: For our purposes we shall set up the JDBC connection in the Windows Client for Information Design Tool for reporting to a Universe on a Linux.įor our demonstration we will use the Microsoft Sql Server 2012 JDBC Driver and the Linux Server where we have installed the SAP BusinessObjects BI Platform 4.1 SP4. If you check the Product availability matrix (PAM) for supported middleware for Linux is JDBC or to purchase a third party driver. An alternative is to use the JDBC provided from Microsoft. However with the release of BI 4 a licensed driver must be purchased for that driver. In previous versions of BusinessObjects a packaged Data Direct Driver was available for use. Microsoft Sql Server has not provided ODBC middleware for these platforms.
#Determine which microsoft jdbc driver needed how to#
This pages explains how to create a connection to SAP BusinessObjects BI Platform for a MS Windows Client to a Linux Unix or AIX Server. Check out this new easier Method for setting up JDBC on BI : Setting up JDBC with Extensions Purpose