CSV SFTP Pull Connector

Intro

A character-separated values (CSV) file stores tabular data in plain text form. Domo provides two connectors that allow you to access CSV files you have uploaded to an SFTP (Secure File Transfer Protocol) server:

• The Domo CSV SFTP Pull connector (formerly called the "CSV-SFTP" connector) allows you to access CSV files that you have uploaded to your own SFTP server.

• The Domo CSV SFTP Push connector allows you to capture and process CSV files that have been uploaded to Domo's own SFTP. With this connector, Domo gives you credentials, then you push your data to Domo. 

This article discusses the CSV SFTP Pull connector. For information about the CSV SFTP Push connector, visit CSV SFTP Push Connector. 

If you need to access files located on a directory, use the CSV Advanced connector. 

The CSV SFTP Pull connector is a "File" connector, meaning it retrieves files and output them to Domo. In the Data Center, you can access the connector page for this and other File connectors by clicking File in the toolbar at the top of the window.

You connect to CSV files in the Data Center. This topic discusses the fields and menus that are specific to the CSV connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Prerequisites

You must have an SFTP host name and a username and password to authenticate to the SFTP server. You also need to whitelist the appropriate IP addresses for your region. You can access the list of IP addresses, by region, in Whitelisting IP Addresses for Connectors & Federated Adapters.

Connecting to CSV Files

This section enumerates the options in the Credentials and Details panes for the CSV SFTP Pull connector. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains fields for entering credentials to connect to your SFTP server. The following table describes what is needed for each field:

Looking to upload a CSV file but do not have an SFTP server? Take a look at our Box connector or consider uploading directly from your machine using our File Upload connector. We also have our Workbench solution available for download in your Domo instance.

Details Pane

In this pane you choose a CSV report from the SFTP server you've connected to. 

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.