7.7.10.1 [Set up connection] of Burt in ADvendio
Challenge:
I want to establish a connection between ADvendio and Burt, as well as connect ADvendio to my additional storage.
Solution:
Before starting, you need:
Burt credentials to the storage associated with your account (Amazon S3 bucket)
A Programmatic license: For programmatic data import, a separate license is needed.
ADvendio Storage credentials: To use ADvendio Storage, a separate license is needed.
Note:
For further information on licenses needed for programmatic data import, as well as on the setup of ADvendio storage, please contact your technical account manager or email support@advendio.com for more information.
Once the requirements from above are met, you can start connecting ADvendio to Burt:
In the App Launcher search for ‘Connection’
Create a new Connection
Select BURT as the Record Type.
Enter the storage credentials you received from Burt:
User Name: <Access Key>
Provided by BURT account
Password: <Your Secret Key>
Provided by BURT account
Network ID: <Region>
Here goes your current AWS Region
Here is the documentation to see the format of your region https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RegionsAndAvailabilityZones.html
Login URL: <Bucket Name/Link>
s3://[S3_Bucket&Path]/third_party/[YEAR(YYYY)]/[MONTH]/[DAY]/third_party-[DATE-YYYY-MM-DD].csv → This part in GREEN is completed automatically filled by ADvendio since its dynamic and changes accordingly day by day
Examples of how the URL is constructed and how the complete URL should look like when you enter it:
S3 Bucket: burt-customer-export-us-east-1
S3 Path: production/ABCOF5RR00EE
i.e.: s3://burt-customer-export-us-east-1/production/ABCOF5RR00EE
The integration will need to store parts of the data in between to generate Media Campaigns. For the Burt integration, the data is stored in the ADvendio Storage. Alternatively, look for the Additional Login object and make sure you select the correct related connection when typing in the ADvendio storage credentials in the next step.
Steps
To access the storage, in the Connection go to the “Related” Tab and look for the object Additional Logins.
Add ‘new’
Enter the credentials* you received from ADvendio accordingly:
*These credentials need to be solicited directly from the support team.
The credentials are:
Record Type = PROGRAMMATICDATA
Username = The username you received from ADvendio
Endpoint = The name of your endpoint. You will also receive this information from ADvendio, usually identical to the username
Password = The password you received from ADvendio
Save
Warning:
Please use one Username/Endpoint per org.
If you want to test in Sandboxes please use a different username and endpoint from your productive environment. If you use the import with the same endpoint in different orgs, this may lead to inconsistencies in your data.