Capabilities for HANA

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on HANA. For more information about the requirements, access privileges, and other features of HVR when using Aurora MySQL for replication, see Requirements for HANA.

Capture

HVR supports the following capabilities on HANA:

  • Capture changes from location
  • Log-based capture (capture from DBMS logging system)
  • Log-based capture of tables without a primary key
  • Direct access to logs on a file system
  • Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId)
  • Rewind log-based capture to specific time (hvrinit option -i)
  • Online refresh using accurate LSN/SCN
  • Multiple log-based capture jobs can capture from same database
  • Read archives from an alternative directory (Capture /ArchiveLogPath)


HVR does not support the following capabilities on HANA:

  • Log-based capture of DDL statements using action AdaptDDL
  • Access to logs using SQL interface
  • Log-based capture of tables with LOB column
  • 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 (action Capture /CheckpointingFrequency)
  • hvrlogrelease to preserve journal/archives
  • Trigger-based capture (action Capture /TriggerBased)


HVR Hub

HVR does not support Hub database on HANA


Integrate

HVR supports the following capabilities on HANA:


HVR does not support the following capabilities on HANA:

  • Action TableProperties with /DuplicateRows for continuous integration
  • Continuous integrate with /OnErrorSaveFailed (without /Burst)
  • Disable/enable database triggers during integrate (/NoTriggerFiring)
  • Integrate with /DbProc


Bi-directional Replication

HVR supports the following capabilities on HANA:

  • Detection of changes made by HVR in a bidirectional channel to prevent loop-back, state table needs to be created before replication starts
  • Collision Detect with /TimestampColumn


HVR does not support the following capabilities on HANA:


Refresh and Compare

HVR supports the following capabilities on HANA:


Other Capabilities

HVR supports the following capabilities on HANA:

  • International table and column names where DBMS is not configured with UTF-8 encoding


HVR does not support the following capabilities on HANA:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)
  • Lossless binary float datatypes. No dataloss when transporting float values (because base 2 fractions are never converted to base 10)