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 go with one or the other, am I limiting what I can do within Domo now, or perhaps down the road if I ever end up doing 'writebacks' into our local databases?
Answers
-
It is really just for display purposes in Domo as you have noticed. It would have nothing to do with Writebacks because you don't use Workbench for writebacks. It is just there to make it easier for you to identify your workbench jobs.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Thanks. That makes sense. However, it's a little concerning that Workbench doesn't let you change the dataset type on existing jobs.
Perhaps I'll just use SQL Server type going forward, and leave the existing ones as is.
1 -
@MarkSnodgrass is getting too quick! As he said it's mostly for display purposes but it's also useful for helping to classify the type of dataset it is or where it came from - from a metadata aspect. If you only have SQL server then there really isn't much of a difference but can be helpful if you're using multiple database types.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive