Discover best practices and find answers to your questions with advice from fellow Domo users.
I use Domo Workbench on-prem to upload data from 2 SQL Servers nightly via ODBC connections. I need to move one of the SQL Servers from on-prem to an AWS EC2 instance. Rather than pulling this data from AWS to my on-prem environment just to then upload to Domo, can I install Workbench on the AWS EC2 instance and move the…
Hi all, I am using Workbench on an on premise server. What I wanted to understand is if because of this….is all of the data on my server only on the server? Or is the data still being uploaded to the cloud?
Hi everyone, I'm working with Domo Workbench on a remote desktop (RDP) and need to securely connect to a MySQL database hosted on a private network. Typically, this is done via a TCP/IP connection over SSH, which adds an extra layer of security by encrypting the connection between the client and the database. However, I'm…
Is there a way to create a button as a card to run a job in the workbench? For example, I'm currently running QB Desktop through the workbench and the accounting team would like to be able to run manually by hand the dataset while they are closing out the month. I don't want them to have to login into the workbench and…
I was excited to check out the functionality of this when I thought I could apply changes to the values in my source dataset before loading to the target, which in my case is a SQL Server table. However, the only columns available for transforming are the log columns for the writeback process itself, as shown here (not…
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.
We have some datasets on our Domo Workbench setup as Appends. They have grown very large over time as they take a snapshot of the data daily. The datasets are still used but we no longer need the complete history. We would like to do something like keep the last 2 years or maybe keep one reading per month or something…
Hello All, One specific dataset for some reason has started to "crawl" when processing. It used to take anywhere from 5-10min to process but now it is only processing around 3k rows every 5 min. Any idea where to begin to look for a reason of this to all of a sudden happen? We have this on a 2-hour schedule so since it…
Can someone point me to a good step by step guide to setting up partitioning in Workbench 5.2? I have a very large dataset (currently 5.8 million rows) that gets updated daily with a full replace. As you can imagine it takes a HOT MINUTE to run. On average there are 12.5k new records and 100 records updated or deleted…
When posting a workbench job on advanced schedule > more than once a day, users can only set time based on the current time. If i wanted to schedule a job at 10am and hourly but its currently 10:15am, i would have to wait till the next hour mark before setting the job to run at the time i needed.
It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications