Onboarding Data from Bing Ads
Creating a Bing Ads Source
For creating a Bing Ads source, see Configuring Additional Connectors. Ensure that the Source Type selected is Bing Ads.
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 |
|---|---|
| DeveloperToken | Set this to the token you generated in the Bing Ads Developer Portal. BBD37VB98 may be used for sandbox accounts. |
| AccountId | Set this to the account Id value found in the Bing Ads Web application, under Settings -> Accounts and Billing -> Your Account -> Account. |
| CustomerId | Set this to the customer Id value found in the Bing Ads Web application, under Settings -> Accounts and Billing -> Your Account -> Customer. |
| 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. |
Bing Ads 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 Bing Ads Table
For configuring a Bing Ads 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.
Was this page helpful?