Configuring Adobe Campaign Classic V7 to access Google BigQuery

Last update: Wed Jan 22 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

This article provides a solution to address the integration of Adobe Campaign Classic (ACC) with Google Cloud Platform’s (GCP) BigQuery. It outlines the necessary permissions for the service account and the configuration steps to ensure temporary objects are created in the Microsoft SQL Server application database.

Description

Environment

Adobe Campaign Classic V7

Issue/Symptoms

When integrating Adobe Campaign Classic (ACC) with Google Cloud Platform’s (GCP) BigQuery, specific permissions are required for the service account associated with ACC. Additionally, there is a need to configure where temporary objects are created during workflow execution. By default, these objects may be created in GCP BigQuery instead of the intended Microsoft SQL Server application database.

Symptoms include:

ACC service account lacking necessary permissions to interact with BigQuery.
Temporary objects being created in BigQuery instead of the Microsoft SQL Server application database.

Resolution

Granting specific GCP BigQuery privileges to the service account: The service account used by ACC must have certain roles assigned to interact effectively with BigQuery. Steps to assign these roles:
1. Navigate to IAM & Admin in the GCP Console.
2. Locate the service account utilized by ACC.
3. Assign both BigQuery Data Viewer and BigQuery Job User roles for relevant datasets.
  - BigQuery Data Viewer: Grants read access to datasets and tables.
  - BigQuery Job User: Allows running queries and creating necessary temporary tables.
Configuring temporary object creation in Adobe Campaign Classic:
- To direct temporary object creation within your Microsoft SQL Server application database rather than in BigQuery:
  - External Account Configuration:
    1. In ACC, navigate through Administration > Platform > External accounts.
    2. Select the external account configured for connecting with BigQuery.
    3. Ensure that settings enable using the application database for storing temporary data.
  - Workflow Configuration:
    1. Open any relevant workflow within ACC.
    2. Go into Workflow Properties, then proceed to Advanced Settings.
    3. Confirm that configurations direct all temporary data storage towards your SQL Server-based application database.

By implementing these steps, you will provide your Adobe Campaign instance with the appropriate permissions needed for accessing Google Cloud’s resources while ensuring consistent management of workflow-related data within your existing infrastructure setup on Microsoft SQL Server databases—thereby optimizing performance outcomes as well!

recommendation-more-help