v7

Configure access to Google BigQuery

Use Adobe Campaign Classic Federated Data Access (FDA) option to process information stored in an external database. Follow the steps below to configure access to Google BigQuery.

1. Configure Google BigQuery on Windows or Linux
2. Configure the Google BigQuery external account in Adobe Campaign Classic
3. Set up Google BigQuery connector bulk load on Windows or Linux

Google BigQuery on Windows

Driver set up on Windows

1. Download the ODBC driver for Windows.

2. Configure the ODBC driver in Windows. For more on this, refer to this page.

3. For the Google BigQuery connector to work, Adobe Campaign Classic requires the following parameters to connect:

   • Project: create or use an existing project.

     For more information, refer to this page.

   • Service account: create a service account.

     For more information, refer to this page.

   • Key File Path: the Service account requires a Key File for a Google BigQuery connection through ODBC.

     For more information, refer to this page.

   • Dataset: Dataset is optional for an ODBC connection. Since every query needs to provide the dataset where the table is located, specifying a Dataset is mandatory for Google BigQuery FDA Connector in Adobe Campaign Classic.

     For more information, refer to this page.

4. In Adobe Campaign Classic, you can then configure your Google BigQuery external account. For more on how to configure your external account, refer to this section.

Bulk load set up on Windows

Bulk Load utility allows faster transfer, which is achieved through Google Cloud SDK.

1. Download Windows 64-bit (x86_64) archive from this page and extract it in the corresponding directory.

2. Run the google-cloud-sdk\install.sh script. You need to accept the setting of path variable.

3. After the installation, check that the path variable ...\google-cloud-sdk\bin is set. If not, add it manually.

4. In the ..\google-cloud-sdk\bin\bq.cmd file, add the CLOUDSDK_PYTHON local variable, which will redirect to the location of the Python installation.

   For example:

   

5. Restart Adobe Campaign Classic for the changes to be taken into account.

Google BigQuery on Linux

Driver set up on Linux

Before setting up the driver, note that script and commands must be ran by root user. It is also recommended to use Google DNS 8.8.8.8, while running the script.

To configure Google BigQuery on Linux, follow the steps below:

1. Before the ODBC installation, check that the following packages are installed on your Linux distribution:

   • For Red Hat/CentOS:

     yum update
     yum upgrade
     yum install -y grep sed tar wget perl curl
     

   • For Debian:

     apt-get update
     apt-get upgrade
     apt-get install -y grep sed tar wget perl curl
     

2. Update system before installation:

   • For Red Hat/CentOS:

     # install unixODBC driver manager
     yum install -y unixODBC
     

   • For Debian:

     # install unixODBC driver manager
     apt-get install -y odbcinst1debian2 libodbc1 odbcinst unixodbc
     

3. Before running the script, you can obtain more info by specifying --help argument:

   cd /usr/local/neolane/nl6/bin/fda-setup-scripts
   ./bigquery_odbc-setup.sh --help
   

4. Access the directory where the script is located and run the following script as root user:

   cd /usr/local/neolane/nl6/bin/fda-setup-scripts
   ./bigquery_odbc-setup.sh
   

Bulk load set up on Linux

Bulk Load utility allows faster transfer, which is achieved through Google Cloud SDK.

1. Before the ODBC installation, check that the following packages are installed on your Linux distribution:

   • For Red Hat/CentOS:

     yum update
     yum upgrade
     yum install -y python3
     

   • For Debian:

     apt-get update
     apt-get upgrade
     apt-get install -y python3
     

2. Access the directory where the script is located and run the following script:

   cd /usr/local/neolane/nl6/bin/fda-setup-scripts
   ./bigquery_sdk-setup.sh
   

Google BigQuery external account

You need to create a Google BigQuery external account to connect your Adobe Campaign Classic instance to your Google BigQuery external database.

1. From Adobe Campaign Classic Explorer, click Administration ‘>’ Platform ‘>’ External accounts.

2. Click New.

3. Select External database as your external account’s Type.

4. Configure the Google BigQuery external account, you must specify:

   • Type: Google BigQuery

   • Service account: Email of your Service account. For more information on this, refer to Google Cloud documentation.

   • Project: Name of your Project. For more information on this, refer to Google Cloud documentation.

   • Key file Path:

     • Upload key file to the server: select Click here to upload if you choose to upload the key through Adobe Campaign Classic.

     • Enter manually the key file path: copy/paste your absolute path in this the field if you choose to use a pre-existing key.

   • Dataset: Name of your Dataset. For more information on this, refer to Google Cloud documentation.

   

The connector supports the following options:

Business.Adobe.com resources