Doubleclick Campaign Manager 

Doubleclick Campaign Manager is a web-based ad management system for advertisers and agencies.

Doubleclick Campaign Manager integration replicates data using the Campaign Manager 360 API.

Feature snapshot

A high-level look at this connector, including useful links, and supported features.

Feature/Capability	Support details
Supported Qlik Talend Data Integration projects	Replication projects only. Data pipeline projects are not supported.
Target update methods	Replication tasks: Apply changes Store changes Landing data in a data lake tasks: Change data capture (CDC)
Managing metadata	Manual metadata generation is not required.
Schema evolution	Only the Change column data type operation is supported.
Replication of LOB columns (NCLOB, CLOB, and BLOB)	Not supported.
Scheduled CDC	Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling tasks For lake landing tasks, see Scheduling CDC for lake landing tasks
Notifications	Partially supported Setting notifications for changes in operation
Monitoring	CDC-only, as full load is not relevant for this connector. Monitoring an individual data task
Automatic denesting of JSON column payloads	Not supported. JSON column payloads in source datasets are not denested automatically on the target.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Before you set up the connection, ensure the following requirements are met:

• You have an active Campaign Manager 360 account.
• API access is enabled for your Campaign Manager 360 account.
• Your Campaign Manager 360 user profile has the appropriate access permissions. They are set in the Campaign Manager 360 interface and determine what you can do through both the UI and the API.

To generate your client ID and secret:

1. Log into your Doubleclick Campaign Manager account.
2. Navigate to Credentials.
3. Click + Create Credentials, and select OAuth client ID.
4. From the Application type drop-down menu, select Web application.
5. Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm.
6. Click Create.
7. Copy and paste your client secret and client ID into a secured file.

   Make sure your client ID includes the Campaign Manager API scope. For more information, see Authorize Requests.

To locate your profile ID:

1. Log into your Doubleclick Campaign Manager account.
2. Click your profile icon in the upper-right corner.
3. Locate the ID of the profile you want to connect.

   It is a seven digit number next to the name of the profile. For example: 9999999.

Creating the connection

For more information, see Connecting to SaaS applications.

1. Click Authenticate when you have filled in the required connection settings.

   You may be asked to log in to the source application.

   A window is displayed with an authentication code.

2. Copy the code to the clipboard and return to the connection dialog.

3. Paste the code in Complete authentication with the code provided by the source and click Verify.

   Tip noteYou may need to scroll down to see this field.

   When status is Verified, the authentication is verified.

4. Provide a name for the connection in Connection name.

5. Select Open connection metadata to define metadata for the connection when it has been created.