A Secure File Transfer Protocol (SFTP) account can be necessary in different areas of Acoustic Campaign.
Secure File Transfer Protocol (SFTP)
The SFTP feature allows you to import large files into Acoustic Campaign (e.g. a database file), export files from Acoustic Campaign (e.g. updated database files to transfer to your data warehouse) and set up Recurring List Imports (Database or Relational Table).
You can also use SFTP for inserting External Content into an email template and perform certain API processes (e.g. Reporting or List Import).
Acoustic Campaign supports SFTP (SSH File Transfer Protocol). We do not support SCP (Secure Copy).
Access your SFTP
SFTP credentials you will need:
- Port Number 22
For SFTP information and other Acoustic URLs, see Standardized Acoustic URLs.
Pod information for setting up an SFTP account
To access your SFTP account, you first need to know your Acoustic Campaign pod.
All active Acoustic Campaign user accounts are already SFTP enabled. If you have an active Acoustic Campaign user name and password, you are ready to go.
For example, if you log in to
campaign-us-1.goacoustic.com, your Pod number is 1 and your SFTP host is
sftp://transfer-campaign-us-1.goacoustic.com. Also, the user name and password are the same as your Acoustic Campaign user name and password.
In your respective SFTP, enter the port number for the appropriate protocol.
- SFTP = Port 22 (supports pods 1, 2, 3, 4, 5, 6, 7, 8, 9, A)
See Standardized Acoustic URLs for the latest pod and SFTP address information.
|POD number||POD address||SFTP address|
If the multi-factor security method is enabled, users cannot access the SFTP using user name and password. Use one of the following alternatives to access SFTP.
- Public key
The public key way of authenticating for SFTP now uses the same method for checking valid user names and passwords as the password way does. So if a user is blocked or disabled as indicated via the UI/API, then they'll likewise be prevented from successfully logging into SFTP.
Public key method does check for IP restrictions, if enabled for the org or user.
User name and password authentication
A failed SFTP login attempt increments the total number of failed login attempts for the user. Repeated failed attempts blocks the SFTP user based on the Organization Password Policies.
A failed SFTP login attempt can be resolved by resetting the SFTP user's password within the Acoustic Campaign UI.
Your organization can now place IP restrictions on SFTP access. After the user name and password prove valid, the process checks on IP restrictions. If there is a restriction in place, visible by checking Access Restrictions, and a user attempts access from an IP not listed in access restrictions, then FTP access is not granted.
For authenticating with OAuth, user name must be oauth in all lowercase and the password is the OAuth access token value. The user name oauth is case sensitive.
Once the FTP service sees the oauth user name, it validates the token. If the token is invalid or expired, then no FTP access is granted.
The OAuth app that access is granted for must allow SFTP resources.
OAuth authentication for SFTP bypasses IP restrictions for SFTP, similar to the way OAuth functions for Transact.
Authenticate to SFTP with OAuth
You can authenticate to your SFTP client by using an OAuth access token.
Note: SFTP OAuth requires you to use an application and access credentials that were created after the Acoustic Campaign 16.4 release.
This implementation of OAuth is case sensitive. To authenticate by using OAuth, your username must be OAuth in all lowercase, and the password must be the OAuth access token. Once the SFTP service sees the OAuth username, it validates the token. If the token is invalid or expired, then SFTP access is denied.
The OAuth tokens have a lifetime of 4 hours, but can be refreshed after 3 hours. If you request one before the start of the third hour, you receive the same access token that you were issued earlier. If you request an access token after the start of the third hour, a new access token is generated. Ergo, it can be reasoned that your user account has two access tokens available use. It is recommended to request a new token after 3 hours to prevent the single access token from expiring.
When you setup the OAuth access by using the user interface, you should choose the same username that you have used for creating the
- Register your application.
- Go to Application Account Access under Organization Settings and then select the section header.
- To register your new application, click Add Application and fill out the fields. After you click Add, you will be presented with your new client id and client secret values that you will then use in your OAuth calls.
- Grant the application access to the Acoustic Campaign.
- While still in the Application Account Access section, click Add Account Access.
- Choose your new application from the drop-down and specify the user that you want it to use when you make API calls. Once you click Add, a refresh token is generated and emailed to your notification email address. You use this refresh token, in concert with the client id/secret that was previously generated, in your OAuth calls.
Location of your uploaded SFTP file
If you don't see the file in your Stored Files tab or your Stored Files are empty, consider the following.
- With SFTP and Acoustic Campaign linked, you see only the files that were uploaded under the same account as the user who imported them.
- Make sure that the user name that logs files into SFTP and uploads them is the same user name that sets up the recurring import.
- Files remain on the SFTP server for 14 days before an automated process removes them.
- Make sure you have the correct SFTP host and port.
Uploading your data file to Acoustic Campaign using API
When you upload your data file to Acoustic Campaign using API, you need to place your data file and mapping file in the upload directory on the SFTP sever.
You can build your mapping file manually, but to avoid mistakes/typos, you can create it automatically using the Acoustic Campaign user interface.
To do that you can upload a data file containing the data fields and just one test contact. This process creates a mapping file in the Stored files/list_import_jobs folder.
SFTP with Transact
If you are using Transact with XML submission, the SFTP account allows you to submit larger batches of contacts who you want to send transactional messages to.
- The host name for SFTPs account is sftp://transfer-campaign-us-X.goacoustic.com, where the 'x' is your Pod number (Here's a complete list of all URLs and SFTPs)
- If your organization has a Transact account, you must first upload your batch files to the Transact/Temp folder. Once that completes you then move (perform a RENAME) the files to the Transact/Upload folder, which triggers the Transact job. If you deposits into the Transact/Upload folder first the job immediately starts and if the file is too large the job locks up because the file was not completely uploaded. This causes a job failure.
- It is not possible to set up a recurring import to pick up a file within a subdirectory of /upload. The files must be placed directly in the upload folder to be picked up.
- Note that SFTP is for files that need to be processed by a data job, imported or exported. Acoustic Campaign SFTP is not for file storage. Every day a cron job runs that clears files that are 14 days old. There is no backup for the files that are in the SFTP so if they are deleted, they are no longer retrievable.
Can I schedule multiple recurring imports for the same hour?
Acoustic Campaign locks a database during an import so other imports can't run until the first one completes. If you have 3 databases that each have a recurring import, they can all run an import job simultaneously without issue. However, if you have one database that has 4 recurring jobs setup on it to import at the same hour each day, then only one import can run at a time on the database.
It is typical for the recurring jobs to run in the same order every day, however, the order can change on any given day if the process responsible for picking up import jobs to run sees that two recurring imports created a child job at the same exact second, and we can't predict when this will occur. Each recurring job creates a new child Job ID each day (what you see when looking at Resources > Data Jobs), and the system runs the jobs in order of Job ID, where the smaller ID starts first. The jobs usually run in order of the first to last recurring job that was setup against a given database however, this is not always the case.
What to do if your SFTP login stops working
If you have Org Admin access, you may want to set up your Acoustic Campaign user name so that the password does not expire, as follows.
- Go to User Accounts.
- Click your user name and check the box next to: Do not enforce password expiration policies for this user.
- Click Save.
Note: If you change your Acoustic Campaign user name or password, this change automatically updates your SFTP login credentials.
Import a file using SFTP
If there are multiple files in the SFTP upload folder, which are to be used for the same database using Recurring Import Update, all files are pulled and imported. Each file creates a separate data job for import, but this activity does not occur in any specific order.
- Place your file on the SFTP Server
- Log in to your SFTP Client with your SFTP credentials.
- Click Connect.
- Find the File to Import and place it in the Upload folder.
- Open the upload folder to ensure that your file transferred successfully.
- Import your file from the SFTP.
- Log in to Acoustic Campaign.
- Go to Stored Files.
- Click Import from SFTP.
- Choose the folder to import the file to. Save the file in Shared or one of its sub-folders; otherwise a different user will not be able to access the file.
- Access the file from Acoustic Campaign.
- Navigate to Data > Import > New.
- Name the Database and choose which type of database or list to create.
- Select Flexible or Restricted database.
- Choose Select File from Stored Files.
- Browse to select the file.
- Select the file and choose the File Type.
- Click Next.
- Follow the Import Wizard to complete the Import process.
Export a file using SFTP
Follow this procedure to export a file by using SFTP.
- Go to Stored Files.
- Select the Private tab.
- Click the Import Files folder and select the file you want to export to your SFTP account.
- Click Export to FTP.
- Click OK.
Once the screen closes, the process is complete.
- Login to your SFTP account and enter this information:
- Host Name:
- Port: 22
The file(s) is located in the Download folder.
Does restricting IP access affect SFTP?
Your Acoustic Campaign organization has Access Restrictions to limit logins from certain IP addresses, does this affect logging in to the SFTP server as well?
Perhaps. Acoustic Campaign now allows you to restrict SFTP access by IP address. If an Organization Administrator has placed restrictions on your SFTP it will impact access.
Allow a third party to send or receive data without access to Acoustic Campaign
You can allow a 3rd party to send or receive data to and from Acoustic Campaign via SFTP, but not allow them access to Campaign.
To achieve this, use the SSH Keypair authentication. Create a public and private key that allows to machines to talk to one another directly without the need to pass credentials.