Capabilities for Azure Synapse Analytics - DSS 6 | Data Source Solutions Documentation
Documentation: Capabilities for Azure Synapse Analytics - DSS 6 | Data Source Solutions Documentation
Capabilities for Azure Synapse Analytics
This section lists the Capabilities of Data Source Solutions DSS when using 'Azure Synapse Analytics'. For more information about the pre-requisites, access privileges, and other configuration requirements, see Azure Synapse Analytics Requirements.
Capture
DSS does not support Capture changes from location on Azure Synapse Analytics.
Repository Database
DSS does not support Repository database on Azure Synapse Analytics.
Integrate
DSS supports the following capabilities on Azure Synapse Analytics:
- Integrate changes into location.
- Burst integration (Integrate with parameter Method=BURST).
- Integrate with parameter BurstCommitFrequency.
- Continuous integration (Integrate with parameter Method=CONTINUOUS).
- ColumnProperties with parameter SoftDelete.
- Creation and update of DSS state tables.
DSS does not support the following capabilities on Azure Synapse Analytics:
- Append integration into TimeKey (Integrate with parameter Method=APPEND).
- Tables without a key and without TableProperties with NoDuplicateRows for continuous integration.
- 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 Azure Synapse Analytics.
Refresh and Compare
DSS supports the following capabilities on Azure Synapse Analytics:
- dssrefresh or dsscompare from source location.
- dssrefresh into target location.
- Isolated table dssrefresh (option -i) into target location.
- Row-wise dssrefresh into target location (option -g).
DSS does not support the following capabilities on Azure Synapse Analytics:
- Bulk load of multiple slices of same table can be done in parallel.
Other Capabilities
DSS supports the following capabilities on Azure Synapse Analytics:
- Use distribution key for parallelizing changes within a table (ColumnProperties with parameter DistributionKey).
- International table and column names where DBMS is not configured with UTF-8 encoding.
- 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) .
- Always treat DBMS schema names case sensitive.