In Harmoni, you can use data from various file types as the source for new projects, visualizations, and dashboards. Harmoni automatically maps source variables into Harmoni types.
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.
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 supports different direct connections, including Decipher.
In this article
- Connect to Decipher
- Add sources and create your project
- Add new variable types to an existing project
- Append sources
1. Connect to Decipher
To connect to a Decipher source you’ll need to know the server the data resides on, and the 64 character API key of a user that has access to the required source.
- You can find information on how to generate the API key here:
- Before connecting, you can select the variables you want to include in your project: Qualifiers, system and additional variables as well as pipe variables.
2. Add sources and create your project
- Once connected, select the required sources and click ADD.
- The sources will be added to your project. Click OK to create the project.
- Once you add the sources to the project, each variable in Decipher will appear in the project tree using the Harmoni data type that best aligns with the Decipher data type.
3. Add new variable types to an existing project
For an existing project, if you want to incorporate additional variables (i.e. system or pipe).
- Select view/add sources.
- Select Add/Remove.
- This will open the sources area and display the data sources included in your project.
- Choose to CONNECT.
- Click on the three-dot menu to access Edit and then include the desired variable types.
- Once ready select the UPDATE option.
4. Append sources
With Harmoni, you can append data sources. Append allows you to add new variables to respondents or cases within a project when information of common respondents is captured in separate data sources.
It is also possible to append data sources in Decipher. We only recommend this option when the number of sources becomes too difficult to manage (i.e. instead of 200 sources you end up with 400).
- Decipher can only handle about 150 columns at a time. So if your file has more than 150 columns, you’ll need to break it to a smaller file. Each file has to have the “key variable” that you use, e.g. UUID, psid, source, etc.
- You can prepare a clean Excel file (remove all un-needed variable/columns) rather than clicking on little boxes next to each “imported variable” that you need. If you have a clean Excel file, after you pick the “key variable”, you’ll just only need to click on one little box next to the “imported variable”…it’ll automatically select all the variables in there.
- Make sure your Excel variable is free from unusual characters, e.g. #NULL (for no response) when a .sav file saved as an Excel file…those need to be replaced by space.