Working with Azure Synapse Analytics as a relational database

Extracting data from Synapse Analytics

You can use any "database to..." flow type to extract data from Synapse Analytics.

Loading data into Synapse Analytics

Synapse Analytics is built on top of SQL Server database engine. Therefore, you can use the same techniques you would normally use to work with relational databases in Etlworks Integrator. It is, however, important to understand that inserting data into Synapse Analytics row by row can be painfully slow.

So, it is recommended that you use set operations, such as insert into select from, or flows optimized for loading data into Synapse Analytics.