Intelligent Query Architect (IQA)

Important!
Poorly written queries can cause performance issues in iMIS.
Before starting to work with queries in the Intelligent Query Architect, review the Best practices for writing IQA queries.

Intelligent Query Architect is a query-building tool that extracts data from the iMIS database. It simplifies query-building tasks by providing a user-friendly interface that enables a user with limited SQL experience to build queries and reports.

Key features

  • Design a query once and use it throughout the iMIS system.
  • Copy and combine existing queries to define new queries.
  • Use query results for real-time, searchable and sortable displays of information online such as member directories, committee rosters, upcoming events and more.
  • Use query results to build real-time dashboard reports.
  • Combine query results with report formats in Microsoft SQL Server Reporting Services (SSRS) to create, access, modify and share reports.
  • Allow non-technical users to run queries to build marketing lists.
  • Allow non-technical users to sort results on any fields in the query.
  • Allow non-technical users to export query results to a variety of file formats, including CVS, XML, PDF, Microsoft Excel or Microsoft Word.