Database Manager
Up Overview Guided Tour I Guided Tour II Document Manager Editor Visualizer Server Database Manager Site Manager FAQ

 

wpe1.jpg (13116 bytes)

Database List
Connecting . . .
Database Level
Table Level
Column Level
Ad-Hoc Query

Overview

Clicking on the Database Manager button dbms.gif (271 bytes) on the Navigation Panel will activate the Database Manager's main screen.  This screen is divided into two panels, the left panel displays a tree structure of all supported databases grouped by their respective type (i.e., Access, MS SQL, IBM, DB2, Oracle) as shown in the screen shot below.  To populate the tree structure, the Database Manager reads the ODBC Registry on the local workstation and  retrieves a listing of all available ODBC database connections (grouped by database type) that have been configured using the Windows' ODBC Data Source Administrator tool.  The Windows' ODBC Data Source Administrator tool can be found in the Windows Control Panel. 

wpeB.jpg (37085 bytes)

At the database level, the Database Manager provides a "Point and Click" interface to enable the user to navigate from one database to another.  In addition, it also provide drill down capability to display the structure (i.e., tables) of the selected database. 

At the table level, the Database Manager also provides a "Point and Click" user interface to drill down to the structure or the detail layout of each table within the selected database as shown in the screen shot below.

wpe11.jpg (56923 bytes)

Furthermore, right-clicking on a table will enable the user drill into the table to perform table level data discovery and data inspection functions such as table structure, table samples, row counts, etc.  Similarly, right-clicking on a column within a table will display a list of column level data discovery and data inspection functions such as column sample, distinct values, frequency counts, min and max values, etc.

 

Features Map

Database listing
 
Connecting to a database
 
Table listing
 
Table level data discovery and data inspection functions
 
Column listing and column level data discovery and data inspection functions
   

Functionality

Menu Bar

Menu Bar

Subfunction

Functional Description

File

 

Page Setup . . .

 

Opens a panel to allow you to configure the paper size, orientation and the margin settings of the printed page.

File

 

Print Preview

Opens a panel to show you what the active document will look like when printed.

File

Print

Prints the active document.

File Exit (Ctrl+X) Exit the program.

Help

About

 

 

Toolbar

Toolbar

Functional Description

preview.gif (312 bytes) Print Preview

Opens a panel to show you what the active document will look like when printed.

print.gif (295 bytes) Print

Prints the active document.

 Refresh

Refresh the current screen display.

odbcad32_16.gif (177 bytes) ODBC      Administrator Shortcut to Windows' ODBC Data Source Administrator tool
redball.gif (326 bytes) Cancel Cancel the database request (e.g., query or connection request).

   

 

    

Copyright © 2001- 2002 complementSoft LLC. All Rights Reserved