I have a user who runs a macro in excel to run a query against my SQLBase server. I am trying to have workflow run the query on a schedule instead, not sure yet what I will do exactly with the output, but that comes later.

I've been mostly working with the Query Data tool, but I also have tried the Custom Query, which I think is ultimately what I need to use for my query as it's pretty complex.

If I test the connection through the data source manager it reports everything is fine, I see all the proper tables in the drop down when using Query Data, however it seems like no matter what query I try to run I always get 0 rows. The same queries work fine in other tools.