Pulling CSV file from UNIX Server

user11651 · July 2020

Hi All,

I am trying to pull CSV file from UNIX server using below DoMo connectors but getting some errors.

1) CSV SFTP Pull Connector -

Inspite of providing correct credentials and hostname with appropriate syntax I am getting error

as "Failed to Authenticate. Verify the credentials and try again"

2) CSV Advanced Connector

with this connector i am getting following error

"could not load known_hosts"

With these issue please help me to know,

1) if DoMo is able to connect and Pull file from UNIX Server on specified path ?

2) Do above connectors are useful or we need to use any other connector ?

3) if DoMo have any connector to pull file from UNIX then what is the environment setup required to be made on DoMo and UNIX side?

Thank You.

All your help is appreciated.

jaeW_at_Onyx · July 2020

Yes, Domo can do it ? Usually it'll be a matter of finding the right configuration settings.

can you confirm that you can do an SFTP pull using any other client and the configuration settings you've applied? Filezilla for example?

if you have the option of scripting from the server side, do consider using the JavaCLI to push data into domo. I have a tutorial video where I demonstrating using UPSERT, which is completely NOT applicable to what you described, https://www.youtube.com/watch?v=kHSeSbSFS1Q&list=PLUy_qbtzH0S4eYAu13c-NMnyOuxJwspzh&index=8, but it is a complete solution built using the JavaCLI so you can get a feel for what it looks and feels like.

https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool

user11651 · July 2020

Thank You Jae !!!

I am not sure what is the configuration setting of UNIX server as it is owned by some other organization.

Could you please help me to know what are the exact inputs you needed to address this issue? so that I will request that orgnization to provide the same.

Pulling CSV file from UNIX Server

Comments

Categories