Extract data from Synapse Analytics
You can use any
Database to Flow type to extract data from Synapse Analytics.
Load data into Synapse Analytics
Synapse Analytics is built on top of the SQL Server database engine. Therefore, you can use the same techniques you would normally use to work with relational databases in the 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.