Overview
Azure Synapse Analytics is a limitless analytics service that brings together enterprise data warehousing and big data analytics. Read more about Azure Synapse Analytics. The Etlworks Integrator 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 The Etlworks Integrator 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.
|
|
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.