Capabilities for SAP HANA

This section lists the Capabilities of Fivetran HVR when using 'SAP HANA'. For more information about the pre-requisites, access privileges, and other configuration requirements, see SAP HANA Requirements.

Capture

HVR supports the following capabilities on SAP HANA:

• Capture changes from location (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Log-based capture (capture from DBMS logging system) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Capture from Archive log files only (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Log-based capture of tables without a primary key (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Direct access to logs on a file system (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Log-based capture of tables with LOB column (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Log-based capture from hidden rowid/RRN column (ColumnProperties with parameter CaptureFromRowId) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Rewind log-based capture to specific time (hvractivate option -i) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Online refresh using accurate LSN/SCN (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Multiple log-based capture jobs can capture from same database (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Read archives from an alternative directory (location property Archive_Log_Path on the capture location) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).

HVR does not support the following capabilities on SAP HANA:

• Access to logs using SQL interface.
• Rewind log-based capture to the beginning of currently active oldest transaction.
• Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions.
• Log-based capture of truncate table statements.
• Capture from tables with basic compression.
• Log-based capture checkpointing using location property Capture_Checkpoint_Frequency.
• Trigger-based capture (location property Capture_Method=DB_TRIGGER on the capture location).

Repository Database

HVR does not support Repository database on SAP HANA.

Integrate

HVR supports the following capabilities on SAP HANA:

• Integrate changes into location (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Burst integration (Integrate with parameter Method=BURST) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Integrate with parameter BurstCommitFrequency (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Continuous integration (Integrate with parameter Method=CONTINUOUS) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• ColumnProperties with parameter SoftDelete (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Bulk load requires a staging area (location property Staging_Directory) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Creation and update of HVR state tables (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).

HVR does not support the following capabilities on SAP HANA:

• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration.
• Continuous integrate with parameter OnErrorSaveFailed.
• Disable/enable database triggers during integrate (with parameter NoTriggerFiring).
• Integrate with parameter DbProc.

Bi-directional Replication

HVR supports the following capabilities on SAP HANA:

• Detection of changes made by HVR in a bidirectional channel to prevent loop-back (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07, state table needs to be created before replication starts).
• CollisionDetect with parameter TimestampColumn (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).

HVR does not support the following capabilities on SAP HANA:

• CollisionDetect with Log-based Capture (without parameter TimestampColumn).

Refresh and Compare

HVR supports the following capabilities on SAP HANA:

• hvrrefresh or hvrcompare from source location (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• hvrrefresh into target location (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Row-wise hvrrefresh into target location (option -g) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).

Other Capabilities

HVR supports the following capabilities on SAP HANA:

• Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• International table and column names where DBMS is not configured with UTF-8 encoding (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Treat DBMS table names and columns as case sensitive if configured (location property Case_Sensitive_Names) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Treat DBMS schema names as case sensitive if configured (location property Case_Sensitive_Names) (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).
• Distinguish and support capture from 'column store tables' (SAP HANA from version 2.0 SPS 00 to version 2.0 SPS 07).

HVR does not support the following capabilities on SAP HANA:

• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey).
• Lossless binary float datatypes. No data loss when transporting float values (because base 2 fractions are never converted to base 10). The values for these datatypes, when selected back from the database, might be slightly different from the ones that were inserted. This leads to Compare differences..
• Distinguish and support capture from 'row store tables'.