2443638 - How to connect to HANA via a JDBC connection in Crystal Reports?

• How to configure a JDBC connection to HANA?
• How to create a JDBC connection to HANA database in Crystal Reports?
• When attempting to connect to HANA via a JDBC connection in Crystal Reports, it fails with the error: "Driver not found" 
      
             
• Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
         
• SAP HANA 2.0

• To connect to HANA via a JDBC connection in Crystal Reports, perform the following steps on the computer where Crystal Reports is installed:
      
1. Download and Install the HANA client with the JDBC component.
         
   To download the SAP HANA Client go to the SAP Software Download Center, and under the tab "SUPPORT PACKAGES & PATCHES", select the following:
• By Category
• SAP IN-MEMORY (SAP HANA )
• HANA PLATFORM EDITION
• SAP HANA PLATFORM EDITION
• SAP HANA PLATFORM EDITION 2.0
• SAP HANA CLIENT 2.0
• In the SAP HANA CLIENT 2.0 download page, in the operating system drop-down list, select 32bit, or 64bit of windows, depending on the version of Crystal Reports you are using:
            
  • For Crystal Reports 2013, 2016: (32bit) 
    "WINDOWS SERVER ON IA32 32BIT"
      
  • For Crystal Reports 2020: (64bit) 
    "WINDOWS ON X64 64BIT" 
  
                 
2. Locate the HANA JDBC driver: ngdbc.jar
     
   By default, it is located at:  C:\Program Files (x86)\SAP\hdbclient\ngdbc.jar
            
       
3. Add the HANA JDBC driver path, to the "<Classpath>" parameter of the Crystal Reports configuration file: crconfig.xml
              
   By default the file: crconfig.xml, is located at: 
       
        C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java 
      
   And the line to update looks like: 
   
        <Classpath>C:\Program Files (x86)\SAP\hdbclient\ngdbc.jar;...
         
                
4. Save the change made in the file: crconfig.xml
        
5. Restart Crystal Reports, so it picks up the change.
            
6. Create a new report, and in the "Database Expert" double click on: JDBC (JNDI)
         
7. In the JDBC (JNDI) window, enter the following information:
• Connection URL        : jdbc:sap://<HANA SERVER>:<PORT NUMBER>
• Database Classname : com.sap.db.jdbc.Driver
    
  Notes:
  - Add your <HANA SERVER> and <PORT NUMBER> in the Connection URL. If you do not have this information, contact your HANA Database Administrator.
  - Also note the port number works as follow: 3 + <HANA Instance number > + 15
     For example, the port number: 30015  means: 3 + HANA Instance number: 00 + 15
     If the instance number is: 02, then the port number would be 30215
        
    
  

Java, HANA, CR, connection , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020