Azure Synapse Analytics comes with tabular data stream (TDS) endpoint for SQL on-Demand, meaning you can run SQL queries as if you were talking to any SQL Server or Azure SQL Database. It's therefore possible to use a standard Copy Activity in the same way as you would were you to copy data from a Azure SQL Database. The TDS endpoint can be found on the workspace overview tab of your Synapse workspace and is in the format <workspace-name>-ondemand.sql.azuresynapse.net. Note that you will be constrained by the language features available with SQL on-Demand. In the future, it is likely that there will be tighter workspace integration along with stored procedure support. This means that you will be able to take advantage of SQL on-Demand features such as CETAS.