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. |
Bulk load files in Synapse Analytics If you already have CSV or Parquet files in Azure Storage and don't need to transform the data, the most efficient way to load these files into the Synapse Analytics is to use the flow type Bulk load files into Synapse Analytics
|
|
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.