Capabilities for Aurora PostgreSQL

From HVR
Jump to: navigation, search

This section describes the capabilities supported by HVR on Aurora PostgreSQL.

Capture

HVR does not support Capture changes from location (Aurora PostgreSQL since HVR 5.3.1/25)


HVR Hub

HVR supports Hub database (Aurora PostgreSQL since HVR 5.3.1/25)


Integrate

HVR supports the following capabilities on Aurora PostgreSQL:

  • Integrate changes into location (Aurora PostgreSQL since HVR 5.3.1/25)
  • Integrate with /Burst
  • Integrate with /BurstCommitFrequency
  • Continuous integration (Integrate without /Burst)
  • Action TableProperties with /DuplicateRows for continuous integration
  • Continuous integrate with /OnErrorSaveFailed (without /Burst)
  • Action Transform /SoftDelete
  • Creation and update of HVR state tables


HVR does not support the following capabilities on Aurora PostgreSQL:

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


Bi-directional Replication

HVR does not support Bi-directional Replication on Aurora PostgreSQL


Refresh and Compare

HVR supports the following capabilities on Aurora PostgreSQL:

  • Refresh or Compare from source location (Aurora PostgreSQL since HVR 5.3.1/25)
  • Refresh into target location
  • Row-wise refresh into target location (option -g)
  • 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)


Other Capabilities

HVR supports the following capabilities on Aurora PostgreSQL:

  • Treat DBMS table names and columns case sensitive (action LocationProperties /CaseSensitiveNames) (Aurora PostgreSQL since HVR 5.3.1/25)


HVR does not support the following capabilities on Aurora PostgreSQL:

  • Use distribution key for parallelizing changes within a table (ColumnProperties /DistributionKey)
  • International table and column names where DBMS is not configured with UTF-8 encoding