โ01-25-2022 09:33 PM
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.
โ01-25-2022 09:49 PM
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.
โ01-25-2022 10:04 PM
Thanks so much for your help
โ01-25-2022 10:08 PM
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.
โ01-27-2022 05:43 PM
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.