Capabilities for SingleStore

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

Capture

HVR does not support Capture changes from location on SingleStore.

Repository Database

HVR does not support Repository database on SingleStore.

Integrate

HVR supports the following capabilities on SingleStore:

• Integrate changes into location (SingleStore from version 7.1 to version 8.7).
• Burst integration (Integrate with parameter Method=BURST) (SingleStore from version 7.1 to version 8.7).
• Integrate with parameter BurstCommitFrequency (SingleStore from version 7.1 to version 8.7).
• Continuous integration (Integrate with parameter Method=CONTINUOUS) (SingleStore from version 7.1 to version 8.7).
• Tables without a key and without TableProperties with NoDuplicateRows for continuous integration (SingleStore from version 7.1 to version 8.7).
• ColumnProperties with parameter SoftDelete (SingleStore from version 7.1 to version 8.7).
• Bulk load requires a staging area (location property Staging_Directory) (SingleStore from version 7.1 to version 8.7).
• Creation and update of HVR state tables (SingleStore from version 7.1 to version 8.7).

HVR does not support the following capabilities on SingleStore:

• Append integration into TimeKey (Integrate with parameter Method=APPEND).
• Continuous integrate with parameter OnErrorSaveFailed.
• Disable/enable database triggers during integrate (with parameter NoTriggerFiring).
• Integrate with parameter DbProc.

Bi-directional Replication

HVR does not support Bi-directional Replication on SingleStore.

Refresh and Compare

HVR supports the following capabilities on SingleStore:

• hvrrefresh or hvrcompare from source location (SingleStore from version 7.1 to version 8.7).
• hvrrefresh into target location (SingleStore from version 7.1 to version 8.7).
• Isolated table hvrrefresh (option -i) into target location (SingleStore from version 7.1 to version 8.7).
• Row-wise hvrrefresh into target location (option -g) (SingleStore from version 7.1 to version 8.7).

Other Capabilities

HVR supports the following capabilities on SingleStore:

• Both row store and column store tables can be created (SingleStore from version 7.1 to version 8.7).
• Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey) (SingleStore from version 7.1 to version 8.7).
• Call database procedure dbproc during replication jobs (AgentPlugin with parameter DbProc) (SingleStore from version 7.1 to version 8.7).
• International table and column names where DBMS is not configured with UTF-8 encoding (SingleStore from version 7.1 to version 8.7).
• 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) (SingleStore from version 7.1 to version 8.7).
• Always treat DBMS schema names case sensitive (SingleStore from version 7.1 to version 8.7).