Versions Compared

Key

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

You can import Salesforce Marketing Cloud (beta) Data Source objects into Treasure Data using this data connector.

...

To see sample workflows for importing Salesforce Marketing Cloud data, go to Treasure Boxes.

...

.

Table of Contents

Prerequisites

  • Basic knowledge of Treasure Data

  • Basic knowledge of Salesforce Marketing Cloud

Limitation

Occasionally, data imported using this integration experiences data inconsistency issues because boolean values are incorrectly or inconsistently imported. A symptom of this data inconsistency is that VARCHAR or BIGINT values are saved as false with a string data type or 0 as BIGINT when the value shown in Salesforce Marketing Cloud is True or False.

Treasure Data recommends that you follow the Salesforce integration migration instructions.

Create an Install Package in Salesforce Marketing Cloud

After August 1st, 2019, you can not create a Legacy Package in Salesforce Marketing Cloud, therefore we highly recommend that you create an Enhanced Package.

Create a Legacy Package

Log on to your Salesforce Marketing Cloud account

...

On the Installed Packages screen, scroll down to the Components panel, then take note of the Client Id and Client Secret. You use the information to write the data from Treasure Data to Salesforce Marketing Cloud.


How to Create Enhanced Functionality Package

Log on to your Salesforce Marketing Cloud account.

...

On the Installed Packages screen, scroll down to the Components panel, then take note of the Client Id, Client Secret and Authentication Base URI. You will use the information to write the data from Treasure Data to Salesforce Marketing Cloud.


Use the TD Console to Create Your Connection

You can use TD Console to create your data connector.

Create a new connection

When you configure a data connection, you provide authentication to access the integration. In Treasure Data, you configure the authentication and then specify the source information.

Go to Integrations Hub > Catalog and search and select Salesforce Marketing Cloud.


Create Legacy Package Integration

On the New Authentication screen, select Package Type as Legacy Package, then enter the Client Id and Client Secret (which you obtained when you created legacy package in SFMC). Select Continue.

...

Enter a Name for this integration and select Done.


Create Enhanced Package Integration

On the New Authentication screen, select Package Type as Enhanced Functionality Package, then enter the Client Id, Client Secret, and Authentication Base URI (which you obtained when you created the enhanced package in SFMC). Optionally, you could specify Account identifier or MID to access multiple BUs (more detail in How to get MID) and Scope to limit the token's scope (more detail in API scopes). Select Continue.

...

Enter a Name for this integration and select Done.



Create a New Transfer

After creating the connection, you are automatically taken to Sources. Look for the connection you created and select New Transfer.

...

You will see the new data transfer in progress listed under the My Input Transfers tab and a corresponding job are listed in the Jobs section.


Available Targets

Target

Description

Campaign

The e-mail campaign

Contact

The contact list

Data Extensions

The data extensions to satisfy the need for flexible data storage

Email Events

The events associated with an email marketing send

...