Data Integration and Migration

Find all the tools and resources you need to support data integration and migration projects within Clarity Human Services.

Data Import Tool

  • Exporting HUD CSV & XML Data

    This article covers the process of exporting HUD HMIS CSV and XML data from Clarity. Exporting data from the Clarity system is accomplished using the [HUDX-111] HUD CSV / XML Program Data Export report available in the reporting area.  The exported data is formatted in HUD CSV or XML.  For more information on the specifications of these data formats, review the HMIS Data Exchange Resources. Accessing the Export To...

    label_outline HUD XML label_outline XML label_outline Export label_outline HUD CSV label_outline HUDX-111
  • Importing Data Using the Data Import Tool (DIT)

    This article walks the user through the steps of importing a file using the Data Import Tool (DIT). For a high level walkthrough of the Data Import Tool, including settings and descriptions of the various screens, please review the Introduction to Using the Data Import Tool article. Performing an Import The Clarity Data Import Tool (DIT) will accept data in the 6.1 version of HMIS CSV or XML.  For further document...

    label_outline XML label_outline DIT label_outline Validation label_outline CSV label_outline Imports label_outline Mapping label_outline Data Integration
  • Introduction to Using the Data Import Tool (DIT)

    This article explains how to access and configure the Clarity Data Import Tool (DIT). Accessing the Data Import Tool To access the Data Import Tool (DIT), your Clarity user account must be assigned a role that has been configured to allow access.  To use the DIT for importing data, click the Launchpad icon  and select Data Import.   Advanced Options Once the user has accessed the Data Import Tool, there are a num...

    label_outline For Agency Managers label_outline For System Administrators label_outline Publish label_outline XML label_outline Import label_outline DIT label_outline Client Matching label_outline Custom Fields label_outline Validation label_outline Rejected Clients label_outline CSV


  • XML API Page

    Welcome to our RESTful XML API Import tool. This tool has been developed to allow importing of household information, client demographics, program participation, and service transactions. The HUD XML 6.1 Schema Documentation can be found at: Additional Resources can be found at:  HMIS XML Schema Overview (pdf)

Data Schema

  • Data Schema

    Welcome to the Clarity Human Services Data Schema Information Page. Clarity – Customer Data Model Table Names clarity_clients clarity_client_service_programs clarity_client_demographics clarity_agencies clarity_client_data clarity_programs clarity_client_programs clarity_program_funding_sources clarity_client_program_demographics clarity_services clarity_client_program_data cla...

    label_outline Schema label_outline Table label_outline Data Model label_outline XML label_outline Import label_outline Foreign Key label_outline Primary Key