Onboarding Data from Google Ads Manager (DoubleClickFP)

Creating an Google Ads Manager Source

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

To enable OAuth for Google Ads Manager, 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

NetworkCode

Set the NetworkCode connection property to the network code displayed in the URL when you are logged into your network.

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.

Google Ads Manager 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 Google Ads Manager Table

For configuring a Google Ads Manager table, see Configuring a Table.

Establishing a Connection

To create a JDBC URL, see Establishing a Connection.

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.