Capabilities for SingleStore

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

Capture

DSS does not support Capture changes from location on SingleStore.

Repository Database

DSS does not support Repository database on SingleStore.

Integrate

DSS supports the following capabilities on SingleStore:

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

DSS 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

DSS does not support Bi-directional Replication on SingleStore.

Refresh and Compare

DSS supports the following capabilities on SingleStore:

• dssrefresh or dsscompare from source location (SingleStore version 7.1).
• dssrefresh into target location (SingleStore version 7.1).
• Isolated table dssrefresh (option -i) into target location (SingleStore version 7.1).
• Row-wise dssrefresh into target location (option -g) (SingleStore version 7.1).

Other Capabilities

DSS supports the following capabilities on SingleStore:

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

DSS does not support the following capabilities on SingleStore:

• 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..