Onboarding Data from Azure Synapse

For creating an Azure Synapse source, see $link[page,255907,auto$]. Ensure that the Source Type selected is Azure Synapse.

To enable OAuth, see Enabling OAuth for CDATA Drivers.

Embedded OAuth Parameter Settings

You can connect to the CDATA driver without setting any connection properties for your user credentials.

Set the following embedded OAuth parameters:

Custom OAuth Parameter Settings

Set the following parameters to authenticate using the client secret of a Custom OAuth app:

Set the following parameters to authenticate using the certificate of a Custom OAuth app:

Azure Synapse Configurations

Once the settings are saved, you can test the connection.

Configuring an Azure Synapse Table

For configuring an Azure Synapse Table, see $link[page,255922].

Establishing a Connection

To create a JDBC URL, see Establishing a Connection.

Data Model

The tables and views supported by the source are described in the Data Model.

JDBC Connection Parameters

For the list of JDBC connection parameters, see Connection Parameters.