Introducing the revolutionary
Database Explorer
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.
Schema-Editor
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.
Dashboard
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!
