>

Allowing access to my file data on SFTPToGo

Allowing access to my file data on SFTPToGo

SFTPToGo is a quick and easy way to spin up an SFTP server. It allows you to store files and then ingest them on our platform for processing purposes. The SFTP server can also be used as a destination on our platform so you can send processed files to the server and access them from there.

If you do not already have an SFTPToGo account, you can sign up for an account here. All accounts include a 7-day free trial. Once you have your SFTPToGo account you can then follow the steps below to connect your SFTP server to our platform in less than 3 minutes. 

Connecting To Your SFTPToGo Server

Step 1 

On your Integrate.io or Prepforce account, click ‘Connections’ on the lefthand navbar, next click ‘New Connection’ button, and then click ‘Secure File Transfer Protocol (SFTP)’. 

Step 2

In this step you will need to add your SFTP account credentials. Below are the instructions for where you can find each credential. 

  1. Name: You can type in whatever you would like to name this connection. E.g. ACME SFTP Connector

  2. Hostname: In your SFTPToGo account, click the ‘Credentials’ tab and copy the ‘Host’ to this field

  3. User name: In your SFTPToGo account, click the ‘Credentials’ tab and copy the ‘Username’ to this field

  4. Password: In your SFTPToGo account, click the ‘Credentials’ tab and copy the ‘Password’ to this field

You can leave all other fields (Authentication method, Access type, Port) as their default values. 

Step 3

After adding the credentials for the 4 fields in the step above, you can now proceed to test the connection by clicking ‘Test Connection’.

You should see a ‘Yay, test successful’ notification like in the screenshot below.  

If you do not see this notification, follow the steps outlined by the error notification to resolve any issues with your credentials until you get a successful test connection. 

Step 4

Once you have successfully tested your connection, you can click ‘Create connection’ button and start using your SFTPToGo server. 

Using a File From SFTPToGo Server in Your Package

Now that you have successfully created a connection to your SFTPToGo server, you can start ingesting files to use in your packages. 

To ingest a file from your SFTPToGo connection, first load your file to your SFTPToGo server. You can do this by clicking on the ‘File Browser’ tab on your SFTPToGo home screen and then uploading the file. 

Step 1 

On the Integrate.io platform, click on ‘Packages’ on the left navbar and then click ‘New Package’. Name your package and then click ‘Create package’

Step 2

In the package designer, click ‘Add Component’ and, under the Sources column on the left, select ‘File Storage’. 

Step 3

Click on the ‘File Storage’ component and then choose your input connection from the dropdown menu in Step 1. This will be the SFTP connnection you just created. Then click ‘Next’.

Step 4

In your SFTPToGo dashboard, under the ‘File Browser’ tab, click on the 3 dots ‘...’ on the file you want to ingest and then click ‘Copy path to clipboard’.

Then on Step 2 of your connection page on Integrate.io, paste the copied path name to the ‘Source path’ field.

You can leave the rest of the settings at default unless you have specific requirements for any of them. 

Click ‘Next’

Step 5 

The third and final section of this source component is for selecting the fields you want to use in your package and load to Salesforce. You can filter the actual fields that get loaded to Salesforce in a later component step. This step shows you a Data Preview of the fields in your file being ingested. 

Click ‘Save’ and you have now completed the source component. 

You can now proceed to add data transformation components to your package. If you don’t have a need for data transformation, you can proceed to add the Salesforce component from the Destination column and set that up.