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
|
ETL data into Synapse Analytics Using Synapse-optimized Flows, you can extract data from any of the supported sources and load it into Synapse Analytics. |
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 change replication using change data capture (CDC) Change Data Capture (CDC) pipeline allows extracting changes in real-time from the databases which support CDC and loading them into Synapse Analytics. |
Setup incremental replication using High Watermark (HWM) Using HWM replication you can load only new and updated records into Synapse Analytics. |
|
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 Synapse Analytics is to use the flow type Bulk load files 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. |
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.