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 jobs for the SQL Server that will be moving over to that and leave my on-prem Workbench in place for the on-prem data?
Any "gotchas" to look out for? Can the workbench instances run independently with their own jobs, or will they try to synchronize into one?