-
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…
-
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…
-
How to cancel a scheduled update from an ODBC connection?
Hello! A previous co-worker of mine set up a schedule to update a third-party dataset on a weekly basis using an ODBC connection. Said third-party has now changed variable names and made various changes to the data structure, so I fear that the next data update will fail and dashboards will be left with no data until we…
-
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 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?
-
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…