SAP HANA Requirements - DSS 6 | Data Source Solutions Documentation
Documentation: SAP HANA Requirements - DSS 6 | Data Source Solutions Documentation
SAP HANA Requirements
This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using SAP HANA for replication.
Supported Platforms
- Learn about the SAP HANA versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what DSS offers for Redshift on our Capabilities for SAP HANA page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
-
Learn how DSS maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported SAP HANA data types and their mapping, see Data Type Mapping for SAP HANA.
-
Understand the character encodings DSS supports for SAP HANA on the Supported Character Encodings page.
Data Source Solutions provides additional solutions for replicating data from SAP database. For more information, see section SAP in Databases.
ODBC Connection
DSS requires that the HANA client (which contains the HANA ODBC driver) to be installed on the machine from which DSS connects to HANA. DSS uses HANA ODBC driver to connect, read and write data to HANA. For information about the supported ODBC driver version, refer to the DSS release notes (dss.rel) available in dss_home directory or the download page.
DSS does not support integrating changes captured from HANA into databases where the distribution key cannot be updated (e.g. Greenplum, Azure Synapse Analytics).
Connecting to Remote HANA Location from Hub
DSS allows you to connect from a hub machine to a remote HANA database by using any of the following two methods:
- Connect to an DSS installation running on the HANA database machine using DSS's protocol on a special TCP port number (e.g. 4343). This option must be used for log-based capture from HANA.
- Use ODBC to connect directly to a HANA database remotely. In this case no additional software is required to be installed on the HANA database server itself. This option cannot be used for log-based capture from HANA database.
Upgrading HANA Database
When upgrading a HANA database (e.g. from HANA 2.0 SPS 04 to HANA 2.0 SPS 05), DSS may fail with the 'invalid column name' DBMS error.
The solution is to recreate all the views in the _DSS schema by running the DSS_HOME/dbms/hana/dsshanaviews.sql script after the upgrade. The script must be run by the SYSTEM user.
Notes for Migrating from DSS 5.x
In DSS, the name of the views in the _DSS schema has changed, so the views with new names should be created. This can be done by executing the dsshanaviews.sql script from the DSS_HOME/dbms/hana directory.
The 'old' views from DSS5 can then be dropped manually, unless both DSS and DSS5 need to be used simultaneously.