Capabilities

From HVR
Jump to: navigation, search

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:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
Log-based capture (capture from DBMS logging system) Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
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
Log-based capture of DDL statements using action AdaptDDL Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/21
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/21
  • Oracle from version 9.2 to version 18.0
Log-based capture of tables without a primary key Supported on all classes where Log-based capture is supported, except for:
Direct access to logs on a file system Supported on all classes where Log-based capture is supported, except for:
Access to logs using SQL interface Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0, since HVR 5.3.1/12
Log-based capture with /LogReadMethod param Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, 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:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 10.0 to version 18.0
Log-based capture from hidden rowid column (ColumnProperties /CaptureFromRowId) 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
Rewind log-based capture to specific time (hvrinit option -i) Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/15
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/15
  • Oracle from version 9.2 to version 18.0
Rewind log-based capture to the beginning of currently active oldest transaction Only supported on:
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Oracle from version 10.0 to version 18.0
Rewind log-based capture to the beginning of currently active oldest transaction for a specific list of tables Only supported on:
  • Oracle from version 10.0 to version 18.0
Online refresh using accurate LSN/SCN Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 10.0 to version 18.0
Online refresh skips capture log records early in scanner Only supported on:
  • Oracle from version 10.0 to version 18.0
Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
Log-based capture of truncate table statements Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • DB2 for i version 7.1, support depends on system setting
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/21
  • MySQL from version 5.6 to version 5.7, 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:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • SQL Server from 2005 to 2017, only FN mechanism, not SP
Capture from tables with basic compression Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 11.2.0.4 to version 18.0
Capture from tables with advanced compression Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 11.2.0.4 to version 18.0
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 compression Only supported on:
  • Oracle from version 12.2 to version 18.0
Log-based capture checkpointing (action Capture /CheckpointingFrequency) Only supported on:
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
hvrlogrelease to preserve journal/archives Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
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
Trigger-based capture (action Capture /TriggerBased) Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
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
Trigger-based capture jobs can be woken by db-event when change happens Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 10.0 to version 18.0

HVR Hub

This section lists the capabilities related to HVR Hub.

HVR Capability Support Status
Hub database Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1
  • MySQL from version 5.6 to version 5.7
  • Oracle from version 9.2 to version 18.0
  • Teradata from version 14.00 to version 16.10
  • 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:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), 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
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1
  • MySQL from version 5.6 to version 5.7
  • Oracle from version 9.2 to version 18.0
  • Teradata from version 14.00 to version 16.10
  • Vector from version 2.0 to version 5.1
Integrate with /Burst Supported on all classes where Integrate changes into location is supported, except for:
  • Kafka from version 0.8 to version 0.8
Integrate with /BurstCommitFrequency Supported on all classes where Integrate changes into location is supported, except for:
  • Hive ACID from version 2.1.0 to version 2.1.0
  • Kafka from version 0.8 to version 0.8
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 2.1.0
Action TableProperties with /DuplicateRows for continuous integration Supported on all classes where Integrate changes into location is supported, except for:
  • 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 2.1.0
  • Kafka from version 0.8 to version 0.8
  • Teradata from version 14.00 to version 16.10
Continuous integrate with /OnErrorSaveFailed (without /Burst) Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1
  • MySQL from version 5.6 to version 5.7
  • Oracle from version 9.2 to version 18.0
Disable/enable database triggers during integrate (/NoTriggerFiring) Only supported on:
  • Ingres from version 9.1 to version 11.0
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 (MySQL 5.6) to 2.0 (MySQL 5.7), 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
  • MariaDB from version 10.0 to version 10.1
  • MySQL from version 5.6 to version 5.7
Creation and update of HVR state tables Supported on all classes, except for:
  • Hive ACID from version 2.0.0 to version 2.1.0
  • Kafka from version 0.7 to version 0.8
Integrate with /DbProc Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0

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:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • HANA from version 1.0 SPS 11 to version 2.0 SPS 03, state table needs to be created before replication starts
  • Ingres from version 9.1 to version 11.0
  • MariaDB from version 10.0 to version 10.1, since HVR 5.3.1/13
  • MySQL from version 5.6 to version 5.7, since HVR 5.3.1/13
  • Oracle from version 9.2 to version 18.0
  • PostgreSQL from version 8.0 to version 10.0, state table needs to be created before replication starts
Collision Detect 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
Collision Detect with Trigger-based Capture (with Capture /TriggerBased and without Collision Detect /TimestampColumn) Supported on all classes where Trigger-based capture is supported, except for:
Collision Detect with /TimestampColumn Supported on all classes where Integrate changes into location is supported, except for:
  • Greenplum from version 4.0.0 to version 5.0.0
  • Hive ACID from version 2.1.0 to version 2.1.0
  • Kafka from version 0.8 to version 0.8
  • Teradata from version 14.00 to version 16.10
  • Vector from version 2.0 to version 5.1

Refresh and Compare

This section lists the capabilities related to Refresh and Compare.

HVR Capability Support Status
Refresh or Compare from source location Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Greenplum from version 3.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.0.0 to version 2.1.0
  • Ingres from version 1.0 to version 11.0
  • MariaDB from version 5.5 to version 10.1
  • MySQL from version 5.5 to version 5.7
  • Oracle from version 8.0 to version 18.0
  • Teradata from version 13.10 to version 16.10
  • Vector from version 1.0 to version 5.1
Select more than 4 billion rows during Refresh or Compare Supported on all classes, except for:
  • Ingres from version 1.0 to version 11.0
  • Kafka from version 0.7 to version 0.8
  • Vector from version 1.0 to version 5.1
Refresh into target location Supported on all classes
Row-wise refresh into target location (option -g) Supported on all classes, except for:
  • Hive ACID from version 2.0.0 to version 2.1.0
  • Kafka from version 0.7 to version 0.8
Disable/enable foreign keys and secondary indices during refresh (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 refresh Only supported on:
  • Oracle from version 8.0 to version 18.0
Disable/enable foreign keys from table to others during refresh (option -F) Only supported on:
Defer foreign keys during refresh (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 refresh 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 refresh (option -f) Only supported on:
  • Oracle from version 8.0 to version 18.0
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 (refresh 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 (refresh 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 (refresh option -Mserializable) Only supported on:
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • 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 'snapshot' SQL isolation level (refresh option -Msnapshot) Only supported on:
Enable foreign keys immediately after refresh 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:
  • Greenplum from version 3.0.0 to version 5.0.0
  • Hive ACID from version 2.0.0 to version 2.1.0
  • Kafka from version 0.7 to version 0.8
  • Teradata from version 13.10 to version 16.10
Call database procedure dbproc during replication jobs (action AgentPlugin /DbProc) Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
  • Teradata from version 14.00 to version 16.10
DbObjectGeneration with /IncludeSQLFile Only supported on:
  • Ingres from version 9.1 to version 11.0
  • Oracle from version 9.2 to version 18.0
International table and column names where DBMS is not configured with UTF-8 encoding Supported on all classes, except for:
  • MariaDB from version 5.5 to version 10.1
  • MySQL from version 5.5 to version 5.7
  • Teradata from version 13.10 to version 16.10
Lossless binary float datatypes. No dataloss when transporting float values (because base 2 fractions are never converted to base 10) Only supported on:
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Ingres from version 1.0 to version 11.0
  • Oracle from version 8.0 to version 18.0
Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames) Only supported on:
  • Aurora MySQL from 1.0 (MySQL 5.6) to 2.0 (MySQL 5.7), since HVR 5.3.1/25
  • Aurora PostgreSQL from 1.0 (PostgreSQL 9.6.3) to 1.2 (PostgreSQL 9.6.8), since HVR 5.3.1/25
  • Ingres from version 1.0 to version 11.0
  • MariaDB from version 5.5 to version 10.1
  • MySQL from version 5.5 to version 5.7
  • Oracle from version 8.0 to version 18.0
Reduce width of datatype when selecting or capturing changes (action ColumnProperties /TrimDatatype) Only supported on:
  • Oracle from version 8.0 to version 18.0