What dataset type should I choose in workbench?

scboyce
scboyce Member
in Archive

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

  • AS
    AS Coach

    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"
  • Unknown
    Unknown

    @scboyce, did @AS's reply help you out?

This discussion has been closed.

Categories