NRG Global Availibility Monitoring and Performance Management Products and Services
  Buy Now
myNRG Login System Administration and Quality Assurance Tools Consulting, Training, Custom Development Support Download Performance Management / Load Testing Products About NRG (877) 398-9537
database tool, JDBC, Monitoring Unix, Windows, AIX, HP, AS400, Linux
Products: DBVisualizer

Chroniker Overview
Chroniker Suite
SystemWatch
AppsWatch for monitoring response time of your critical applications,Citrix
Pureload for Load Testing
DbVisualizer - Free DB Tool
Download Full Version
Features and Benefits
Requirements
FAQ
Download Walkthroughs

Untitled Document

Get Updates on
Performance Management


Privacy Policy

DbVisualizer Screen Shots


The following screen shots shows some of the features in DbVisualizer. These shows both DbVisualizer Free and DbVisualizer Personal features. Please check the features page for the exact content of each edition.

Driver Manager
DbVisualizer - Driver Manager This Driver Manager dialog is used to setup the path (aka CLASSPATH) that DbVisualizer use to load drivers from. Simply open the load dialog and select the root of a driver which can either be a directory, ZIP or JAR file. The Driver Manager identifies all files that are JDBC Drivers and JNDI Initial Context classes. The type of class that a particular file represents is indicated with an icon. (There is no need to explicitly setup the CLASSPATH outside DbVisualizer in order to identify drivers. Just use the Driver Manager!)
Database Objects Explorer
DbVisualizer - Database Objects The Database Objects tree lists all the registered Databases and their objects. The content of each connected database is examined by opening the nodes in the tree. Selecting an object will display object type specific information in the right part of the tool. Filters can be used to mimimize the amount of unwanted objects in the tree. Database Connections can in addition be structured into Folder objects to simplify the view even more. 		Tool Properties
DbVisualizer - Tool Properties The Tool Properties dialog consist of more then 40 different properties that are used to configure DbVisualizer. All properties are saved between invocations of DbVisualizer.
Table Information
DbVisualizer - Table Data Viewing tables is probably the most common task in the Database Objects tree. This view displays various information about the selected table as well as the data in it. The screen shot shows the Table Filtering capability which is used to specify a filter criteria for the rows that shall be displayed. The right-click menu in the grid lists some additional operations that are used to create SQL commands that will pass the generated SQL to the SQL Commander. 		References Graph
DbVisualizer - References Graph This screenshot shows the References tab which illustrates relationships (i.e. 'referential integrity' or 'primary-foreign key' mappings) between the tables. The References display can be viewed for Database Connection, Catalog or Schema levels. Note: The actual database must support referential integrity in order for the 'References' view to display relations. The content of the nodes that appear in the graph can be set to either list the name of the table, name + primary keys or name + all columns. Double clicking on a table node will launch the Table explorer in a separate window. The graph is automatically rendered by 4 different layout algorithms: >Organic >Circular >Hierarchic >Orthogonal
SQL Commander Editor
DbVisualizer - SQL Commander Editor The SQL Commander editor is used to execute any SQL statement or script of statements (DbVisualizer Personal). It supports syntax coloring and the standard editor operations. DbVisualizer Personal do in addition support multiple editors either organized as tabs or windows 		SQL Commander (result Windows)
DbVisualizer - SQL Commander The SQL Commander is used to execute arbitrary SQL statements. The editor is keyword colored and executed statements are automatically saved as History statements in the Bookmark Editor. This screen shot shows DbVisualizer Personal and the support for multi selection SQL execution. In this example are the result of the executed select's are displayed as windows. The SQL Commander in DbVisualizer Personal do also support multiple result sets returned from a single SQL statement and support to execute anonymous SQL blocks.
SQL Commander (result Tabs)
DbVisualizer - SQL Commander Log The SQL Commander is used to execute arbitrary SQL statements. The editor is keyword colored and executed statements are automatically saved as History statements in the Bookmark Editor. This screen shot shows DbVisualizer Personal and the support for multi selection SQL execution. In this example are the result of the executed select's are displayed as tabs. The SQL Commander in DbVisualizer Personal do also support multiple result sets returned from a single SQL statement and support to execute anonymous SQL blocks. 		SQL Commander Log
DbVisualizer - SQL Commander Log The SQL Commander log keeps an entry for each SQL statement that has been executed in the SQL Commander. There are various options to control what shall appear in the log.
Table/Index Creator
DbVisualizer - Table/Index Creator The Create Table/Index Assistants are used to generate the SQL that is used to create either a table or an index. The generated SQL is then executed in the SQL Commander. 		Charts
DbVisualizer - Charts The Monitor feature is used to easily execute one or several SQL statements that returns a result set. The statements that shall appear in the Monitor tab are enabled in the bookmarks editor. The result sets of these monitored SQL statements can either be defined to appear in a grid style or as charts (DbVisualizer Personal). Charts in combination with the auto reload feature gives a true monitor view of the executed statements.
Inline Editor
DbVisualizer - Inline Editor The inline editor (DbVisualizer Personal) is used to make manipulations of data directly in the Data tab grid. To edit an existing column value of a row, just select it and start typing. All edited fields are colored in yellow to indicate that only these will be updated once the edit is commited. A data type popup menu can be opened once a cell is being edited. To commit an edit just select another row or explicitly press the commit button in the Data tab toolbar. A new row can be inserted using the Insert Row in the Data tab toolbar as well can a row be deleted by using the Delete row toolbar button. 		Form Editor
DbVisualizer - Form Editor The form editor is used to manipulate row data in a form view. This is a convinient presentation since it is easier to get an overview of the values. The form editor is launched using the Data tab toolbar buttons or by double clicking on a row number in the Data tab.
Bookmark Editor
DbVisualizer - Bookmarks Editor SQL Statements that are editied and tested in the SQL Commander can easily be saved as SQL bookmarks using the Bookmark Editor. The editor manages all bookmarks in a tree structure which makes it easy to categorize them. The SQL can be export and imported from the file system. The bookmark editor is also used to specify any SQL statements that shall appear in the Monitor main tab. 		Export
DbVisualizer - Export The Export feature supports exporting any of: Grid (text data), Graph, Chart (DbVisualizer Personal), The image exporters are used to export to graph or charts into JPG, GIF or PNG formats. The Grid exporter (shown in the screenshot) can export data to several output formats. The destination for the output can be file, system clipboard or the SQL Commander. The export functionality in DbVisualizer Personal can in addition be used to generate test data using pre-defined data generators. This is very powerful in order to add test data to a database table.
   

Home | Products | Services | Support | Site Map | Downloads | Contact Us

Copyright © 2008 NRG Global. All rights reserved worldwide.