Capabilities

Contents

This section describes the capabilities supported by HVR on each location class.

Capture

This section lists the capabilities related to Capture.

HVR Capability

Support Status

Capture changes from location

Only supported on:

  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 8.0 to version 11.4
  • SQL Server from 2000 (with SP1+) to 2017
  • Salesforce

Log-based capture (capture from DBMS logging system)

Only supported on:

  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 9.4 to version 11.4
  • SQL Server from 2005 to 2017

Capture from Archive log files only

Only supported on:

  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Oracle from version 9.2 to version 18.0
  • SQL Server from 2005 to 2017

Log-based capture of DDL statements using action AdaptDDL

Only supported on:

  • Aurora MySQL from 1.0 to 2.0, since HVR 5.3.1/25
  • DB2 for i version 7.1, since HVR 5.3.1/12
  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/21
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/21

Log-based capture of tables without a primary key

Supported on all classes where Log-based capture (capture from DBMS logging system) is supported, except for:

Direct access to logs on a file system

Supported on all classes where Log-based capture (capture from DBMS logging system) is supported, except for:

Access to logs using SQL interface

Only supported on:

  • Oracle from version 9.2 to version 18.0, since HVR 5.3.1/12
  • PostgreSQL from version 9.4 to version 11.4
  • SQL Server from 2005 to 2017

Log-based capture with /LogReadMethod parameter

Only supported on:

  • Aurora MySQL from 1.0 to 2.0, since HVR 5.3.1/25
  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0, since HVR 5.3.1/12

Log-based capture of tables with LOB column

Only supported on:

  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/13
  • Oracle from version 10.0 to version 18.0
  • PostgreSQL from version 9.4 to version 11.4
  • SQL Server from 2005 to 2017

Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId)

Only supported on:

  • DB2 for i version 7.1
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Oracle from version 9.2 to version 18.0

Rewind log-based capture to specific time (Hvrinit option -i)

Only supported on:

  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/15
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 9.4 to version 11.4
  • SQL Server from 2005 to 2017

Rewind log-based capture to the beginning of currently active oldest transaction

Only supported on:

Rewind log-based capture to the beginning of currently active oldest transaction for a specific list of tables

Only supported on:

Online refresh using accurate LSN/SCN

Only supported on:

  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/13
  • Oracle from version 10.0 to version 18.0
  • SQL Server from 2005 to 2017

Online refresh skips capture log records early in scanner

Only supported on:

Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions

Only supported on:

Log-based capture of truncate table statements

Only supported on:

  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/21
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/21
  • Oracle from version 9.2 to version 18.0

Multiple log-based capture jobs can capture from same database

Only supported on:

  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 9.4 to version 11.4
  • SQL Server from 2005 to 2017, only FN mechanism, not SP

Capture from tables with basic compression

Only supported on:

Capture from tables with advanced compression

Only supported on:

Capture from tables with BLOB compression

Only supported on:

  • Oracle from version 11.2.0.4 to version 18.0

Capture from tables with advanced index compression

Only supported on:

  • Oracle from version 12.2 to version 18.0

Capture from tables with advanced row compression

Only supported on:

  • Oracle from version 12.0 to version 18.0

Log-based capture checkpointing (action Capture /CheckpointingFrequency)

Only supported on:

  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 9.4 to version 11.4

Hvrlogrelease to preserve journal/archives

Only supported on:

Read archives from an alternative directory (Capture /ArchiveLogPath)

Only supported on:

  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Oracle from version 10.0 to version 18.0
  • SQL Server from 2005 to 2017

Trigger-based capture (action Capture /TriggerBased)

Only supported on:

Capture /QuickToggle

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0

Boundaries between transactions preserved by trigger-based capture

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
  • SQL Server from 2000 (with SP1+) to 2017

Trigger-based capture jobs can be woken by db-event when change happens

Only supported on:

Hub Database

This section lists the capabilities related to Hub Database.

HVR Capability

Support Status

Hub database

Only supported on:

  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 8.0 to version 11.4
  • SQL Server from 2000 (with SP1+) to 2017
  • Teradata from version 14.00 to version 16.20
  • Vector from version 2.0 to version 5.1

Integrate

This section lists the capabilities related to Integrate.

HVR Capability

Support Status

Integrate changes into location

Only supported on:

Integrate with /Burst

Supported on all classes where Integrate changes into location is supported, except for:

Integrate with /BurstCommitFrequency

Supported on all classes where Integrate changes into location is supported, except for:

Continuous integration (Integrate without /Burst)

Supported on all classes where Integrate changes into location is supported, except for:

  • Hive ACID from version 2.1.0 to version 3.1.0

Action TableProperties with /DuplicateRows for continuous integration

Supported on all classes where Integrate changes into location is supported, except for:

Continuous Integrate with /OnErrorSaveFailed (without /Burst)

Only supported on:

  • MariaDB from version 10.0 to version 10.3
  • MySQL from version 5.6 to version 8.0
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 8.0 to version 11.4
  • SQL Server from 2000 (with SP1+) to 2017

Disable/enable database triggers during Integrate (/NoTriggerFiring)

Only supported on:

Action Transform /SoftDelete

Supported on all classes where Integrate changes into location is supported

Bulk load requires a staging area (LocationProperties /StagingDirectoryHvr)

Only supported on:

  • Aurora MySQL from 1.0 to 2.0, since HVR 5.3.1/25
  • Greenplum from version 4.0.0 to version 5.0.0
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Hive ACID from version 2.1.0 to version 3.1.0
  • MariaDB from version 10.0 to version 10.3

Creation and update of HVR state tables

Supported on all classes, except for:

Integrate with /DbProc

Only supported on:

Bi-directional Replication

This section lists the capabilities related to Bi-directional Replication.

HVR Capability

Support Status

Detection of changes made by HVR in a bidirectional channel to prevent loop-back

Only supported on:

  • MariaDB from version 10.0 to version 10.3, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 8.0, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 8.0 to version 11.4, state table needs to be created before replication starts
  • SQL Server from 2000 (with SP1+) to 2017

CollisionDetect with Log-based Capture (without /TimestampColumn)

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0

CollisionDetect with Trigger-based Capture (with Capture /TriggerBased and without CollisionDetect /TimestampColumn)

Supported on all classes where Trigger-based capture (action Capture /TriggerBased) is supported, except for:

CollisionDetect with /TimestampColumn

Supported on all classes where Integrate changes into location is supported, except for:

Refresh and Compare

This section lists the capabilities related to Refresh and Compare.

HVR Capability

Support Status

Hvrrefresh or Hvrcompare from source location

Only supported on:

Select more than 4 billion rows during Hvrrefresh or Hvrcompare

Supported on all classes, except for:

Hvrrefresh into target location

Supported on all classes

Row-wise Hvrrefresh into target location (option -g)

Supported on all classes, except for:

Disable/enable foreign keys and secondary indices during Hvrrefresh (option -F)

Only supported on:

  • Ingres from version 1.0 to version 11.0
  • Oracle from version 8.0 to version 18.0
  • Vector from version 1.0 to version 5.1

Disable/enable constraints check during Hvrrefresh

Only supported on:

  • Oracle from version 8.0 to version 18.0

Disable/enable foreign keys from table to others during Hvrrefresh (option -F)

Only supported on:

Defer foreign keys during Hvrrefresh (option -F)

Only supported on:

  • Oracle from version 8.0 to version 18.0

For a table: disable/enable journaling, disable/enable unique/primary constraints, disable/enable volatile secondary indices, support main storage structure during Hvrrefresh

Only supported on:

  • Ingres from version 1.0 to version 11.0
  • Vector from version 1.0 to version 5.1

Disable/enable triggers during Hvrrefresh (option -f)

Only supported on:

Replicate database sequences (using action DbSequence)

Only supported on:

  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0

Suggestions in GUI for Slice Boundaries using DBMS statistics (Hvrrefresh option -S)

Only supported on:

  • Oracle from version 11.0 to version 18.0, since HVR 5.3.1/21

Select data from each table from same consistent moment in time (Hvrrefresh options -Mnow, -Mscn=val, -Mhvr_tx_seq=val, -Mtime)

Only supported on:

  • Oracle from version 8.0 to version 18.0

Select data from each table from same consistent moment in time using a single transaction (and session) with 'serializable' SQL isolation level (Hvrrefresh option -Mserializable)

Only supported on:

Select data from each table from same consistent moment in time using a single transaction (and session) with 'snapshot' SQL isolation level (Hvrrefresh option -Msnapshot)

Only supported on:

Enable foreign keys immediately after Hvrrefresh option -Mserializable as done on -Msnapshot and -Mnow

Only supported on:

  • Oracle from version 8.0 to version 18.0

Other Capabilities

This section lists the capabilities related to Other Capabilities.

HVR Capability

Support Status

Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)

Only supported on:

Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc)

Only supported on:

DbObjectGeneration with /IncludeSQLFile

Only supported on:

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

Supported on all classes

Lossless binary float datatypes. No dataloss when transporting float values (because base 2 fractions are never converted to base 10)

Only supported on:

Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames)

Only supported on:

  • MySQL from version 5.5 to version 8.0
  • Oracle from version 8.0 to version 18.0
  • PostgreSQL from version 7.0 to version 11.4
  • Redshift version 1.0, since HVR 5.6.5/1
  • SQL Server from 1998 to 2017, since HVR 5.6.5/1
  • Snowflake version 2.8, since HVR 5.6.5/1
  • Teradata from version 13.10 to version 16.20, since HVR 5.6.5/1
  • Vector from version 1.0 to version 5.1

Always treat DBMS table names and column names case sensitive

Only supported on:

Reduce width of datatype when selecting or capturing changes (action ColumnProperties /TrimDatatype)

Only supported on:

  • Oracle from version 8.0 to version 18.0

Distinguish and support capture from 'materialized views'

Only supported on:

Distinguish and support capture from 'row store tables'

Not supported

Distinguish and support capture from 'column store tables'

Only supported on:

  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03