Using an Azure Synapse Analytics JDBC connection, Connect can read supported Azure Synapse Analytics data types from any Azure Synapse Analytics table.
Defining Azure Synapse Analytics sources
For all Connect for Big Data ETL jobs, Connect for Big Data supports Azure Synapse Analytics database tables as sources and as lookup sources. At the Source Database Table dialog or at the Lookup Source Database Table dialog define either an Azure Synapse Analytics database table source or lookup source respectively:
- At Connection, select a previously defined Azure SQL Data Warehouse source connection or select Add new... to add a new connection.