Output Queries
NOTE: This feature is compatible with SQL Server, MySQL, and xmpSQL output formats only. See Reporting for more information.
Aurora provides the capability to create and use SQL (Standard Query Language) queries to construct custom output tables. For very large output tables, use of SQL queries will be much faster and consume significantly less memory than the standard load and filter logic used in prior versions of Aurora. These queries make access and use of output tables holding potentially millions of output records feasible.
The query construction capability is implemented through an easy to use point-and-click window, and for those familiar with SQL, an ability to directly edit the queries is also provided. Additionally, the functionality to join records from multiple tables is provided. In combination with the ability to write the input tables to the output database, this provides the ability to join records from input tables with output tables, providing a high degree of flexibility and customization.
SQL queries can be used with either Microsoft SQL Server, MySQL, or the embedded xmpSQL output database formats. They cannot be used with zipped XML, or XML output formats. See Reporting for more information on specifying the output format used by Aurora.
NOTE: Queries and joins previously created in Aurora for use with SQL or mySQL will not work with xmpSQL. They will need to be recreated or modified for each type of SQL and they are generally not interchangeable except for the most basic of queries. This is because the different types of SQL (MySQL, SQL Server, xmpSQL) each have their own syntax so queries or joins created while one type of database output is active will not work with another database output type.
The steps to create and use queries are slightly different depending on whether the query applies to a single or multiple tables. Select one of the following topics for more information:
-
Aurora Output DB Query Builder - create queries for a single output table.
-
Multiple Table Queries - create queries for multiple output tables.
-
Editing and Saving Queries - make changes to existing queries.
-
Including Inputs in Queries - include input data in output queries.
-
Creating Indexes For Queries - create indexes for joined queries.
Productivity Tools
