This article is an orphan, as no other articles link to it. Please introduce links to this page from related articles. (September 2010)

ABIS-Query
Developer	BOS-Software
Stable release	1.4 / September 21, 2010
Operating system	Microsoft Windows
Type	Software
Website	abis-query.com

ABIS-Query (AQ) is a Microsoft Windows based SQL query builder and SQL script designer software tool used to administer and execute queries against the most common database systems. ABIS-Query is created by a small Switzerland software company, BOS-Software, and is distributed and supported through the Internet. AQ is designed for use by database administrators, developers and advanced end-user.

AQ is a Windows C# application base on a modern and intuitive GUI that use several integrated connectors to the most popular databases or ODBC drivers to access the databases. AQ directly queries the catalog meta data of well known data base management systems, which makes it very fast for exploring the data structures of enterprise size data bases.

Data Base Management Systems of which AQ is aware of the catalog structure include Oracle, Microsoft SQL Server, Postgres and MySQL.

There are two levels of licensing of ABIS-Query: the 30 days trial version and the Registred License, both allows full functionality.

SAP, Oracle, Microsoft SQL Server, Postgres, Firebird, MySQL, Microsoft Access, Adavantage Database and ODBC

The database explorer panel allows the user to display information about the data base objects in that data base. There is a filter box to search an object into the database. The [Drag and Drop] function is used to automatically create a SQL block with a SELECT instruction. AQ allows to open a data selection view from a table or a view into a popup windows with advanced filtering capabilities.

The SQL editor is a coloured sql syntaxer for easy viewing and editing the script. It allows to write some sequential scprit block, which will be transmited to the core SQL in one block or in sequential mode. AQ allows to manupulate the results directly in memory to define a link between the results tables or apply a "where" instruction without change the initial sql script block.

In addition to simply displaying the results of a query, the data window allows data's sorting, using aggregate function and advanced filtering. The query results can also be exported to various file formats including MS-Excel spreadsheets, CSV files, XML and XSD files.

The GUI Query Builder allows building SQL queries with point and click simplicity, which is handy for novice SQL programmers.

AQ includes a data loader tool that makes it easy to load data into tables from Excel spreadsheet sources.

AQ allows creation and execution of scripts with some amazing extended capabilities, the scripts can be saved in specific files and into the AQ's library.

When a script is saved into the library, the user can directly run this script from the library area without loading it previously. As a runtime mode.

AQ was created by ERP, BI and DBA specialits from Switzerland. ABIS-Query is a subset of a Business Intelligence solution owner. This BI solution is named ABIS (Advanced Business Intelligence Software). AQ has been created to facilitate the work of extracting and consolidating data for their use for analysis. AQ is for developers, for database administrators, for advanced end users and for final end user in runtime mode.

• Official Web Site
• Editor Web Site
• Comparison of database tools

Category:Database administration tools