Setting up SFTP

joebenz

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"

ArborRose

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:

1. 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.
2. 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.
3. 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.
4. 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.

MarkSnodgrass

@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.

https://youtu.be/zdHfKYa4Fkw

ArborRose

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:

1. 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.
2. 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.
3. 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.
4. 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.

joebenz

Thank you @ArborRose. Yeah, it's not as straightforward with Domo as the other data retrieval. I appreciate the info!

MarkSnodgrass

@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.

https://youtu.be/zdHfKYa4Fkw