SAP Knowledge Base Article - Public

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

Symptom

  • 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.

Environment

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

Resolution

  • 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
              
          
        Hana JDBC_03.JPG

Keywords

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

Product

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