-
Overwriting an Existing DataSet with Workbench
In our team, we have a couple of engineers developing in Workbench on different PCs. When I exported a job from one Workbench, imported it to another Workbench on a different PC and ran it, another DataSet with the same name was created. Is there anything I can do to overwrite and update the existing DataSet?
-
Workbench File Updates
IS there a way in Workbench where files can be updated automatically into DOMO without having to change the filename? So for example, I frequently download csv files into a directory, these files have different filenames. Can Workbench identify the latest file in this directory and update it?
-
Workbench | Multiple Accounts in One DOMO Instance
Hi, Is it possible to create multiple accounts to use in Workbench in one instance? This is because we have different permission/rights based on our roles. For example, scenario: We are using one server to upload on premise data - for security and refresh schedule. User 1 has workbench rights and can upload sales data.…
-
Issues after updating to Workbench 5.1
Hello, I recently upgraded to Domo Workbench 5.1. All jobs ran successfully during the first two days of the upgrade, but I am getting the following error. I already restarted the server where domo workbench is located and that worked for about two hours, but the issue came back. Any tips or suggestions.
-
How do I use workbench to Writeback to MS SQL?
Any help would be appreciated
-
Delete User API
We need to remove more than 200 users in our instance and we want to do this in bulk. For that we thought on calling the User API via scripting so it could execute quickly. However, the API is returning an error 400 referring that the user owns datasets and therefore can't be deleted. We already have confirmed that the…
-
Should I really be using UPSERT KEY just to APPEND data?
I have a huge dataset I've uploaded through Workbench. I now want to run a daily APPEND of new data only. I don't see a way to define an "APPEND" key, just an "UPSERT" key. My data won't really change, so I really only need inserts of any records where the defined ID is not already in Domo. My append query looks for a…
-
Workbench 5.1 SDK creates DLL but WB only loads DWP file
Hello, I am hoping WB 5.1 solves the crashes issues I encountered trying to create a transform plugin. However, when I build my plugin in Visual Studio it creates a dll. When I tried to add the plugin into WB 5.1 it will only load a dwp file. Am I missing something simple? Thanks,
-
In Workbench what does "DataSet Type" change?
I have Workbench jobs uploading Microsoft SQL Server tables to Domo. For "DataSet Type", I accepted the default of "Workbench ODBC". After setting up my jobs, I noticed there is a "Microsoft SQL Server" dataset type. What's the difference? In Domo, the icon changes if I upload as a "Microsoft SQL Server" dataset type. If I…
-
Dataset not showing up in Dataset Picker in Workbench 5
We have a user trying to update a dataset in Workbench 5. There was a JSON job file that was left. When we open the JSON file, it is pointing at a different dataset. The dataset we are trying to update does not show up in the Dataset Picker list. The dataset type is excel.
-
How to Connect to a MySQL database using Workbench?
Hi Team, I wanted to know how to connect My SQL database using Workbench. I don't know anything about this process. so detailed steps or screenshots would be helpful to me. Thank you so much in advance.
-
Workbench Job Runtime
Does anyone have any tips or best practices for improving runtime on workbench jobs? We have a job that updates almost 82 million rows of data daily and takes about 3 hours to run. It varies day to day anywhere from 2 hours to 3 hours. I do not have access to workbench as it is controlled by my IT but I am looking for tips…
-
How do I use Workbench to Writeback a dataset to ms sql
😫 I'v been around for while using workbench to upload MS SQL data into DOMO. I heard there is a Writeback ability in workbench. Any help would be appreciated. Thanks
-
Scheduled Workbench Jobs not Running: The communication object, System.ServiceModel.Channels.Service
We have several scheduled Workbench jobs that are extracting data from SQL Server tables and loading to DOMO data sets. The jobs are failing to run at their scheduled times, but I am able to run them manually without issue. They are showing this error: Strangely, only some of our jobs are showing this error. We have other…
-
Domo requests "save" when no modifications
Is anyone else losing their mind (and modifications made when Domo open in duplicate tabs) due to the request to save changes when no modifications have been made to a transform? Screenshot attached.
-
Workbench ODBC - Dynamic query/parameter
When we are establishing a new job in Domo Workbench of the type ODBC, we write the query in the box of Database Query Editor as in the image below. However the query we want to do should not be static and we would like to modify that query based on external triggers. For example, in the image, is it possible to pass a…
-
Re-running a failed job in workbench using automation
We are currently using Domo Workbench to pull in data from various 3rd party property management information systems and this requires a large amount of jobs to be run. The problem comes when one job fails for one reason or another and there seems to be no way to automatically set it to rerun, causing someone to have to go…
-
No embed dashboard option in share dropdown.
I'm wanting to test the embedding option - however my dashboard hasn't the option in the share dropdown. How can I enable this?
-
DOMO Workbench 4 Log Export
We have been having some issues recently with Workbench jobs and I would like to be able to compare the job activity between jobs that were successful and jobs that had errors. I can select only one line on the log at a time and export that (using copy/paste) I was wondering if there was a way that I could export all log…
-
Workbench 5 Crashes w/ custom plugin
Hello Domo Experts, I am having problems trying to create a custom, transform, plugin for Workbench. Workbench 5.0.7: When I use Visual Studio to create a new plugin, with no changes to the default code, and add it to WB, everything is fine until I try to configure the Transforms option. When I do this WB crashes. When I…
-
Its showing me "Live updates are not available" as the status, how do I solve it?
I uninstalled and installed the domo workbench multiple times to try and solve this problem but it seems i cannot get rid of this. I need some help to know why it is happening and how do I solve it.
-
Workbench Job Hanging, Dataset stuck on 'Preparing'
I have a scheduled Workbench job to update a dataset that typically takes 30ish mins to run. The job started yesterday at 1:37pm and has been stuck on 'Preparing..' in the Result field (on the History tab) since then. I just canceled the workbench job and started a new manual run. It started a new run, but the history tab…
-
Automating job creation in Workbench
Hi all, When my company opens new stores, there is a standard practice of creating 4 new particular jobs in Workbench. Am I able to utilize the Workbench SDK to do this? I cannot find any examples of using the SDK for something like this, and would appreciate any help. Thanks!
-
Calling JSON webhook from Browser return 403.
Hi there. I've setup a JSON webhook connector and I'm trying to push data into it from a browser, using Javascript and I keep getting a 403 response. I suspect it's a CORS issues. Has anyone seen and solved something similar?
-
Workbench won't update dataset after reversion.
I hope you guys can help. I had to revert a dataset on the Domo platform because there was an error in excel that broke the data. The reversion worked fine and it went back to an earlier version. HOWEVER, workbench does not realize that the dat has been reverted. so every time I try to update with the new data, it says…
-
Scheduled update of an Excel with date in the title possible ?
Hello all, I need to configure a job that has to be updated every day, but the bad thing is that the Excel file source is an extract from a database that is daily generated with the date of the day in the title (then it means a different title then a different file each day). Do you know if it is possible to let Workbench…
-
Unsupported SQL Functions in Workbench
Is anyone aware of some SQL functions being unsupported in Workbench? I have been using a small query that contains both charindex and substring. When I run it directly against our database in SSMS it works fine, but it seems Workbench is not interpreting correctly. It would be helpful to know if there's a document…
-
WB5 time settings
I was wondering if there is a setting in WB5 that allows you to change the schedule time from UTC to your current business time zone? For example I would need MST. Thank you.
-
Process for using Workbench to read a Sharepoint Excel File
Hi, I'm trying to set up Workbench to read a sharepoint stored excel file. While in sharepoint I am generating a link to the file (which is a web https:// link) but after putting this into Workbench as a "local file" it fails to reach the file. Guidance on what I'm missing in Workbench or Sharepoint to get this working…
-
Workbench query changing column values
I've connected Workbench to my Postgresql DB and using a posgresql function. Workbench is incorrectly displaying the numeric column fields. Postgresql returns as: with the exact same query, domo workbench displays: What is causing workbench to incorrectly display the values? Thanks for the help, Don