Direct Query against on-prem source

hmadari · 2024-08-12T16:32:49+00:00

There was an error rendering this rich post.

Can Domo perform a direct query against an on-prem SQL Server instance? For example, if I have a database named "SalesDB" on my local SQL Server, can Domo connect to it and run a query like "SELECT * FROM Orders WHERE OrderDate > '2024-01-01'" directly?

I thought workbench would've have that option.

Find more posts tagged with

Connectors

Workbench

Dataset

Meta Data

Accepted answers

GrantSmith

You won't be able to use the file directly but you could set up a local SQL Server which reads that file and allows you to connect to it.

MarkSnodgrass

I use Domo Workbench to directly query a SQL Server. You just need to create an ODBC connection on the computer running Workbench and then use that connection to your SQL Server.

https://domo-support.domo.com/s/article/360042932734?language=en_US

All comments

GrantSmith

You won't be able to use the file directly but you could set up a local SQL Server which reads that file and allows you to connect to it.

MarkSnodgrass

I use Domo Workbench to directly query a SQL Server. You just need to create an ODBC connection on the computer running Workbench and then use that connection to your SQL Server.

https://domo-support.domo.com/s/article/360042932734?language=en_US