Workbench: Targeting Separate SQL Server Instances (dev, qa, prod)

owen_geoghegan
Member
in Workbench
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
dbname01 = production
dbname01\dev
dbname01\qa
When targeting production, the job completes without issue. When attempting to target another instance, the job completes without issue, but still brings in production data (which it should not). When inspecting further, even when the connection string has been altered to target dbname01\dev or dbname01\qa, workbench ignores the modification and still targets the production instance.
Does anyone have experience with this, or a similar issue that may provide helpful insight? Your help is appreciated!
0
Comments
-
So using the connection builder won't work for some reason, however you can use the Connection String connection type and that will allow for slashes to be properly parsed in the server name.
Example:
Driver={SQL Server};Server=TestServer\dev;Database=TestDatabase
0
This discussion has been closed.
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive