Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In Treasure Data, you must create and configure the data connection, to be used during export, prior to running your query. As part of the data connection, you provide authentication to access the integration.

  1. Open the TD Console.

  2. Navigate to the Integrations Hub >  Catalog.Search for and select Dotdigital.> Catalog.

  3. Click the search icon on the far-right of the Catalog screen, and enter dotdigital.
  4. Hover over the dotdigital connector and select Create Authentication.Image Added
  5. The New Authentication dialog opens.

    Image Modified
  6. Select your Region. The API User Name and API User Password fields auto-populate.

  7. Select Continue.

  8. Enter a name for your connection.

  9. Select Done. 

...

Type the required credentials for your new dotdigital connection. Set the following parameters.

Parameter

Requirement

Description

Export Mode

Required

There are two different ways to move data:

  • Transactional Email (default). Trigger send emails for the triggered campaign in Dotdigital: send one email for each record.

  • Bulk Contacts: Upload records as contacts to Dotdigital.

Campaign ID

Required

The ID of the triggered campaign.

JSON Personalization Columns

Optional

The JSON columns names, separated by commas.

Ignore Invalid Records

Optional

Ignore invalid records and complete the job.

Address Book ID

Required

Address book ID to add contacts.

Add to Address Book

Optional

Add to address book.

Merge Option

Optional

The following merge options are available:

  • None (default). Do not merge.

  • Update All. Update all data fields - update_all

  • Ignore Blank. Ignores the blank values in query result set - ignore_blank

  • Skip Existing Non-Empty Fields. Do not update data fields that contain values - skip_fields


Sample Configuration

Example of a Query to Populate Dotdigital

...