Onboarding Data from IBM Cloud SQL Query

Creating an IBM Cloud SQL Query Source

For creating an IBM Cloud SQL Query source, see $link[page,312601,auto$]. Ensure that the Source Type selected is IBM Cloud SQL Query.

To enable OAuth for IBM Cloud SQL Query, see $link[page,312601,Enabling OAuth for CDATA Drivers,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 parameter:

IBM Cloud SQL Query Configurations

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

Configuring an IBM Cloud SQL Query Table

For configuring an IBM Cloud SQL Query table, see $link[page,312601,Configuring a Table,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.