Skip to main content

Supported data sources

  • Updated
    Tags:
  • Project Owner
  • Creator

A data source is the starting point for all you do in Harmoni. A source is a collection of data either in an imported file or a connected data store.


IHTip_icon_warning.png

A project contains one or more data sources.

 

Harmoni can use sources in any language, including languages requiring multi-byte storage (e.g., traditional Chinese).

Harmoni automatically maps source variables into Harmoni types when data sources contain an inherent dictionary. A dictionary contains meta-data to guide interpretation. Variables in sources without an inherent dictionary need to be defined. 

 

In this article

  1. Imported data sources
  2. Direct Connections (APIs)

1. Imported into Harmoni (Upload)

Imported or uploaded files capture data for a moment in time. 

 

Source Type Description Source Dictionary

SPSS data

  • SPSS.sav format.

  • Can be generated from a variety of data collection applications.

  • Typically contain record-level data
    with a record representing a respondent.

 Contains an inherent source dictionary

Excel files

  • XLSX – Excel files. 

  • Primarily created from Excel in Office 2007+.

  • Files must be XLXS.

 Needs to be defined

Comma-delimited

  • CSV files.

  • Can be generated from a variety of systems.

  • Do not have market research-specific structures.

 Needs to be defined

Tab-delimited

  • TXT files.

  • Can be generated from a variety of systems.

  • Do not have market research-specific structures.

 Needs to be defined

Dimensions data

  • Dimensions .mdd and .ddf format.

  • Typically created by Dimensions. 

  • Typically contain record-level data
    with a record representing a respondent.

 Contains an inherent source dictionary

 

 

2. Direct Connections to Harmoni (Connect)

Direct connections allow updated data to flow into Harmoni in real time.

      • Achieved using APIs (Application Programming Interface).
      • If an API is available in a data collection system, we can potentially develop a direct connection to Harmoni.

Harmoni currently supports direct connections to:

 

DirectConnection_17Nov23.png

 

Where to from here?

Up_Arrow.png

Related to

Related articles