-
Convert YYYYMM field to date format
I have a numeric field that is setup YYYYMM that I would like to convert to a date (201812 = 2018-12-01) . This data comes through workbench 5. I can't find a way to change the field to a date in ETL so I wanted to push it in from workbench. I tried a concatenate(Left(Period,4),'-',Right(Period,2),'-',01) so it would look…
-
SQL Training Resources - Oracle Database (JD Edwards)
I'm fairly new to Domo, and am in the middle of implementation. I am connecting to JD Edwards - Oracle via Workbench and need to gain some more SQL knowledge so I don't have to rely so much on our DBA (busy with other projects). Any suggestions for online courses, classroom, or good books on this topic would be greatly…
-
Last 2 years with Workbench
I am trying to pull a table from a database that is really big. So, I would like to only have the last 2 years worth. I have a column that has the order start date, but the format is like this 2005-07-26 14:25:00 -05:00 Was wondering if someone could point me in the right direction with this.
-
workbench 5 error loading data
I successfully upgraded from workbench 4 to 5, with all my scheduled jobs successfully migrated. I have encountered an error loading data into the data source for all jobs. Is this something, anyone has experienced with workbench 5? The scheduled jobs are of a Local File Provider Transport Type and of an Excel Dataset Type…
-
Loading from S3 into Workbench
Hey all, Does anyone have experience connecting Workbench to S3? I'm having trouble figuring out where to put the credentials etc to be able to pull the files. Any thoughts/suggestions?
-
Workbench 5: How to connect to existing Datasets - Type File-Upload
I've upgraded to WB 5 from WB4. I did not have any jobs on WB4 since was facing issues connecting WB to DOMO. After upgrading I am able to create new datasets on DOMO however, I do not see any option to connect to existing datasets on DOMO. These existing Datasets were uploaded using FileUpload Connector (Not Legacy). I…
-
Workbench: Targeting Separate SQL Server Instances (dev, qa, prod)
Hello, I have a Workbench job bringing in data from our on-prem SQL Server setup via a connection builder. This works in production, but I'm wondering if it is possible to target separate (fragmented) instances of SQL Server?Our SQL setup is as follows: dbname01 = production dbname01\dev dbname01\qa When targeting…
-
Workbench 5 Connection String has not been initialized
Putting in the connection string when connecting to a source like OLEDB, more specifically SQL Server, has always seemed finicky but now with Workbench 5 I'm having an even more hard time. I put it in as the whole string at once, it fills in the fields on it's own such as Catalog = , Data Source = , Username =, etc. I hit…
-
Domo WorkBench v5 - DataSet Type Question - Quickbooks
Hello, Experts! So, I have an interesting thing that has been occurring lately since upgrading to WB v5. When creating new jobs in WB for Quickbooks, you would be able to select Transport type: Local File Provider; Reader Type QuickBooks; and DataSet Type Quickbooks. However, the only option that pops up is Workbench…
-
How to mask the data in workbench job ?
-
trying to handove workbenh uploads to someone else - errors
I have been using workbench for several months to update a domo table with some data, with no problems. I need to hand over this piece of work to my agency. I got our contact at the agency to download and autheticate workbench, plus I exported the dataset job and she imported it. However, when she tried to upload the data,…
-
Where did you install Workbench?
New user in planning stages wondering where most have installed workbench? Dedicated server, shared server or workstation? I see it has to be installed on the "C" drive with the O/S and not a "D" drive or other. Build will be virtual and will be interfacing with SQL and Excel. Thanks...
-
WB4 Error executing DataSet Job - Error sending data to Domo
Hello, I have just recently implemented Domo using WB4 on a server. I created a dataset job to extract a table from SQL and upload into the Domo server. Only ETL going on in the query is changing the column headings and using transform to set the timezone. This job is set to load every 15 minutes and for the most part it…
-
Dataset connecting in Domo from workbench but dataset has not been triggered to update
Hi DOJO, I had made a connection from Workbench on 19th Dec and did not put any job schedule. It was set to Manually. However, when I checked the dataset in domo this month, it showed that it is connecting and it has been connecting for days now. Could you please help me understand why is it showing connecting when the job…
-
How to set a schedule in domo workbench to run data set twice in a month on specific days?
-
Appending several datasets in Workbench
Hello Dojo Community! I have 15 different and large datasets that I need to append to create a unique output dataset that I pull into Domo using Workbench (version 4). I would like to know if I can create a single job in Workbench that allows me to append always the same 15 datasets to be able to upload a single dataset…
-
Output/Preview Window
I accidentally closed my output/preview window in my workbench, how do i get it back? I was trying to find an option but didn't see any. Thanks.
-
Is there a way to add unique id or constant to workbench
I am seeking to aggrigate a historic set of data. The problem is the data pull date, a critical peice of identification, is stored in the title of the report - and does not exist in any of the fields. There is no way to identify WHEN in time the data in a row exsisted, or if it differs from the next time that identical row…
-
add domo account
in the add new account section, where do i find my domo server name?
-
Filter out junk data
There is a dataset I import using Workbench, then transform using Magic ETL. The data includes values between 1-10, but sometimes will contain a random junk value like 324568. I'd like to filter out all values that don't fall between 1-10, but can't find a way to do this wihtout specifying every possible junk value, ie.…
-
Automating Multiple Imports
I am very new at using workbench so sorry if this question is too stupid to even consider. Essentially I want to pull a report for a partition of data. For example select * from tables where GroupType = somenumber Instead of creating a new job for every iteration of somenumber I was wondering if I can have Workbench…
-
Last 30 days Workbench / SQL
Hi Domo friends, I want to query data via workbench but the backend table I'm pulling from is unnecessarily big. I want to limit the date from to the last 30 days from the current day and have it replaced every day. My inclination is something like: `select * from 'data_source' where 'day' = {!lastvalue:day!} - 30 but I'm…
-
Workbench Scheduler to Batch Run Jobs
First some background...there are 6 Jobs that I need to run in Workbench every day. The source data becomes available at different times and I need to manually format the sorce files for all 6 before upload, so I can't set a daily time schedule to automatically upload. The last of the 6 uploads triggers an ETL to run, so…
-
WB Custom Date Format to working for 20180704130000 format
Hi I am unable to get the following format date 20180704130000 (or 2018/07/04 13:00:00) using the workbench data transform. As I see it the Date Format I should use would be yyyyMMddHHmmss Schema for the filed is set to STRING as suggest in the topic below. I had a look at the following dojo topic and article but I still…
-
Port number used for workbench to upload data to the domo cloud
Can I know the port number used for workbench to upload data to the domo? We have own internet server and need to configure the network port just in case it got blocked
-
Where do I go to install Workbench?
In your instance of DOMO click on the following: * Click on the Arrow Menu * Click on Admin * Click on Tool Downloads * Click on Download Domo Workbench
-
Workbench Error
I began receiving the error over the weekend while trying to execute workbench jobs that have historically ran successfully. The error message "DomoApi.Exceptions.IndexingFailedException" did not help point in a direction for fixing the issue. Have anyone run into this before?
-
Export All Workbench Jobs?
Is there a way to export all of our workbench jobs to make a copy/backup as a failsafe in case our workbench server goes kaput? I see how to do one at a time. Maybe I'm just not seeing the option?
-
How do I to get the Watch File function to work?
I seems pretty straight forward, select "Watch File" instead of schedule update every 15 min or something else, but I have tried it with some 40 jobs and not a single one job has ever updated automatically that way. Even after a couple of days an several cahnges to the files it never works. All our files are on our server…
-
Upgrading to Workbench 4
Hello, We want to let you know that Workbench version 2 and 3 will be discontinued on April 28. Any jobs still running on Workbench 2 and 3 will need to be upgraded to the latest version of Workbench to continue running. This comes with some added benefits and significant improvements in the UI experience. What happens if…