Using SQL Query to create cards.
Comments
-
If you have a SQL query, you probably want to use Domo's Workbench application to connect that query output to your Domo instance. Then you can schedule the query to run at regular intervals and update the data upon which your card will be built.
Workbench is usually installed on a server that has a DSN configured with Oracle connection information. Pretty much like you'd have on Oracle SQL Developer.
This is how we have a LOT of our data set up since we're an Oracle shop.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks Aaron for the reply.. Now here there is a situation.. I have all the database installed on a different machine which I access using VPN (remotely), so how can I connect myworkbench to that server? As Iam also not allowed use/ install any external tools in that machine. Any light you can throw as to how we need to go ahead about the same?
0 -
Also Aaron, is there any sample database which I can connect to check SQL query implementation using DOMO.Also is there any way to get the data in a separate DB server (which we connect using VPN) to DOMO?
0 -
As Aaron mentioned earlier, you'll have to create a DSN/ODBC entry on your machine to create the connection to the DB server. then you can use that ODBC connection in Wokrbench to connect to the DB.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 636 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 761 Beast Mode
- 65 App Studio
- 42 Variables
- 701 Automate
- 182 Apps
- 457 APIs & Domo Developer
- 52 Workflows
- 10 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 132 Manage
- 129 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive