IB LogManagertm Product Family
Introduction
The IB LogManager Product Family is a suite of tools which helps you to keep track of data changes in your InterBase® and Firebirdtm database.
But, it's more than simply integrating a logging/auditing mechanism in your InterBase® and Firebirdtm database, because the available add-on's will help you to manage and to process log data in different ways.
Key Features
Below is a list of key features for IB LogManager.
Your version of InterBase and Firebird is supported
The IB Logmanager Product Family supports InterBase version 5 and up and Firebird version 1 and up
Server-side mechanism avoids application changes
- No need to change existing applications
- Log data-changes for third-party applications
Controlled and extensive auditing
- Table operation based auditing
- Audit certain columns only
- BLOBs are supported too
- User defined conditional auditing
Viewable results
You and your users (or database administrators) can browse, export and print the logged data changes.
Add-on tools
- IBLMExport: command line utility to export logged data
- IBLMPump: Command-line utility to pump/transfer logged data
- IBLMRedo: Wizard driven roll-forward log utility
- IBLMUndo: Wizard driven roll-back log utility
Products & Tools in the Family
The IB LogManager Product Family currently consists of the following products/tools:
- IB LogManager:The core product to integrate a server-side logging/auditing mechanism in your InterBase/Firebird database. IB LogManager logs data changes in the database for different data manipulation operations (Delete/Insert/Update) on user-definable database objects (tables, columns). A point-and-click interface enables you to define easily, which database objects should be logged. If you are interested in logging a history of price changes in a table ARTICLE, just define it with one mouse-click and relax.
- IBLMViewer: A read-only version of IB LogManager, that uses the existing logging schema. Ideal for users who should be able to browse and export log data, but without the permission to change the logging schema.
- IBLMExport: A command-line utility to export logged data into different file formats (e.g. Excel, Winword, HTML, XML). You can schedule the export process by using any task scheduling facility like 'AT' under Windows NT/2000/XP.
Read more... - IBLMPump: A command-line utility to pump/transfer logged data from the production database into an external "transaction log" database using the two phase commit (2PC) protocol. By using IBLMPump regularly, you keep your production database tight (logged data will not "pollute" your production database) and in case of a crash of your production database, logged data will not be lost. To regularly pump logged data you can either schedule the pump process by using any task scheduling facility like 'AT' under Windows NT/2000/XP or by using the background pumping option (timer or InterBase®/Firebird event based) of IBLMPump.
Read more... - IBLMRedo: A utility with a wizard driven graphical user interface to apply logs in a source (external "transaction log") database on a destination database, either to recover (roll-forward log) a production database from a workable operating system backup by applying all logged operations and column values or to manually replicate (one-way; unidirectional) one master database with many slave databases.
Read more... - IBLMUndo: A utility with a wizard driven graphical user interface to undo logged data manipulation operations to a specific point in time. Currently in Beta and only available for registered customers. More is coming soon. Stay tuned.