Onboarding Data from Azure Synapse

For creating an Azure Synapse source, see Configuring Additional Connectors. Ensure that the Source Type selected is Azure Synapse.

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:

OAuth Parameter	Description
OAuthSettingsLocation	Saves the authentication values to be persisted across connections. The user must register an init script on the jobs cluster to propagate the OAuthSettingsLocation file across all the worker nodes.

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

OAuth Parameter	Description
OAuthClientId	Set this to the Client Id in your app settings.
OAuthClientSecret	Set this to the Client Secret in your app settings.
CallbackURL	Set this to the Redirect URL in your app settings.
AuthScheme	Set this to the "AzureAD" in your app settings.

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

OAuth Parameter	Description
OAuthJWTCert	Set this to the JWT Certificate store.
OAuthJWTCertType	Set this to the type of the certificate store specified by OAuthJWTCert.

Field	Description
Fetch Data Using	The mechanism through which Infoworks fetches data from the database.
Connection URL	The connection URL through which Infoworks connects to the database.
Username	The username for the connection to the database.
Password	The password for the username provided.
Source Schema	The schema in the database to be crawled. The schema value is case sensitive.

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

For configuring an Azure Synapse Table, see Configuring a Table.

To create a JDBC URL, see Establishing a Connection.

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

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

Last updated on Sep 28, 2021

Was this page helpful?