Explore your data from anywhere

Build sophisticated database queries for Web publication in less time without coding SQL and all you need is a browser.

aXes Remote DB2 Query Tool

aXes SQL Query tool allows you to create queries with the select wizard as your guide.

The aXes Data Explorer is a remote DB2 SQL query tool that allows you to build and run queries against IBM i, System i, iSeries or AS/400 DB2/400 databases from a browser. You can query DB2 tables, print the query results and/or copy the query results into business applications like Microsoft Excel. If you wish to retain the query, the query can be saved and recalled for use later.

Building queries requires no knowledge or experience with SQL. You can build a query via a "point and click" wizard in the query builder. Experienced users have the option to write or extend the SQL code.

The notable features are:

  • Create and build queries
  • Save queries
  • Publish information (query reports) on the Web
  • Integrate query results with business applications like Excel and Word
  • Query results accessible from anywhere
  • Zero deployment – nothing to download or install on the client PC

Create and build queries

The Data Explorer is a DB2 query tool to create distributed SQL database queries for DB2 databases and any accessible data sources from a browser.

Building queries requires no knowledge of, or experience with SQL. You can build a query via a "point and click" wizard in the query builder. Display the list of tables (or files) in the database, choose the columns (or fields), add the selection filters and the Data Explorer generates the SQL code that will retrieve the data from the database. Experienced users have the option to extend the SQL code or write the SQL code from scratch.

Save queries

You may want to use the same query multiple times so the Data Explorer provides a place to save your queries. To run the query again, all you need to do is call up the saved query and run it.

Saving the queries provides a way to distribute information to customers on the Web. The customer can load a saved query, set the selection filters and run the query.

Save or print query data

Query results can be saved or printed locally on your PC or anywhere in a network.

Publish queries on the Web

The Data Explorer provides the power to deliver real-time query results in a Web page to any authorized user anywhere and at any time.

The Data Explorer runs the query and builds a Web page to display the query results. This is an easy way to publish reports on your Web site - just launch saved queries from any Web page with a standard URL reference. Publishing information with the Data Explorer removes the need to build specific Web pages for each report, improving access to information and ensuring the timeliness of information for people who use the query.

aXes SQL Query displays the results from the query in a Web page with options to download as text or XML.
aXes DB2 Query Tool displays the results from the query in a Web page with options to download as text or XML.

Integrate query results with business applications

Query results can be easily integrated with business applications such as Microsoft Word and Excel without writing macros – copy and paste the information from the Web page into the business application. Now you can use tools like Excel to analyse the data created by the query and you have complete control over its presentation.

Queries results accessible from anywhere

Your staff, customers, suppliers and partners can use the queries over the Internet making the information available to them from anywhere. Distributing queries on the Web provides information to customers, suppliers and partners on a self-services basis - reducing calls to your customer service staff.

Zero deployment – nothing to download or install

Zero deployment means no installation, no configuration and no need to download ActiveX components to the browser.