Articles in this section

Get started with Azure Synapse Analytics

  • Updated
Follow

etlworks.com_-_Get_started_banners__12_.png

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

Any to Synapse Analytics:

  • Database to Synapse Analytics
  • File to Synapse Analytics
  • Queue to Synapse Analytics
  • Web service to Synapse Analytics
  • Well-known API to Synapse Analytics
 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.

 

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.

Read more

Reverse ETL with Azure Synapse Analytics as a relational database

You can use any Database to... Flow type to extract data from Synapse Analytics, transform and load it into any destination.

Read more

Connect to Azure Synapse Analytics

To create a Connection to an Azure Synapse Analytics database, open the Connections window and type in synapse.

Read more

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.

Read more

Setup incremental replication using High Watermark (HWM)

Using HWM replication you can load only new and updated records into Synapse Analytics.

Read more

 

 

 

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.

mceclip0.png

Step 3. Select Azure Synapse Analytics Connection and continue by defining the Connection parameters.

Read more about configuring Synapse Analytics Connection.

Related articles

Comments

0 comments

Please sign in to leave a comment.