Overview
Azure Synapse Analytics is an analytics service that brings together enterprise data warehousing and big data analytics. Read more about Azure Synapse Analytics. Etlworks includes several pre-built Flows optimized for Synapse Analytics.
Flows optimized for Synapse Analytics
| Flow type | When to use |
|
When you need to extract data from any source, transform it and load it into Synapse Analytics. |
| Bulk load files in Azure Blob into Synapse Analytics | When you need to bulk-load files that already exist in Azure Blob without applying any transformations. The flow automatically generates the COPY command and MERGEs data into the destination. |
| Stream CDC events into Synapse Analytics | When you need to stream updates from the database which supports Change Data Capture (CDC) into Synapse Analytics in real-time. |
| Stream messages from a queue into Synapse Analytics | When you need to stream messages from the message queue which supports streaming into Synapse Analytics in real time. |
Videos
|
ETL and CDC data into Synapse Analytics Watch how to create flows to ETL and CDC data into Synapse Analytics |
Related resources
|
ELT with Azure Synapse Analytics Etlworks supports executing complex ELT scripts directly in Azure Synapse Analytics which greatly improves the performance and reliability of the data ingestion. |
Reverse ETL with Azure Synapse Analytics as a relational database You can use any |
|
Connect to Azure Synapse Analytics To create a Connection to an Azure Synapse Analytics database, open the |
Load multiple tables by a wildcard name You can ETL data from multiple database objects (tables and views) into Synapse Analytics by a wildcard name without creating individual source-to-destination transformations. |
|
Setup incremental replication using High Watermark (HWM) Using HWM replication you can load only new and updated records into Synapse Analytics.
|
|
Related case studies
|
Real-time CDC and batch ETL data from MySQL, Postgres, Oracle, APIs, and file-based sources. |
Tallink, a leading provider of passenger and cargo transport services in the Baltic Sea region, needed a solution to integrate data from various sources into multiple destinations, including MySQL, Postgres, Oracle databases, files, and APIs. With Etlworks, they achieved real-time Change Data Capture (CDC) and robust data recovery through batch ETL, enabling reliable, high-performance data flows. |
|
Cloud migrations from databases and file-based sources to Azure.
|
BioUrja Group, a global leader in energy and agricultural commodities, turned to Etlworks for their cloud migration needs. By integrating data from multiple databases and file sources into cloud-based destinations, Etlworks enabled BioUrja to migrate billions of records from proof of concept (PoC) to production in just a few weeks. With unmatched support and flexibility, Etlworks delivered the perfect mix of features and value to meet BioUrja’s tight timeline and budget constraints. |
Connect to Azure Synapse Analytics
Here are the steps to connect to Azure Synapse Analytics:
Step 1. Open the Connections window and click +.
Step 2. Type synapse into the search field.
Step 3. Select Azure Synapse Analytics Connection and continue by defining the Connection parameters.
Read more about configuring Synapse Analytics Connection.
Comments
0 comments
Please sign in to leave a comment.