-
How to migrate Workbench jobs to new server safely?
I will be decommissioning my server Domo Workbench runs on and need to migrate all jobs to a new machine. The current Workbench has jobs that run as frequently as every 60 minutes. I figured I could just export/import the jobs/settings, and leave them in a disabled state on the new server, test my connections to Domo, then…
-
Safe to run Workbench on multiple machines?
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…
-
Workbench security question
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?
-
Search/Replace Transform Editor
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 Workbench Support TCP/IP Over SSH for Secure Database Connections?
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…
-
Run Workbench Button
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…
-
Direct Query against on-prem source
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.
-
Truncate Appended Domo Workbench Dataset
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…
-
Workbench Extremely Slow Out Of Nowhere
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…
-
Partitioning for Dummies?
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…
-
DOMO Workbench Error: Failed to get a response from the Domo server
I am running a workbench job that is failing with the error message: Failed to get a response from the Domo server. Other jobs on my Workbench are running as normal. I tried to re-run the job, and rebooting my machine. Is there any way to remedy.
-
Setting Time on Workbench Advanced Schedule
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.
-
*.xlsx issue after Workbench update
Following the Domo Workbench update to the latest version (5.2.8606.30751), I've encountered a problem where all my configured jobs are no longer functioning, displaying the same error message. The error happens when the Transport Type is ‘Domo SharePoint Data Provider’. All jobs are affected. All files are *.xlsx and I…
-
DomoStats - Workbench should include Schedule Groups and Job ID
Domostats - Workbench has almost all the information we would need for tracking purposes. Including Schedule Groups names and the Job ID would make it more effective.
-
Workbench Details Dataset
Is there a way to get a workbench dataset similar to the governance datasets available on DOMO? I understand workbench functions on a local server but there's got to be a way to export to excel or something workbench job details. Is this possible?
-
JSon file in Domo
I have a Json File ,what steps should I take to upload in Domo to analyze data
-
Failed to Execute - Domo Workbench
Hi All, I'm getting this error when trying to execute workbench job. "Position is not in format ColumnNameRowName." Any help appreciated. Thanks!
-
Domo workbench - "attempting to open data source"
When a workbench job is executing, does anyone know what is happening when the preview window execution step says "attempting to open data source"? We will have a job that gets stuck on this step for several hours and it is unable to get past this step, then the query times out. The workbench job is executing a stored…
-
Can you use workflows to automatically manage workbench?
Our workbench jobs have a habit of getting hung up when updating making our data fall behind and our end users annoyed. I've already reached out to domo support to help with this issue but in the meantime I have workbench open and I manually update the jobs that miss their scheduled updates. Seeing how this is pretty…
-
Workbench 5 error message when uploading local Excel file...
Attempting to create a job uploading a local excel file using Workbench 5. Getting the error message depicted below… File looks clean to me. There are several formulas in the sheet returning #N/A errors. I've set the below error handling for this. Any ideas what is wrong with the excel file? (I've also tried to upload the…
-
Improve Auth method for SharePoint Connector Plugin via Workbench
We had a problem with the SharePoint plugin for Workbench because it only supports Basic Authentication. In the past, we were connecting to SharePoint just fine but the customer upgraded their authentication method from Basic to Modern and now the jobs we had stopped working. It would be nice for Domo to add the…
-
workbench job - syntax auto fill
Hello In our workbench jobs, we often alias columns and tables with A., B., C., etc. When I type "A." and it autofills to the ADD function, and C. to CASCADE, etc. Does anyone know how to/if you can turn this off?
-
Time change
Hello, currently I am pulling data via an ODBC Connector and pulling through Workbench. What I am finding is, when I query the data locally on the server I am seeing the correct dates, however, when I am pulling it through Domo the datetime is 4 hours behind. How do I correct this? Currently I am in EST time.
-
Incremental refreshes using Domo Workbench
Hi everyone, is it possible to do incremental refreshes using Domo Workbench? I have several datasets with more than 15 or 20 million rows and I'm trying to find a way to only load new data using the Domo Workbench instead of full replace, which is time and resource consuming. I'm using ODBC Connection provider.
-
Workbench Metadata
I would love to have more metadata about my workbench jobs accessible in my Domo instance. A simple thing like being able to filter on "is this a workbench produced dataset" would be a huge thing for Instance Governance. Also having a dashboard to monitor workbench jobs and how they flow through Domo would be great for…
-
Add CSV filename as column
I am running a few workbench jobs, and I need to able to add the file name from each CSV in the folder I'm loading. When you create a workbench job using an xlsx file, you have the option to check a box to add the file name. But for CSV there is no option I can see. Is there a way through calculated columns or any other…
-
Bulk Edit - Additional option for Schema Tab
Under the Bulk Edit feature, would like to see an additional radio button for "Edit Schema settings" For the Schema tab would like to have options for To update the option “Block all Schema changes” to update the check box next to “Protect” (in column header) While upgrading from the older version where these options were…
-
Problems with Workbench, ODBC, MySQL and the data specialist exam
Hi I have a problem with taking this exam: https://learndomo.domo.com/learn/course/383/play/1608/data-specialist-practical-test-2h The task wants you to use Workbench 5 to set up a MySQL job and then import the data from Workbench to Domo. The connection to Domo from Workbench works fine. When I use the parameters for the…