> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# CSV SFTP Traverse Connector

## Intro

The CSV SFTP Traverse Connector is capable of parsing any valid CSV file and retrieving data from files where the file pattern name matched with the filename at the server; It is also able to connect to different data sources or any CSV resource that is hosted remotely and available over FTP protocol.

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 Traverse 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 Traverse connector. For information about the CSV SFTP Push connector, visit [CSV SFTP Push Connector](/s/article/360042931914 "CSV SFTP Push Connector").

If you need to access files located on a directory, use the

[CSV](/s/article/360043436513 "CSV Advanced Connector") [Advanced](/s/article/360043436513) connector.

The CSV SFTP Traverse 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 Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").

## Prerequisites

You must have an SFTP host name, username, password and port 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.](/s/article/360043630093 "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 Traverse 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 Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a 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:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:201;a"><thead><tr><th colspan="1" rowspan="1"><p class="p1"><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p class="p1"><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Host Name </span></p></td><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Enter the name of the SFTP host you want to connect to. This <span /><em> must </em><span /> begin with <span /></span><span class="mt-font-courier-new"><span class="s3"> sftp\:// </span></span><span class="s1">. For example: <span /></span><span class="nowiki"><span class="s3"> s <a href="ftp://hostname" rel="noopener" target="_blank"> ftp\://hostname </a></span></span><span class="s1">. </span></p></td></tr><tr><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Username </span></p></td><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Enter the username you use to authenticate to the SFTP server. </span></p></td></tr><tr><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Password </span></p></td><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Enter the password you use to authenticate to the SFTP server. </span></p></td></tr><tr><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Port </span></p></td><td colspan="1" rowspan="1"><p class="p1"><span class="s1"> Enter the SFTP Port. </span></p></td></tr></tbody></table>

Looking to upload a CSV file but do not have an SFTP server? Take a look at our

[Workbench solution](/s/article/360042932554 "Box Connector")

available for download in your Domo instance.

## Details Section

<table border="1" data-aura-rendered-by="33:201;a"><tbody><tr><td colspan="1" rowspan="1"><b> Menu </b></td><td colspan="1" rowspan="1"><b> Description </b></td></tr><tr><td colspan="1" rowspan="1"> Filename Pattern </td><td colspan="1" rowspan="1"> Enter the filename pattern. (For example, for filename- N\_TEST\_CPtest\~XXXXXX.csv, filename pattern will be- N\_TEST\_CPtest). </td></tr><tr><td colspan="1" rowspan="1"> Date Format </td><td colspan="1" rowspan="1"> Select the required date format. This feature helps correct the date if it is formatted incorrectly. </td></tr><tr><td colspan="1" rowspan="1"> Select the Delimiting Character </td><td colspan="1" rowspan="1"> Select the character used by your character separated values (CSV) text to separate your columns. </td></tr></tbody></table>

## 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 Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").

## FAQs

<AccordionGroup>
  <Accordion title="What kind of credentials do I need to power up this connector?">
    You need the username, password and host name of the SFTP server.
  </Accordion>

  <Accordion title="How does this connector handle the data?">
    The CSV-SFTP connector pulls the data from customer's SFTP server into Domo.
  </Accordion>

  <Accordion title="How often can the data be updated?">
    Data will update every hour.
  </Accordion>

  <Accordion title="Are there any API limits that I need to be aware of?">
    No
  </Accordion>
</AccordionGroup>
