Azure Synapse
DLH.io documentation for Azure Synapse
Previously SQL Data Warehouse (SQL DW), Azure Synapspe is the petabyte scale analytical compute warehousing solution from Microsoft. Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems by separating compute from storage. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Data Explorer for log and time series analytics, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.
DLH.io synchronizes data to Synapse from 100+ connectors and integrations better than other platforms because we're experts in Azure and SQL Server technology.
Setup Instructions
Follow the setup steps guide for configuring your Azure Synapse connection to enable data to flow into your destination via DLH.
Supported Features
Here are key features supported for this connector.
| Sync Feature | Supported | Details |
|---|---|---|
| Custom Data and Development | ✓ | Ability to enhance connector upon request |
| Historical Re-Load/Load | ✓ | |
| Incremental/Delta Load | ✓ | Gets most recent records and changes |
| Column Selection | ✓ | |
| Column Hashing | ✓ | |
| Re-Sync Table/Entity | ✓ | Select at the table level to reload data history (on next Sync Bridge run) |
| Custom Queries | Utilizing SQL Data Query Connector | |
| Custom Data | ||
| Captures Deleted Rows | ✓ | On all supported tables |
| API Sync Bridge Initiation | ✓ | |
| Priority Scheduling | ✓ | |
| Private VPC/Link | ☂ | |
| DLH Data Model Available | - |
If you have any questions about these supported features please reach out to our Customer Support team.
Details on Sync Processing
For this connector, we believe the sync processing is straightforward. We've provided a number of details, steps, and other guidance here and in the setup steps guide. Be sure to also check the change log and notes page from time to time for any changes.
Supported Configurations
Currently DLH.io does not support loading of data/events into Azure Synapse Serverless. As of 2022 the main reason for this continues to be that the base storage foundation of Azure Synapse is Azure Blob and/or Azure Data Lake storage. Azure Synapse Serverless simply reads from the storage blob directly. The other magic behind DLH.io for loading data is for handling CDC, etc. Because Synapse Serverless requires the dynamic table or view concept over the storage layer, even though DLH.io could do this, the use case for Synapse is to use a dedicated SQL pool (previously known as a SQL Data Warehouse).
Data Transfer Information
Currently DLH.io supports CSV loading to your Azure Synapse target. Parquet and AVRO are potentially supported (please contact support for more information, if required).
Azure Synapse does not costs extra when loading data from DLH.io, meaning that Azure does not charge your account any additional amount for using DLH.io just because it is more efficient and a better option than native Microsoft Azure integration concepts.