Connectors
Databases
Azure Synapse
3min
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 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) documentation and setup basic sql server setup azure synapse setup docid\ kccpijcazyetp0yra1bwh change log (see change log) 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