What dataset type should I choose in workbench?
When creating a Dataset Job in Workbench 4.0, It asks for a Dataset Type, such as CSV, Excel, ODBC, Jira etc.
I have discovered that this choice has no bearing on the source data format. For example, I have been able to import the same JSON formatted text file as CSV, Excel, ODBC and Jira DataSet types. The only differnce seems to be what it looks like in Domo. The Icon and text below my DataSet name are the only aparent differences.
Does the DataSet Type matter?
Does one DataSet Type have advantages over another?
The DataSet Type called "Generic ODBC" seems strange since ODBC is an access protocol, not a data format.
Are DataSet Types just a way to document where the data came from? If so, why is there no Json DataSetType?
Comments
-
That configuration option only helps with the organization of the data in your datacenter and the datawarehouse. It helps Domo pick datacenter logos and sets metadata but doesn't affect the underlying schema.
Generic ODBC might be shorthand for any kind of structured database like an internal mySQL server connection, Access, etc.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive