- Is it possible to connect to Oracle without installing the Oracle client?
- How to report of Oracle in Crystal Reports, without having to install and configure the Oracle client?
- When using an Oracle Native connection, or an ODBC connection, we need to have the Oracle client installed, and configured, on the same computer as Crsystal Reports is installed. Is it possible to connect to Oracle in Crystal Reports without having to install and configure the Oracle client?
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- Oracle 12c
- Oracle 18c
- Oracle 19c
- To connect to Oracle without having to install and configure the Oracle Client, you can use:
- An ODBC connection using the CR Oracle Wire Protocol ODBC driver; or
- A JDBC connection.
- Before using any of the above connection, first confirm the connection type is supported for the version of Oracle you are using, by looking at the Crystal Reports supported platform document available in the SAP Knowledge Base Article: 2859510
To create an ODBC connection using the CR Oracle Wire Protocol ODBC driver:
- Open the Microsoft ODBC Data Source Administrator 32bit or 64bit depending on the version of Crystal Reports used:
- 32bit for Crystal Reports 2013, 2016
- 64bit for Crystal Reports 2020
CR Oracle Wire Protocol ODBC Driver
If you do not have it, then you need to modify the Crystal Reports installation, and add the Data Direct ODBC driver, which will install the CR Oracle Wire Protocol ODBC Driver. For more information, see the SAP Knowledge Base Article: 1218152
To create the ODBC DSN, you will need the following information for your Oracle Server:
- Host Name
- Port Number
- Service Name
- User Name and Password
If you need assistance, contact your Oracle Database Administrator to request this information.
To create a JDBC connection to Oracle:
Download the Oracle JDBC driver from Oracle.
Note: You will need an Oracle account to download the Oracle JDBC driver from the Oracle website. If you need assistance, contact your Oracle Database Administrator.
- On the computer where Crystal Reports is installed, extract and copy the Oracle JDBC jar file in a folder like:
- Add the path to the Oracle JDBC jar file to the Classpath of the crconfig.xml file, which is located by default at:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java
For example: If the Oracle JDBC jar files are located in: C:\Oracle_JDBC, then in the crconfig.xml file, add it to the class path like:
- Restart Crystal Reports, so it picks up the change .
- Create a new report, and in the "Database Expert", under "Create New Connection", double click on: JDBC (JNDI)
- In the JDBC (JNDI) window, enter the following information:
- Connection URL: jdbc:oracle:thin:@//<server-name>:<port>/<service-name>
- Database Classname: oracle.jdbc.OracleDriver
- Connection Name (Optional):
If the Oracle server information is:
- Server Name : MyOracleServer.corp
- Port Number : 1521
- Service Name: MyServiceName
Then the information to enter will be:
- Connection URL : jdbc:oracle:thin:@//MyOracleServer.corp:1521/MyServiceName
- Database Classname : oracle.jdbc.OracleDriver
For more detailed on how to connect via a JDBC connection, see the SAP Knowledge Base Article: 1527666
CR, ORA , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To