Onboarding Data from Azure Management
Creating an Azure Management Source
For creating an Azure Management source, see Configuring Additional Connectors. Ensure that the Source Type selected is Azure Management.
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:
| Field | Description |
|---|---|
| SubscriptionId (optional) | A subscription Id is required for Azure API Management endpoints, so if you do not specify, the driver gets the first subscription Id available in your account. |
| Tenant (optional) | To authenticate to a different tenant than your default. This is required to work with a Subscription not on your default Tenant. |
| 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. |
Custom OAuth Parameter Settings
Set the following parameters to authenticate with the credentials for a Custom OAuth app:
| Field | Description |
|---|---|
| OAuthClientId | Set this to the client Id assigned when you registered your app. |
| OAuthClientSecret | Set this to the client secret assigned when you registered your app. |
| CallbackURL | Set this to the redirect URI defined when you registered your app. |
Azure Management Configurations
| 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.
Configuring an Azure Management Table
For configuring an Azure Management Table, see Configuring a Table.
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.