Onboarding Data from JSON

Creating a JSON Source

For creating a JSON source, see Configuring Additional Connectors. Ensure that the Source Type selected is JSON.

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:

OAuth Parameter

Description

OAuthVersion

Set this to the OAuth Version, either 1.0 or 2.0.

OAuthRequestTokenURL

Required for OAuth 1.0. In OAuth 1.0 this is the URL where the app makes a request for the request token.

OAuthAuthorizationURL

Required for OAuth 1.0 and 2.0. This is the URL where the user logs into the service and grants permissions to the application. In OAuth 1.0 if permissions are granted the request token is authorized.

OAuthAccessTokenURL

Required for OAuth 1.0 and 2.0. This is the URL where the request for the access token is made. In OAuth 1.0 the authorized request token is exchanged for the access token.

OAuthRefreshTokenURL

Required for OAuth 2.0. In OAuth 2.0 this is the URL where the refresh token is exchanged for a new access token when the old one expires. Note that for your data source this may be the same as the access token URL.

OAuthClientId

Set this to the client Id in your app settings. This is also called the consumer key.

OAuthClientSecret

Set this to the client secret in your app settings. This is also called the consumer secret.

CallbackURL

Set this to http://localhost:33333. If you specified a redirect URL in your app settings, this must match.

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.

JSON 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 a JSON Table

For configuring a JSON 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.