After you upgrade to SAP HANA 2.0, the engine’s hierarchy changes: This all comes down to the fact, that SAP HANA 2.0 is by default running in MDC (SAP HANA multitenant database containers) mode. Īs stated previously, from a Crystal Reports perspective there is a noticeable difference in ODBC connection properties compared to SAP HANA 1.0. Several great SAP blogs can be found detailing the changes (example: blog post ). As a consequence, several changes were introduced from a technical / hierarchy standpoint, compared to the previous SAP HANA 1.0 database engine. Since version 10 of SAP Business One, version for SAP HANA, the SAP HANA 2.0 database engine was adopted. SAP Note 2932941 – How To Connect to the Database From Crystal Reports Designer With HANA multitenant database containers (MDC)Īdditional background on the change from SAP HANA 1.0 to SAP HANA 2.0 with regards to SAP Business One, version for SAP HANA SAP Note 2900925 – You Can Only Use the B1CRHPROXY32 and HDBODBC32 Drivers When You Are Connecting to the ODBC Data Source From Crystal Reports Designer If you want to see some additional documentation, the difference between the two drivers or to know more about the background, continue reading below.įor more information, see the guide How to Set Up SAP Business One, version for SAP HANA Data Sources for Crystal Reports on This concludes our blog post on how to create a new SAP Crystal Reports Layouts/Reports database connection to be used later in SAP Business One 10.0, version for SAP HANA. To use B1CRHPROXY32 as the connection driver, enter DRIVER= SERVERNODE=: DATABASENAME= CURRENTSCHEMA= UID= PWD= See examples below, ensuring to replace any angle brackets items(including the brackets) with your relevant system data. Select the Enter Connection String radio button, and in the Connection String field, enter strings to use either the B1CRHPROXY32 or HDBODBC32 driver. The ODBC(RDO) Data Source Selection window appears. In the Database Expert window, in the Available Data Sources pane on the left-hand side of the screen, choose Create New Connection → ODBC(RDO) → Make New Connection. A tab for the new report with the Database Expert window appears. On the SAP Crystal Reports Start Page, choose Blank report. See the end of this blog for a brief background. From a SAP Crystal Reports perspective there is a noticeable difference in ODBC connection properties compared to SAP HANA 1.0. You will find details on how to define a database connection to SAP HANA 2.0.

In this blog we explain how to create a new SAP Crystal Reports Layouts/Reports database connection to be used later in SAP Business One 10.0, version for SAP HANA.

Sap crystal reports runtime windows 10