Query Designer and Query Exchange Overview

As an integral part of Spreadsheet Server, Query Designer allows users to build queries which are then used in Excel to seamlessly retrieve critical business data, and return the data for use within a spreadsheet.

When using queries in Spreadsheet Server, three components work in conjunction:

• Query Designer: a visual tool used to design and maintain queries.
• Query Exchange: an online depository of queries used to download selected queries to Query Designer, and then utilize them in Excel.
• Spreadsheet Server Excel Add-In: allows the user to execute the Query Designer queries in a spreadsheet, returning dynamic business data.

Access to each component is based on the licensed features assigned to a user.

Features and Benefits

• Retrieve dynamic data within the company's enterprise databases (including Microsoft Access, DSN system databases, IBM iSeries, Oracle, Salesforce, SAP, and Microsoft SQL Server).
• Build a query using system-provided designer tool.
• Import pre-configured queries from various sources, including insightsoftware's Query Exchange.
• Execute a query on the fly to ensure data is presented as business needs dictate.
• Simple file system for storing and listing queries in a tree structure, similar to Windows Explorer.
• Use data from a spreadsheet as parameters for a query.
• Easily create formulas in spreadsheets using system-provided Formula Builder.
• Perform dynamic calculations with multilevel drill downs to view associated detail.
• Copy and paste drill down data to spreadsheets.