Setting up SFTP
I'm working with a vendor that wants to send us data via SFTP. I looked up the documentation for the connector and sent them a .pem file pulled from my instance. They have said the following. Can someone help me find out where to get this information? Thank you!
" You shared a private key from DOMO and it appears we do not accept private keys. We need to know where to send the file + we need credentials in order to send the file:
1. Provide a Destination – Where should Vendor send the file.
2. Provide Credentials – Allows Vendor to send the file to Domo
· Hostname
· User Name
· Password
3. Optional Information
· File Name format – is there a specific format Vendor should use in the file name"
Best Answers
-
Domo does not provide a standard SFTP server endpoint for file uploads directly. Instead, Domo typically integrates with data sources through connectors, APIs, and other methods rather than direct SFTP uploads.
If you need to transfer data to Domo, you generally have these options:
- Domo Connectors: Use one of Domo's pre-built connectors for data sources, which handle the data import process. This is the most common method for getting data into Domo.
- Domo API: Use Domo’s API to push data into the platform programmatically. This would involve using the Domo API endpoints to send data in the correct format.
- Dataflow: You can upload files directly into Domo's Dataflow if you have a CSV or Excel file, but this is usually done through the web interface, Domo Workbench, etc…. and not via SFTP.
- Third-Party Integration Tools: Some organizations use third-party tools or services to integrate data with Domo, which might include SFTP as part of their workflow, but this would be set up and managed outside of Domo's native capabilities.
I personally handle SFTP communications with Domo by constructing C# (asp.Net) code or Python code to push or pull data. But this is custom programming and not a native capability.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@joebenz Domo does support SFTP. I used it quite a bit. You can have the vendor push to it, or you can have the Domo connector pull from their SFTP site. Most vendors prefer to push to Domo. The issue tends to be that vendors are used to a PGP key and not a PEM key. PEM keys can be converted to PGP by the vendor.
This KB article explains how to set up the connector.
https://domo-support.domo.com/s/article/360042931914?language=en_US
Once you create the connector, the settings tab will have the url and username that you would need to provide to the vendor. You would also send them the pem key that Domo will generate for you when you create the connector.
This video may also be helpful for you or your vendor.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Domo does not provide a standard SFTP server endpoint for file uploads directly. Instead, Domo typically integrates with data sources through connectors, APIs, and other methods rather than direct SFTP uploads.
If you need to transfer data to Domo, you generally have these options:
- Domo Connectors: Use one of Domo's pre-built connectors for data sources, which handle the data import process. This is the most common method for getting data into Domo.
- Domo API: Use Domo’s API to push data into the platform programmatically. This would involve using the Domo API endpoints to send data in the correct format.
- Dataflow: You can upload files directly into Domo's Dataflow if you have a CSV or Excel file, but this is usually done through the web interface, Domo Workbench, etc…. and not via SFTP.
- Third-Party Integration Tools: Some organizations use third-party tools or services to integrate data with Domo, which might include SFTP as part of their workflow, but this would be set up and managed outside of Domo's native capabilities.
I personally handle SFTP communications with Domo by constructing C# (asp.Net) code or Python code to push or pull data. But this is custom programming and not a native capability.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Thank you @ArborRose. Yeah, it's not as straightforward with Domo as the other data retrieval. I appreciate the info!
0 -
@joebenz Domo does support SFTP. I used it quite a bit. You can have the vendor push to it, or you can have the Domo connector pull from their SFTP site. Most vendors prefer to push to Domo. The issue tends to be that vendors are used to a PGP key and not a PEM key. PEM keys can be converted to PGP by the vendor.
This KB article explains how to set up the connector.
https://domo-support.domo.com/s/article/360042931914?language=en_US
Once you create the connector, the settings tab will have the url and username that you would need to provide to the vendor. You would also send them the pem key that Domo will generate for you when you create the connector.
This video may also be helpful for you or your vendor.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 618 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 741 Beast Mode
- 58 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive