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.