Onboarding Data from REST API

Creating a REST API Source

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

To enable OAuth for REST API, see Enabling OAuth for CDATA Drivers. and CData JDBC Driver for REST - Using OAuth.

REST API 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 REST API Table

For configuring a REST API table, see Configuring a Table.

Establishing a Connection

To create a JDBC URL, see Establishing a Connection.

JDBC Connection Parameters

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