With Database Explorer you can easy  administrateanalyseconfiguratedevelop  IBM® Informix® Dynamic Server and HCL OneDB

General informations

Build from scratch

Over the years we have developed multiple applications for and around Informix® as well as other databases. In 2019 we leveraged our expertise to develop a completely new application focusing on stability, speed and functionality.

Supported servers

The current Database Explorer supports IBM® Informix® Dynamic Server 11.70, 12.10 and 14.10 in all editions as well as experimental support for HCL OneDB. Some functions require DBA access to the database server.

Supported Platforms

We opted to build a native Microsoft® Windows® 10+ application adhering to today's Office standard. At the moment there are no plans for a Linux, MacOS or web-based port of the software.

32 and 64 bit support

There are still many 32-bit applications requiring the 32-bit version of IBM® Informix® Client SDK. We offer the appropriate Database Explorer version for both architectures.

Direct connection - no ODBC

Connection to the database server requires the IBM® Informix® Client SDK. This enables us to achieve enormous compatibility and maximum speed when communicating with the database server.

The learning effect

Many actions which modify the database display the underlying query to be executed teaching the user how to compose future SQL queries.

Managing databases

The various managers allow the user to access the database for processing, analysis or troubleshooting at many points. The SQL tracer quickly finds the bottlenecks that make life difficult.

Powerful SQL-Editor

The heart of the software is the SQL editor with auto-completion, code highlighting, and visual SQL designer. The universal data record display leaves nothing to be desired for analysis and offers multiple export options.


Visualizing the entire database with DDL and refactoring has never been easier. Even for the novice user, changes to the database schema are no longer a problem.


The starting point for everything

The dashboard with its database schema offers a quick overview of the database structure and its data allowing quick access to all database objects. The user has the option of displaying and editing all database objects. To quickly see the contents of a table, the first 100 rows are displayed.

Thus, the user can quickly jump through the individual tables, indices, etc.

Server Manager

The server ... always keep an eye on it

Regardless of whether it is about memory consumption, current utilization, weak points and problems or other analyses, the user will find answers to all questions in the server manager.

Databases, DB spaces, sessions, logical logs, current locks and much more can be found in the overview.

Database Manager

My Database ... what is the current status?

What tables are in a database, how much space do they need? How often are they sequentially read? Which indices are unused? You will receive an answer to these and many other questions on demand in the future.

Search database-wide for columns, check user rights or look at the distribution of data in the individual DB spaces and chunks.

Table Manager

Table ... here is my data!

At the table level, you can view, edit, analyze, filter and export the contents. Check in detail all objects and parameters. Navigate, filter and search millions of records at breathtaking speed.

Use the drill up/down functionality to navigate between tables.

SQL Editor

The attention to detail will make our editor your favorite tool!

Auto-completion and syntax highlighting are part of every good editor these days, but we wanted more.

The SQL designer provides guidance to even inexperienced users: data is displayed in real time, tabs-based results make everything clear, and index-based templates save time. Save all queries from the dashboard to be reused in future sessions.

Try something like SELECT INTO TEMP and you will love our editor.

Data Viewer

You can do more than just display data!

Anyone can display data in a list, but we make it beautiful and convenient with the user determining how data should be displayed. Each record can be viewed as a searchable list. Each data cell can be displayed as text, in a hex viewer, and as an image or PDF. All blob data is temporarily stored on disk and not in memory.

And if you want to save the content, that's also possible.

Data Exports

What do you do with all the data?

Users can process data directly within the application via the integrated modules analyzer, script generator, spreadsheet or datacube. Users can also make the data available to other applications via export to XLSX, CSV, XML, HTML, DOCX, RTF, PDF, TEXT, SQLdump and much more.

Our XLSX export is blazing fast. Just test it.

Code Generator

Better code when using code generators

With the code generator you can quickly create data classes for your own applications using pascal script. Anyone who has recognized the advantage of such a generator will learn to love it and use it again and again.

All source code for the system tables data classes are generated with our code generator to be used in Database Explorer.

SQL Tracer

Find the speed robbers!

Regardless of whether you want to analyze your own query or the current live access to the database server, you can use the SQL tracer to quickly and reliably see what is happening and where bottlenecks exist. Analyze a complete transaction, what is happening there, and how long each step takes.

But don't forget to disable the tracer or it will become the speed robber!