Connect to Azure Synapse

What is Azure Synapse?

Azure Synapse is the next-generation unification of data pipelines and analytics workloads. Formerly known as SQL DW, Synapse brings massively scalable big data analytics into the data warehousing space. Specifically designed with a focus on machine learning applications, it enables fast preparation of data for ML models. It offers essentially limitless, on-demand, Massively Parallel Processing (MPP) capabilities, with compute resources scalable independently to storage. The four constituent parts of Azure Synapse are SQL Analytics, Spark, Data Integration and Studio.

Extract Data From Azure Synapse

Loome makes it simple to connect to Azure Synapse and extract data for downstream systems such as an Integration Hub, Reporting Data Store, Data Lake or Enterprise Data Warehouse. In-built features allow bulk selection of all source tables/files to be automatically synced on a regular schedule, minimising data load size leveraging incremental logic.

Load Data into Azure Synapse

Loome allows you to quickly onboard your data to the cloud and load your entire data source into Azure Synapse to support your Data Integration Hub, Reporting Data Store, Data Lake or Enterprise Data Warehouse.

Loome automatically generates target staging table structures, including automatic change detection to retain a full audit history of each version of a record received.

Data Quality Hub in Azure Synapse

Loome allows you to easily monitor Data Quality exceptions reinforcing Azure Synapse as your strategic Data Quality Hub.

Loome keeps an audit trail of resolved issues, and proactively manages data quality with a fully automated data quality engine generating audience targeted alerts in real-time.