iQ (Integrated Query Tool)

Launch App

iQ is a very powerful query tool developed by HCI Research Informatics that allows authorized users to create their own queries of data managed by HCI Research Informatics applications.

The tool understands connections between data, the user’s permissions for that data, and pathways that connect the information in the various HCI Research Informatics applications.

Fully integrated with multiple HCI applications and databases (CCR, RSR, itBioPath, Tumor Registry, Foundation Medicine test results, and CORE) for access to critical data from research and clinical systems.

Key Features include:

• Custom Queries – The iQ tool facilitates self-service data requests. It understands the connections between data and users’ permissions to that data. It also includes pathways that connect information from various systems, and it helps users visualize those pathways to explore data repositories and find the data they need.

• Data Integration – User-created queries can span and bring together data from multiple systems and databases. Users can query for most data fields that are available in CORE, itBioPath, CCR, RSR (including any custom data elements), the HCI Tumor Registry, and Foundation Medicine mutation test results.

• Shared Queries – Users can keep custom queries private or make them available to team members when a query might be useful to others. Row level security and scrubbing are applied at runtime based on the permissions of the user running the query, not the person who developed it.

• Results Export – Researchers can export query results from iQ in PDF, HTML, CSV, or Excel formats for further analysis.

• Access Control – The iQ tool works with the complex permissions models of each application with which it interfaces to provide or restrict access to data as appropriate.

Interfaces:

The iQ tool interfaces with the following applications and databases:

• CORE
• itBioPath
• CCR
• RSR
• Foundation Medicine test results
• the HCI Tumor Registry

Requirements

• Google Chrome (latest)
• Microsoft Edge (latest)