Capabilities
This section describes the capabilities supported by Fivetran HVR on each location type.
Capture
This section lists the capabilities related to Capture.
| Capability | Support Status |
|---|---|
| Capture changes from location | Only supported on:
|
| Log-based capture (capture from DBMS logging system) | Only supported on:
|
| Capture from Archive log files only | Only supported on:
|
| Log-based capture of DDL statements using action AdaptDDL | Only supported on:
|
| Log-based capture of DDL statements (AdaptDDL) without refresh | Only supported on:
|
| Log-based capture of tables without a primary key | Supported on all location types where Log-based capture (capture from DBMS logging system) is supported |
| Direct access to logs on a file system | Only supported on:
|
| Access to logs using SQL interface | Supported on all location types where Log-based capture (capture from DBMS logging system) is supported, except for:
|
| Log-based capture of tables with LOB column | Supported on all location types where Log-based capture (capture from DBMS logging system) is supported |
| Log-based capture from hidden rowid/RRN column (ColumnProperties with parameter CaptureFromRowId) | Only supported on:
|
| Rewind log-based capture to specific time (hvractivate option -i) | Supported on all location types where Log-based capture (capture from DBMS logging system) is supported, except for:
|
| Rewind log-based capture to specific time (hvractivate option -i) with Capture Method SQL | Only supported on:
|
| Rewind log-based capture to the beginning of currently active oldest transaction | Only supported on:
|
| Online refresh using accurate LSN/SCN | Supported on all location types where Log-based capture (capture from DBMS logging system) is supported, except for:
|
| 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:
|
| Multiple log-based capture jobs can capture from same database | Only supported on:
|
| Capture from tables with basic compression | Supported on all location types where Log-based capture (capture from DBMS logging system) is supported, except for:
|
| Capture from tables with advanced compression | Only supported on:
|
| Capture from tables with BLOB compression | Only supported on:
|
| Capture from tables with advanced index compression | Only supported on:
|
| Capture from tables with advanced row compression | Only supported on:
|
| Capture from tables with hybrid columnar compression | Only supported on:
|
| Log-based capture checkpointing using location property Capture_Checkpoint_Frequency | Only supported on:
|
| Read archives from an alternative directory (location property Archive_Log_Path on the capture location) | Only supported on:
|
| Trigger-based capture (using the location property Capture_Method=DB_TRIGGER at the capture location). This method has been deprecated since 6.2.0/0. | Only supported on:
|
| Location property Trigger_Quick_Toggle on the capture location | Only supported on: |
| Boundaries between transactions preserved by trigger-based capture | Only supported on:
|
| Trigger-based capture jobs can be woken by db-event when change happens | Only supported on:
|
Repository Database
This section lists the capabilities related to Repository Database.
| Capability | Support Status |
|---|---|
| Repository database | Only supported on:
|
Integrate
This section lists the capabilities related to Integrate.
| Capability | Support Status |
|---|---|
| Integrate changes into location | Only supported on:
|
| Burst integration (Integrate with parameter Method=BURST) | Supported on all location types, except for:
|
| Integrate with parameter BurstCommitFrequency | Supported on all location types, except for:
|
| Continuous integration (Integrate with parameter Method=CONTINUOUS) | Supported on all location types, except for: |
| Tables without a key and without TableProperties with NoDuplicateRows for continuous integration | Supported on all location types, except for:
|
| Continuous integrate with parameter OnErrorSaveFailed | Supported on all location types where Integrate changes into location is supported, except for:
|
| Disable/enable database triggers during integrate (with parameter NoTriggerFiring) | Only supported on:
|
| ColumnProperties with parameter SoftDelete | Supported on all location types, except for: |
| Bulk load requires a staging area (location property Staging_Directory) | Only supported on:
|
| Creation and update of HVR state tables | Supported on all location types, except for:
|
| Integrate with parameter DbProc | Only supported on:
|
Bi-directional Replication
This section lists the capabilities related to Bi-directional Replication.
| Capability | Support Status |
|---|---|
| Detection of changes made by HVR in a bidirectional channel to prevent loop-back | Only supported on:
|
| CollisionDetect with Log-based Capture (without parameter TimestampColumn) | Only supported on: |
| CollisionDetect with Trigger-based Capture (with location property Capture_Method=DB_TRIGGER on the capture location and CollisionDetect without parameter TimestampColumn) | Supported on all location types where Trigger-based capture (using the location property Capture_Method=DB_TRIGGER at the capture location). This method has been deprecated since 6.2.0/0. is supported |
| CollisionDetect with parameter TimestampColumn | Supported on all location types, except for:
|
Refresh and Compare
This section lists the capabilities related to Refresh and Compare.
| 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 location types, except for:
|
| hvrrefresh into target location | Supported on all location types, except for: |
| Bulk load of multiple slices of same table can be done in parallel | Only supported on:
|
| Row-wise hvrrefresh into target location (option -g) | Supported on all location types, except for:
|
| Disable/enable foreign keys and secondary indices during hvrrefresh (option -F) | Only supported on: |
| Disable/enable constraints check during hvrrefresh | Only supported on:
|
| Disable/enable foreign keys from table to others during hvrrefresh (option -F) | Only supported on:
|
| 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: |
| Disable/enable triggers during hvrrefresh (option -f) | Only supported on:
|
| Identity columns | Only supported on:
|
| Replicate database sequences (using action DbSequence) | Only supported on: |
| Suggestions in the UI for Slice Boundaries using DBMS statistics (hvrrefresh option -S) | Only supported on:
|
| Select data from each table from same consistent moment in time (hvrrefresh options -Mnow, -Mscn=val, -Mhvr_tx_seq=val, -Mtime) | Only supported on:
|
| Select data with 'snapshot' SQL isolation level (hvrrefresh option -Msnapshot) | Only supported on:
|
Other Capabilities
This section lists the capabilities related to Other Capabilities.