Replicating data to HANA using SAP Sybase Replication Server
03:07
As most of you already know Real Time Data Platform (RTDP) consists on several SAP software products that will enable extreme data management capabilities in your company and both HANA and SAP Sybase Replication Server are included in it. SAP Sybase Replication Server version 15.7.1 SP100 is general available in June 2013 and this is the first version including support for data replication to HANA, it is important to remark that at the moment it is only certified with non-SAP applications, certification for SAP applications will come with next SAP Sybase Replication Server release in the near future.
In today’s post I am going to describe the architecture for data replication to HANA using SAP Sybase Replication Server, explaining some specific details to take into account and I will also show how to configure data replication to HANA with a “how to” video.
Architecture for data replication to HANA
Points to remark in this architecture:
- Primary DB can be any SAP Sybase Replication Server primary supported DBMS (ASE, Oracle, MSSQL and DB2/UDB)
- A new connector called ECH (Express Connect for HANA) has been implemented similar to the one we have for Oracle (ECO). ECH establishes a direct
- Interesting SAP Sybase Replication Server functionalities can be used with HANA:
- Multipath replication supported from ASE and Oracle
- Supports function string customization
- Supports Multiple Site Availabitily
- New materialization method called "Direct load" (no materialization queues created so best performance)
- HVAR replication (Advanced Service Options license required)
- ...
ECH connector properties
- This new connector accesses SAP HANA instance via SAP HANA odbc driver
- ECH consists in 2 dynamic libraries shipped with SAP Sybase Replication Server (libsybhdb and libsybhdbodbc) that are linked with SAP HANA odbc driver (libodbcHDB)
- SAP HANA odbc driver is not shipped with SAP Sybase Replication Server, you have to download and install it yourself
- ECH works in a similar way than the connector for Oracle (ECO) and using it we avoid the need of a gateway/middleware that would impact performance
- ECH is integrated both with SAP Sybase Replication Server interfaces file and with hdbuserstore utility in HANA client. This means that you can add an entry for the HANA instance in SAP Sybase Replication Server interfaces file or use hdbuserstore HANA client utility to create a KEY (HANA instance) specifiying HANA instance name, host, port, user name and password so that SAP Sybase Replication Server can access HANA instance bypassing interfaces file and using the hdbuserstore KEY
- Direct load materialization support for HANA, no need to use materialization queues (this requires Rep Agent 15.7.1 SP100)
Configuring replication from ASE to HANA
In the “how to” video below I go through the steps for establishing a replication system replication from ASE to HANA using SAP Sybase Replication Server.
Steps:
- Create the connection to primary ASE database (rs_init)
- Create the connection to the HANA database (manually with create connection command). Note that: connection has to be created using profile rs_ase_to_hanadb;ech
- Create table at primary ASE database and mark it
- Create table at replicate HANA database
- Create replication definition
- Create subscription
I hope this post can be useful to anyone who wants to start replicating to SAP HANA using SAP Sybase Replication Server system. More interesting discussions on the topic of heterogeneous replication and data replication techniques will be described in upcoming blog posts.
0 comments