- #Microsoft jdbc driver for sql server how to#
- #Microsoft jdbc driver for sql server drivers#
- #Microsoft jdbc driver for sql server windows#
The steps to create a connection in IDT are demonstrated in the Official Product Tutorials HERE: Information Design Tool TurorialsĬreating a JDBC Connection on the BI Server Proceed with creating a connection shortcut, creating a universe and publishing it to the BI repository. When the “The server is responding!” message pops up then the connection is successful.
#Microsoft jdbc driver for sql server windows#
Launch the Information Design Tool on the Windows Client and create a new connection to Microsoft Sql Server 2012 and select the JDBC option. Or use the Windows Client sqlsvr.sbo sample attached HERE: sqlsrv.zip REPLACE it with your file path to the sqljdbc4.jar file.Ĭ:\Program Files (x86)\Microsoft_JDBC\sqljdbc4.jar jdbc:sqlserver://$DATASOURCE$ DatabaseName=$DATABASE$ Scroll down and locate the following section:Ĭom. Open the original sqlsvr.sbo with MS Notepad to edit. Make a backup copy of the file before making any changes! :\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\ 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®
#Microsoft jdbc driver for sql server drivers#
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.
#Microsoft jdbc driver for sql server 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
0 kommentar(er)
