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 | Supported on all location types where Log-based capture (capture from DBMS logging system) is supported, except for:
|
| 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:
|
| 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 | 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 (location property Capture_Method=DB_TRIGGER on the capture location) | 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 where Integrate changes into location is supported, except for:
|
| Integrate with parameter BurstCommitFrequency | Supported on all location types where Integrate changes into location is supported, except for:
|
| Continuous integration (Integrate with parameter Method=CONTINUOUS) | Supported on all location types where Integrate changes into location is supported |
| Tables without a key and without TableProperties with NoDuplicateRows for continuous integration | Supported on all location types where Integrate changes into location is supported, 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 where Integrate changes into location is supported |
| 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 where MinVersionRestrictions is supported, 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 (location property Capture_Method=DB_TRIGGER on the capture location) is supported |
| CollisionDetect with parameter TimestampColumn | Supported on all location types where Integrate changes into location is supported, 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 where hvrrefresh or hvrcompare from source location is supported, except for:
|
| hvrrefresh into target location | Supported on all location types where MinVersionRestrictions is supported, 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 where MinVersionRestrictions is supported, 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 GUI 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.
| Capability | Support Status |
|---|---|
| Both row store and column store tables can be created | Only supported on:
|
| Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey) | Only supported on:
|
| Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc) | Supported on all location types where Integrate changes into location is supported, except for:
|
| DbObjectGeneration with parameter IncludeSQLFile | Only supported on:
|
| International table and column names where DBMS is not configured with UTF-8 encoding | Supported on all location types where MinVersionRestrictions is supported |
| 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. | Only supported on:
|
| Treat DBMS table names and columns as case sensitive if configured (location property Case_Sensitive_Names) | Only supported on:
|
| Always treat DBMS table names and column names as case sensitive, even if not configured (equivalent to location property Case_Sensitive_Names always set to TRUE) | Only supported on:
|
| Always treat DBMS schema names case sensitive | Only supported on:
|
| Reduce width of datatype when selecting or capturing changes (ColumnProperties with parameter TrimDatatype) | Only supported on:
|
| 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:
|