https://leadsbridge.com/wp-content/themes/leadsbridge/img/integration-lg-logos/logo50.png
https://leadsbridge.com/wp-content/themes/leadsbridge/img/integration-lg-logos/logo969.png
How to connect Exact Target (Salesforce® Marketing Cloud) with FTP/SFTP
Exact Target (Salesforce® Marketing Cloud) / FTP/SFTP
Documentation

Connect Exact Target (Salesforce® Marketing Cloud) to FTP/SFTP with LeadsBridge

Exact Target (Salesforce® Marketing Cloud) » FTP/SFTP

In this article, you'll learn how to set up the bridge and connect Exact Target (Salesforce® Marketing Cloud) to FTP/SFTP using LeadsBridge.

How to set up your bridge step-by-step tutorial

Before you start

  1. Head over to the left sidebar and click on Bridges
  2. You'll be taken to the Bridges section of your account
  3. Click on the Add New button
  4. You'll be taken to the first step of the bridge creation

Step 2: Setup your Exact Target (Salesforce® Marketing Cloud) source

  1. Type in the name you'd like to call your integration
  2. Enter Authentication Base URI, Client ID and Client Secret to connect your Exact Target (Salesforce® Marketing Cloud) with LeadsBridge
    1. Log into Exact Target with an Admin User
    2. On the top right of the screen, next to your username, make sure to select the correct Company, or Business Unit, that you want to connect with LeadsBridge
    3. Click on your username on the top right of the screen
    4. Click on Setup
    5. Go to Apps » Installed Packages, under Platform Tools
    6. Click on New at the top right of the screen
    7. Give a name to your New Package, for example LeadsBridge
    8. Click on Save
    9. Click on Add Component
    10. Select API Integration, then click on Next
    11. Select Server-to-Server, then click on Next
    12. Click on the Edit button of the API Integration you just created
    13. Flag the following items:

      1. Under Channels » Web, flag Read, Write and Publish
      2. Under Contacts » Audiences & Contacts » List and Subscribers, flag every item (if you want to use Lists)
      3. Under Data » Data Extensions & Data » File Locations, flag every item (if you want to use Data Extensions )
    14. Click on Save
    15. Copy the Authentication Base URI, Client ID and Client Secret from the API Integration you have just created on Exact Target
    16. Paste that information inside your LeadsBridge integration setup
  3. Select the segment you'd like to use as the source for your leads
  4. Click on the Next button

Step 3: Setup your FTP/SFTP destination

  1. Type in the integration's name in the dedicated field
  2. Enter Use SFTP? (Secure FTP), FTP Host, FTP Port, FTP Username, FTP Password, Root directory, Headers row number (default 0), Charset, File's extension (eg. txt), Fields Separator Char and Destination filename pattern to connect FTP/SFTP with LeadsBridge
  3. FTP details are hostname/username/password for accessing your files on the server by using an FTP client. The FTP details will comprise a server address (EG. ftp.yourdomain.com), username and password.

    If you don't have them or don't know what they are, you can simply contact your web hosting provider, and they will give you this information.

    Most web hosts will email you these details after you sign up for a web hosting package. You’ll find your FTP information in the welcome email you receive from your host.

    Example FTP Details:

    • Use SFTP This allows to use the Secure mode if your FTP server implements it
    • FTP Host This is the hosting server name
    • FTP Port The default FTP port is 21. For SFTP is 22
    • FTP Username/Password Your FTP username/password (typically the same as your cPanel login details).
    • Root Directory This is the the folder in your web hosting server that holds all the files that make up your actual website. Generally, it's "public_html/"
    • Headers row number This is the row index (based 0) where the headers of the file are located
    • Charset This is the encoding charst of you input files
    • File's extension This is the extensions that files will be filtered in case of Source usage
    • Fields Separator Char The char used as separator for the CSV
    • Destination filename pattern This value is used when the integration is used as Destination, to determinate the name of the output file. It could be used some DateTime patterns chars like Y/m/d H:i:s. It is important to include the pattern inside square brackets like Ymd
    • Click on the Next button
    • You'll now be able to select the destination segment to send your leads to
    • You may choose to receive an email receipt for each incoming lead.
      • Type the address(es) where you'd like to receive the receipt
      • You may also modify the Subject line of the email
    • Click on the Next button

That's all! Congratulations.

You'll be redirected to the bridges section of your account with a green success message at the top right of the page and your bridge will now be active.

Have you got some questions?

You may want to take a look at the common questions on the respective integration's documentation.

If you have any other questions, or need help to configure your bridge from Exact Target (Salesforce® Marketing Cloud) to FTP/SFTP with LeadsBridge, do not hesitate to contact our Support!