Dotdigital Engagement Cloud is an omnichannel marketing solution designed to send data-triggered campaigns across channels including email, SMS, social media, push notifications, and more. You can import data from Dotdigital directly into Treasure Data.
Basic knowledge of Treasure Data, including the TD Toolbelt.
An account in Dotdigital.
An API account in Dotdigital.
Log in to DotDigital. Navigate to https://login.dotdigital.com/login.aspx?ReturnUrl=/.
Navigate to https://r1-app.dotdigital.com/access/api and go to tab: API users
Select New user. DotDigital provides you with an email address. Complete the form by adding and confirming a password, a description is optional.
Click Save.
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.
Open the TD Console.
Navigate to the Integrations Hub > Catalog.
The New Authentication dialog opens.
Select your Region. The API User Name and API User Password fields auto-populate.
Select Continue.
Enter a name for your connection.
Select Done.
After creating the authenticated connection, you are automatically taken to Authentications.
Search for the connection you created.
Select New Source.
The following procedure will step you through five sections to create a source.
Type a name for your source in the Data Transfer Name field.
Select Next. The Source Table dialog opens.
Edit the parameters in Source Table based on your objectives.
Parameters | Description |
Data Type |
|
Statistics Type | Campaigns
Contacts
|
Start Time (Required) | A timestamp in RFC3339 UTC "Zulu" format, accurate to nanoseconds, for example: |
Incremental Loading | Enables incremental report loading with new Start Time automatic calculation. |
Select Next. The Data Settings page opens.
(Optional) Edit the data settings or skip this section.
Data preview is optional; you can skip to the next section of the dialog.
The data that displays in the data preview is approximated from your source. It is not the actual data that is imported.
Select Next.
To preview your data, select Generate Preview. Optionally, select Next to skip to the next section.
Verify that the data looks approximately like you expect it to.
Select Next.
Specify where your data is placed and schedule how often it runs this import.
In the Schedule section, you can choose when and how often you want to run this query.
Run once:
Select Off.
Select Scheduling Timezone.
Select Create & Run Now.
Repeat the query:
Select On.
Select the Schedule. The UI provides these four options: @hourly, @daily and @monthly or custom cron.
You can also select Delay Transfer and add a delay of execution time.
Select Scheduling Timezone.
Select Create & Run Now.
After your transfer has run, you can see the results of your transfer in Data Workbench > Databases.