Saltar al contenido principal
waffle.svg
Domo

Microsoft Excel SFTP Connector

Version 1

 

Important: When referencing this page outside of Knowledge Base, use this link: https://knowledge.domo.com?cid=excelsftp

Intro

The Domo Excel SFTP connector allows you to access Excel files that you have uploaded to a server using SFTP (Secure File Transfer Protocol).

You connect to Excel files in the Data Center. This topic discusses the fields and menus that are specific to the Excel SFTP 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, username, password, and port number to authenticate to the SFTP server. You must also whitelist the following IP addresses:

54.208.95.237

54.208.87.122

54.208.95.167

54.208.94.194

50.207.240.162

50.207.241.62

52.18.90.222

52.62.103.83

34.198.214.100

Connecting to Your Excel File

This section enumerates the options in the Credentials and Details panes in the Excel SFTP Connector page. 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 the Excel file on an SFTP server you want to pull into Domo. The following table describes what is needed for each field:  

Field

Description

Username

Enter the username you use to authenticate to the SFTP server.

Password

Enter the password you use to authenticate to the SFTP server.

Host Name

Enter the name or IP address of the SFTP host you want to connect to.

Port Number

Enter the port number of the SFTP server.

Once you have entered valid Excel credentials, you can use the same account any time you go to create a new Excel SFTP DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

In this pane you choose and configure options for the Excel file you want to pull into Domo.

Menu

Description

File Name or Portion of File Name to Search For

Enter the file name or a portion of the file name of the Excel file you want to pull into Domo. Both .xls and .xlsx files are supported.

Type of Match to Perform

Select whether the filename starts with or contains the string you entered in the File Name or Portion of File Name to Search For field.

Is Password Protected?

Select whether the Excel file you are pulling into Domo is password protected.

File Password

Enter the password for the Excel file you want to pull into Domo.

Sheet Name (Optional)

Enter the name of the Excel sheet you want to pull into Domo. If you leave this blank, Domo pulls the first sheet of the file.

Layout

Select the layout of the Excel file you are pulling into Domo.

Mode

Select the desired parsing mode. If you select Manual, you are asked to enter a column header range and date range; if you select Automatic, these ranges are determined automatically.

Column Header Range

Enter the range of header cells in the Excel file, e.g. A2:F8

Data Range

Enter the range of data cells in the Excel file, e.g. A3:F20