topic Re: Accessing a filesystem from an on prem database server via the agent in Workato Pros Discussion Board

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

fgonzalez — Wed, 26 Jan 2022 05:33:05 GMT

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.

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

mroldanvega — Wed, 26 Jan 2022 05:49:15 GMT

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.

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

fgonzalez — Wed, 26 Jan 2022 06:04:05 GMT

Thanks so much for your help

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

duane-vanheerde — Wed, 26 Jan 2022 06:08:53 GMT

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.

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

arathi — Fri, 28 Jan 2022 01:43:18 GMT

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.

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

fgonzalez — Fri, 28 Jan 2022 01:59:47 GMT

Cool..I was not the one who set up the agent and configured the service run and stop (it's a windows box). When I set up the connection, I am able to see the subdirectories, but yet I'm not able to get it to trigger when I add a new file - which is how I configured this trigger. What is the best way to know what account is running the workato service

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

fgonzalez — Fri, 28 Jan 2022 02:01:16 GMT

Under properties: Log ON tab, The radio button labelled Local System Account is turned on

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

abhiroop-sharma — Sat, 29 Jan 2022 01:04:38 GMT

Frank Gonzalez I would recommend to check the OPA log to see if you notice any errors, permission issues could cause such behaviour. You could try to write a test file into the same folder to check if that works or not. You can enable more detailed logging by following the steps here https://docs.workato.com/on-prem/agents/logging.html#logging-opa-activity if you dont see anything in the logs. We can also do a quick call if you have time today