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:

  1. Create a new Connection, by selecting BURT as the Record Type.

  2. Enter the storage credentials you received from Burt:

     

    1. User Name: <Access Key>

      1. Provided by BURT account

    2. Password: <Your Secret Key>

      1. Provided by BURT account

    3. Network ID: <Region>

      1. Here goes your current AWS Region

      2. Here is the documentation to see the format of your region https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.RegionsAndAvailabilityZones.html

    4. Login URL: <Bucket Name/Link>

      1. s3://[S3_Bucket&Path]/third_party/[YEAR(YYYY)]/[MONTH]/[DAY]/third_party-[DATE-YYYY-MM-DD].csv → This part in red is completed automatically filled by ADvendio since its dynamic and changes accordingly day by day

      2. Examples of how the URL is constructed and how it should look like when you enter it:

        1. S3 Bucket: burt-customer-export-us-east-1

        2. S3 Path: production/ABCOF5RR00EE

          i.e.: s3://burt-customer-export-us-east-1/production/ABCOF5RR00EE


  3. 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. To access the storage, go to the related tab, and look for object Additional Logins. 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.

     

 

4. Add a new Programmatic Data record and enter the credentials* you received from ADvendio accordingly:

*These credentials need to be solicited directly from the support team.

  • 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

 

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.