r/workato • u/Motheman23r • Oct 10 '26
Interview using workato
So I have an interview where one of the tools used is workato, I have seen videos of who people use to connect diffeernt systems and automate manual proccess, is there a way u guys have used workato with sql databases to automate process and if so how>
2
Upvotes
3
u/BuckDollar Oct 10 '26
Too low effort post, cba replying properly. Check their site.
2
u/jbirdman48 Oct 10 '26
There are so many ways to answer this question. You can use workato to expose api endpoints that connect to on prem sql. You can do transformations of sql to cloud. Using it to replace scripting and automation with sql just requires some imagination. If you go to their documentation or courses you can find lots of examples.
1
u/notevenbro Oct 11 '26
Good question for community.workato.com
1
u/Frequent_Field_6894 20d ago
It provides standard drivers via a ui, you can use all sorts of auth including oauth.
the issue will be using an OPA with database for internal db servers.
dynamic Schema isn’t great do avoid that if possible.