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.
What can you do with Azure Synapse Analytics in Etlworks Integrator
Load data into Synapse Analytics Set the Flow type and source-to-destination transformations parameters |
Load multiple tables by a wildcard name You can load multiple database objects (tables and views) by a wildcard name (without creating individual source-to-destination transformations) |
Setup change replication using change data capture (CDC) Once the CDC is configured for the source database, you can create a CDC pipeline where the source is one of these databases and the destination is Synapse Analytics. |
Setup Change Replication using high watermark As in any other Flow type, it is possible to configure a change replication using a high watermark. |
Related resources
Extract, transform and load data in Azure Synapse Analytics Using Synapse Analytics-optimized Flows, you can extract data from any supported sources and load it directly into Synapse Analytics. |
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. |
Work 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 |
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.