SFTP Pull Connector
I'm trying to automate the import of a few csv files from an sftp. I've connected to the sftp through FileZilla, using the Hostname, Port, Username and Password, but when I try to connected using the CSV SFTP Pull Connector there is not a place to enter the port, and the connection times out. There aren't many options for different things to try. Eventually I'd like to be able to specify a file path. Any hints?
Comments
-
I do this with code outside of Domo. I created a small visual basic executable that downloads from an sftp site, to a local file. It then copies and renames the file to something easy for me to upload into Domo using Domo Workbench. I also copy a dated version to a folder so I can keep a history.
You can also script with WinSCP. But that's probably similar to what you are doing with FileZilla.
The following is a generic version of code in case its helpful to someone -
To download an Excel file from an SFTP server using VB.NET, you can use the SSH.NET library, which provides SSH and SFTP functionality. You'll need to install the SSH.NET NuGet package to your project.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **1 -
If interested in scripting with WinSCP, here's a link to some examples.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive