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.
**Make sure toany 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
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有