Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)

Xplenty can access data in files residing on any Secure File Transfer Protocol (SFTP) server. This article details creating an SFTP connection in Xplenty.

In order to allow Xplenty direct access to your server, create firewall rules to allow Xplenty access from the relevant IPs in this list. You can also follow the directions here to allow Xplenty access through a reverse SSH tunnel.

To define a connection in Xplenty to your SFTP server

  1. Click your avatar, then click Account settings.
  2. On the left menu, click Connections. Existing connections are listed.
  3. To create a connection, click new connection.
  4. Click Secure File Transfer Protocol (SFTP).
  5. In the new SFTP connection window, name the connection and enter the connection information:
    • Hostname - the host name of the SFTP server.
    • Authentication Method - Select password or public key authentication. If key based authentication is selected, copy your account's public key from Account Settings -> Account information and add it to the SFTP user's authorized keys.
    • User Name - the user name to use when connecting to SFTP server.
    • Password - the password to use when connecting to SFTP server using password authentication.
      Note: User name and passwords cannot contain the character $ and @.
    • Port - the TCP port of the SFTP server (Default is 22).
  6. Click test connection. If the credentials are correct, a message that the connection test was successful appears.
  7. Click create sftp connection.
  8. The connection is created and appears in the connections list.
  9. Now you can create a package and test it on your actual data stored in an SFTP server.

Connectivity And Security

  1. Allowing Xplenty access to data on Amazon S3
  2. Allowing Xplenty access to my Redshift cluster
  3. Allowing Xplenty access to my data on Google AdWords
  4. Allowing Xplenty access to my data on Google Analytics
  5. Allowing Xplenty access to my Google BigQuery dataset
  6. Allow Xplenty access to my Google Cloud Spanner instance
  7. Allow Xplenty access to my data on Google Cloud Storage
  8. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)
  9. Allowing Xplenty access to my server behind a firewall
  10. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS
  11. Allowing Xplenty access to MongoDB
  12. Importing Heroku Connections
  13. Allowing Xplenty access to my data on Bing Ads
  14. Allowing Xplenty access to Azure SQL Databases
  15. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)
  16. Allowing Xplenty access to Facebook Ads Insights data (Beta)
  17. Allow Xplenty access your data on Salesforce
  18. Allowing Xplenty access to NetSuite
  19. Allowing Xplenty access to my data on Intercom
  20. Set up a reverse SSH tunnel from Windows
  21. Allowing Xplenty access to my data on Xero (Beta)
  22. Allow Xplenty access to my data on Azure Blob Storage
  23. Allowing Xplenty access to my Snowflake account
  24. Allowing Xplenty access to my data on YouTube
  25. Allowing Xplenty access to my data on Google Sheets
  26. Allowing Xplenty access to my data on Linkedin
  27. Allowing Xplenty access to my data on Instagram
  28. Allowing Xplenty access to my data on Shopify
  29. Allowing Xplenty access to my data on Pinterest
  30. Allowing Xplenty access to my Amazon Athena instance
  31. Allowing Xplenty access to my data on Xero

Feedback and Knowledge Base