cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Accessing a filesystem from an on prem database server via the agent

fgonzalez
Deputy Chef I
Deputy Chef I

Hi Workato Community. I'm hoping someone can help me with setting up access to files on an on-prem database server. We already setup the yaml file for a database profile and seeing the link: https://docs.workato.com/on-prem/agents/connection.html#connecting-to-database-profiles it looks like there's a profile that makes it possible to access the file system. If the database server is linux based how is the server and base file path defined? Help is appreciated.

7 REPLIES 7

mroldanvega
Executive Chef I
Executive Chef I

We are handling these type of use cases by creating a file share in the server and then using the on-prem files connection - https://docs.workato.com/on-prem/agents/profile.html#on-prem-files-profile with the path to the share in the "base" attribute.

Hope this helps.

fgonzalez
Deputy Chef I
Deputy Chef I

Thanks so much for your help


duane-vanheerde
Workato employee
Workato employee

Hi Frank! Great to see that you joined Workato Community! I'd like to see if Abhi, your automation consultant - can assist you in this area. I'll have him reach out to you.

arathi
Deputy Chef I
Deputy Chef I

Just like how Manuel mentioned above, we also use "files" tag in the config yaml file to connect to network share. One thing to note is that the account thats running the Workato service should have full access to the network share thats configured.