Overview
Syniti Replicate allows you to replicate data from relational database tables to SAP HANA in the following ways:
Refresh (Snapshot replication) A one-time complete replication from any major relational database source to SAP HANA as a target, according to replication settings and scripts. You can control the timing of the replication, identify the columns to be replicated and add scripts to transform data during replication. Source databases include Oracle, Microsoft SQL Server, IBM Db2 for i, IBM Db2 LUW, Sybase, Informix, MySQL. Continuous refresh A regularly scheduled refresh replication as described above. The schedule is defined in the replication settings.
One-way mirroring (Incremental Replication) A continuous update of replicated tables based on changes to the source database that have been recorded in the database server log. Typically, this involves an initial refresh operation, as described above, to set up the target table. Then you can define the replication settings to check the transaction log on the source database at regular intervals. Any changes found in the log are applied to data on the SAP HANA platform.
Versions Supported
Syniti Replicates supports SAP HANA Cloud and On-Premises architecture, starting from version 1 or higher.
Permissions
The user performing operations should have the following PostgreSQL permissions:
CONNECT: Required to connect to the database.
USAGE on Schemas: Grants access to specific schemas where tables are located.
SELECT on Tables: Required to read data from the tables where CDC will be performed.
INSERT/UPDATE/DELETE: Required to execute operations into the target tables.
Replicating Data to SAP HANA
To connect with SAP HANA you can use two options; an ODBC or a .NET connection. Each connection utilize a different method to execute Refresh replications.
Using an ODBC Connection
To use ODBC connection, select connection properties, under providers select “SAP HANA ODBC Driver”
Syniti replicate uses a Bulk Insert option to improve the data loading into SAP HANA. For bulk type you have two options:
ArrayBinding: Technique used to optimize database performance by allowing multiple rows of data to be inserted or updated in a single database call.
FTP: Utilize FTP protocol to load data into the SAP HANA system. Available just for on-premises systems.
To modify this setting, you have to right-click into the HANA connection, under Refresh Options section. You also can modify the block size.
Using a .NET Connection
To use a .NET connection, select connection properties, the .NET option is select by default.
If you want to use Bulk Insert capabilities, the only option available is “Native” mode, which utilize the native functionality of the provider.
Data Mapping
When SAP HANA is used as a target system, the mapping of Syniti Replicate data types to the corresponding data type in SAP HANA is listed in the following table:
Replicate Mapping | HANA |
Bit | tinyint |
Tinyint | tinyint |
Smallint | smallint |
Integer | integer |
Bigint | bigint |
Double | double |
Real | real |
Float | real |
Numeric min_prec="1" max_prec="34" | decimal |
Decimal | decimal, smalldecimal |
Char | varchar |
Varchar | varchar, alphanum |
NChar | nvarchar |
NVarchar | nvarchar |
Date | date |
Time | time |
Timestamp | timestamp, seconddate |
Smalldatetime | timestamp |
LongVarchar | varchar(5000) |
Smallmoney | numeric(10,4) |
Binary | varbinary |
Varbinary | varbinary |
LongVarbinary | varbinary |
Number | decimal |
Money | decimal(20,4) |
Blob | blob |
Clob | clob |
NText | nclob |
GUID | varchar(16) |
AutoDecimal | decimal |
AutoNumeric | decimal |
AutoTinyint | smallint |
AutoSmallint | smallint |
AutoInteger | integer |
Sysname | nvarchar(128) |
Xml | varchar(64000) |
Json | varchar(64000) |
Limitations
Mirroring bulk is not supported for SAP HANA as target.
Bulk Insert using FTP is not supported for SAP HANA BTP Cloud Edition.