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.
Comments
0 comments
Please sign in to leave a comment.