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):
    User-added image
  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:
      User-added image
  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.

Attachments
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.