Introducing the revolutionary
With Database Explorer you can easy administrateanalyseconfiguratedevelop IBM® Informix® Dynamic Server and HCL OneDB
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!