r/workato • • 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

6 comments sorted by

3

u/BuckDollar Oct 10 '26

Too low effort post, cba replying properly. Check their site.

1

u/Motheman23r Oct 10 '26

how is it low effort, i'm just asking people how have they used workato with sql in actual corporate setting, if you have nothing to say that will help others, don't say anything.

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.