Capabilities for Aurora PostgreSQL

This section lists the Capabilities of Fivetran HVR when using 'Aurora PostgreSQL'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Aurora PostgreSQL Requirements.

Capture

HVR supports the following capabilities on Aurora PostgreSQL:

• Capture changes from location (Aurora PostgreSQL from version 11 to version 16).
• Log-based capture (capture from DBMS logging system) (Aurora PostgreSQL from version 11 to version 16).
• Log-based capture of tables without a primary key (Aurora PostgreSQL from version 11 to version 16).
• Access to logs using SQL interface (Aurora PostgreSQL from version 11 to version 16).
• Log-based capture of tables with LOB column (Aurora PostgreSQL from version 11 to version 16).
• Log-based capture of truncate table statements (Aurora PostgreSQL from version 11 to version 16).
• Multiple log-based capture jobs can capture from same database (Aurora PostgreSQL from version 11 to version 16).
• Log-based capture checkpointing using location property Capture_Checkpoint_Frequency (Aurora PostgreSQL from version 11 to version 16).

HVR does not support the following capabilities on Aurora PostgreSQL:

• Capture from Archive log files only.
• Direct access to logs on a file system.
• Log-based capture from hidden rowid/RRN column (ColumnProperties with parameter CaptureFromRowId).
• Rewind log-based capture to specific time (hvractivate option -i).
• Online refresh using accurate LSN/SCN.
• Populates column hvr_cap_user for use in ColumnProperties {hvr_cap_user} substitutions.
• Capture from tables with basic compression.
• Read archives from an alternative directory (location property Archive_Log_Path on the capture location).
• Trigger-based capture (location property Capture_Method=DB_TRIGGER on the capture location).

Repository Database

HVR supports Repository database on Aurora PostgreSQL.

Integrate

HVR supports the following capabilities on Aurora PostgreSQL:

• Integrate changes into location (Aurora PostgreSQL from version 11 to version 16).
• Burst integration (Integrate with parameter Method=BURST) (Aurora PostgreSQL from version 11 to version 16).
• Integrate with parameter BurstCommitFrequency (Aurora PostgreSQL from version 11 to version 16).
• Continuous integration (Integrate with parameter Method=CONTINUOUS) (Aurora PostgreSQL from version 11 to version 16).
• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration (Aurora PostgreSQL from version 11 to version 16).
• Continuous integrate with parameter OnErrorSaveFailed (Aurora PostgreSQL from version 11 to version 16).
• ColumnProperties with parameter SoftDelete (Aurora PostgreSQL from version 11 to version 16).
• Creation and update of HVR state tables (Aurora PostgreSQL from version 11 to version 16).

HVR does not support the following capabilities on Aurora PostgreSQL:

• Disable/enable database triggers during integrate (with parameter NoTriggerFiring).
• Integrate with parameter DbProc.

Bi-directional Replication

HVR supports the following capabilities on Aurora PostgreSQL:

• Detection of changes made by HVR in a bidirectional channel to prevent loop-back (Aurora PostgreSQL from version 11 to version 16, state table needs to be created before replication starts).
• CollisionDetect with parameter TimestampColumn (Aurora PostgreSQL from version 11 to version 16).

HVR does not support the following capabilities on Aurora PostgreSQL:

• CollisionDetect with Log-based Capture (without parameter TimestampColumn).

Refresh and Compare

HVR supports the following capabilities on Aurora PostgreSQL:

• hvrrefresh or hvrcompare from source location (Aurora PostgreSQL from version 11 to version 16).
• hvrrefresh into target location (Aurora PostgreSQL from version 11 to version 16).
• Isolated table hvrrefresh (option -i) into target location (Aurora PostgreSQL from version 11 to version 16).
• Row-wise hvrrefresh into target location (option -g) (Aurora PostgreSQL from version 11 to version 16).

Other Capabilities

HVR supports the following capabilities on Aurora PostgreSQL:

• Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc) (Aurora PostgreSQL from version 11 to version 16).
• International table and column names where DBMS is not configured with UTF-8 encoding (Aurora PostgreSQL from version 11 to version 16).
• 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) (Aurora PostgreSQL from version 11 to version 16).
• Always treat DBMS schema names case sensitive (Aurora PostgreSQL from version 11 to version 16).

HVR does not support the following capabilities on Aurora PostgreSQL:

• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey).
• 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..
• Distinguish and support capture from 'materialized views'.