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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 754 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive