-
for loop in Large amount of Data in Workbench.
Hello all, I'm tiring to pull large amount of data via Workbench, previously this was done with SSIS for loop container pulling only fraction of the time frame data at a time, and appending the results. is there way to achieve this in workbench as I'm not able to find the proper documentation.
-
User is not member of 'Domo Workbench Users' group
We're getting this error User is not member of 'Domo Workbench Users' group Is this something new with workbench? How can we fix this? We're trying to import a backup file. Thank you
-
Workbench Using File Name in Calculated Field Transform
I am connecting to an FTP in DOMO Workbench 5 and wanted to use the Calculated Field transforms. I want to find a way to create a column with the last 8 digits of my file name as I want to include the date. For example, my file is named "File Name 10172023.xlsx" I want this calculated field to create a column showing…
-
Using Workbench Writeback to MS SQL Server
We're trying to writeback data to our MS SQL Server using workbench. We follow the instructions provided here: but we consistently get the same error. [09.29.23 6:45:49 PM] Determining execution parameters [09.29.23 6:45:58 PM] Starting execution of job sql3 WBK | Macola | CICIMPY to Domo DataSet [09.29.23 6:45:58 PM]…
-
Alert or Periodic Email to Customers on Obsolete/ Corrupted/ Harmonization of Domo Apps/ Connectors
Is it possible if Domo can email/ alert clients that are using certain connectors or apps that would get out-dated/ corrupted etc with recommendation from Domo on next steps? Regardless, if the client is on standard, gold or platinum support, these would be helpful for everyone. What we need is proactive communication from…
-
Notify & Not Auto Update Workbench
There have been multiple cases where customers are unable to auto update workbench due to IT policies in updating applications. Having the option to enable notifications for when a new update is available but not auto update would be beneficial for customers to know when new updates have been released allowing them to plan…
-
Workbench with impersonation configuration
I'm setting up an ODBC SQL Server connection with Windows Authentication but it's not working. I am included in the Domo Workbench User group Am I missing any configuration?
-
Date change in workbench
Hi, I am using Domo workbench. When i run a data feed with a query the time seems to change when I see the data on the webpage. So for example, when I run a query and put it in workbench it is saying July 01st 00:00, however, when I look at the data on the data page it says June 31st 08:00. There is a 5 hour difference. I…
-
Microsoft access ODBC
Hi Experts , I am trying to create an ODBC connection for connecting to MS Access . Please someone can assist me in letting me what should be given in the connection parameters .Domo doesn't provide any help files for this .Attaching the screenshot .
-
SQL partition password reset
Hi - I put in a help ticket without success so far. We are using a SQL partitions connector to bring in accounting data. Following an apparent password reset on database access, some of the datasets continued to work while some larger datasets stopped working but continued to bring in blank lines of data. I reset my…
-
Domo Workbench 5: Unable to Query Provider Types
Hello folks, We use Quickbooks Desktop 22 (queue eye roll) and use Domo WB to connect to the network files and send data over to Domo. I have been seeing this error alot lately. Has anyone ever specifically ran into this type of error and if so what did you do to resolve it? [INFO] [3532:12] 2023-05-18 00:03:30,774 -…
-
For those using Domo Workbench with Quickbooks Enterprise, how do you deal with modal dialog boxes?
Intuit login, errors pertaining to the qbsdklog.txt file, etc…we are getting multiple errors every single day which hang up all of our Workbench jobs. How does everyone else deal with these? We have implemented a Power Automate script on our servers housing our Workbench jobs, but some of the dialog boxes, particularly the…
-
GLOBAL on success/failure notification rather than each individual dataset
Just wanted to ask if there was a way to set a GLOBAL on failure notification in workbench? Rather than having to check off the box for the specific email on each individual dataset in workbench.
-
Using partitioning in ETL or Workbench
Good afternoon. Typically, to not do full replaces of data pulls into Domo from our databases, we have used recursive dataflows with ETL. I am trying to think of a way of accomplishing this using the partitioning features in ETL and/or workbench to avoid the ETL still having to process the whole set of updated+historical.…
-
Ability to Run DOMO Workbench in Docker
I would like the ability to run DOMO workbench in a docker container.
-
Removing Java components
Does Workbench installation rely on Java to function? I ask becuase my company is requesting to remove any and al Java components from our VMs where we are hosting our Workbench application. Would getting rid of Java screw up Workbench?
-
Are there any workbench reports available to show configurations for all jobs?
Is it possible to get a list of all directories and files used by Work Bench without having to go through each job one by one? My colleagues and I are working to clean up our workbench instance. One of the issues we've run into is that the jobs are pulling from personal folders that we don't always have the permissions to…
-
Transaction Deadlock workbench error
Good morning. I am curious if anyone has had this error before. One of our workbench jobs has been getting it more and more. I don't know if it is a domo workbench issue, or if it is an issue on the database side where we query the workbench job from Error 40001 Microsoft ODBC SQL Server Driver SQL Server Transaction was…
-
Scheduled job fails to run when DOMO dataset is deleted
I've set up a job in DOMO workbench to pull data from SQL Server and upload it to DOMO instance. Below are the details: Job Details Transport Type: MS SQL ODBC Data Provider Reader Type: Database Query DOMO Details Dataset Name: test_schedule Dataset Type: Workbench ODBC I'm just using a normal select * from <table> as…