NC4 - E Team - Setting up JDBC Driver in Crystal Reports

NC4’s release of E Team R9.7 contains an embedded report viewer. When using this viewer all reports should be configured to use a JDBC connection. This document provides instructions for setting up a JDBC connection in Crystal 2016. This is a multi-step process that includes:

• Downloading sqljdbc4.jar driver.
• Editing CRConfig.xml.
• Creating new data connection in Crystal 2016.

How to Install JDBC Driver into Crystal Reports

1. Download sqljdbc4.jar driver. It is actually a .jar file when you unzip the Source file.
2. Place just the sqljdbc4.jar in the following folder: C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java/lib/external.
   Just the single .jar file.
3. Now got to C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\CRConfig.xml
4. Open this file in something like Notepad++ because you are going to modify the .xml file
5. Add the following line showing where the sqljdbc4.jar file is: "C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports\java/lib/external/sqljdbc4.jar";
6. The section in the .xml should look like this (it is the last greyed entry):
   
7. Now you will modify a few more lines:
   • Edit JDBCURL tag to put database server url. E.g. jdbc:sqlserver://Your Database Name\\Your E Team Instance Name:1433
   • My Db Server name you can get from your Database Admin, and the Instance name is in your eteam URL. Example: Demo.nc4d.com/eteam, eteam is the instance name. The :1433 is the secure port for E Team.
   • Should look something like this:
     <JDBCURL>jdbc:sqlserver://WIN-LUP5JAO2VK6\\eteam:1433</JDBCURL>
   • Edit the JDBCClassName tag to update driver classname.
     microsoft.sqlserver.jdbc.SQLServerDriver
   • Should look like this: <JDBCClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</JDBCClassName>
   • Edit JDBCUserName tag to enter user name for SQLserver. It is usually eteam.
   • Should look like this: <JDBCUserName>eteam</JDBCUse
   • The finished product should look like this:
     
8. Save the updated CRconfig.xml file.
9. Open Crystal Reports 2016, and create a new data connection on a new report. Select JDBC, enter the eteam password for the Database, and select the database you are going to use. You should get a result, scroll down to DBO and you will see tables and views.

You can download a copy of these instructions as well as the jar file needed below.