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.