Feature |
Professional |
Professional Plus |
|---|---|---|
Platforms |
||
Windows |
 |
|
Linux |
|
|
Mac OS |
|
|
Schema Browser |
||
Table Filter |
|
|
Dynamic Query Building/Execution |
|
|
Column Definitions |
|
|
Query Editor |
||
Dynamic SQL Creator and Visualizer |
 |
|
Direct Result Set Export to File or Spreadsheet |
|
|
Multiple Editors per Connection |
|
|
Selectable Schema per Editor |
|
|
Dynamic Query Creation |
|
|
Table Name Suggestions (Alt-T) |
|
|
Column Name Suggestions (Alt-C) |
|
|
Detachable Editor for Long Running Queries |
|
|
Describe Table (Alt-D) |
|
|
Query Results |
||
Dynamic Update |
|
|
Dynamic Delete |
|
|
Filter Designer |
|
|
Multi-Column Sorting |
|
|
Column Value Filtering |
|
|
Copy Result Data |
|
|
Export to Spreadsheet |
|
|
Show-Hide Columns |
|
|
Dynamically Move Columns |
|
|
Charting |
||
Quickly Create Charts |
|
|
Explore Complex Data Relationships |
||
View Organizers - No SQL Required | |
|
Sharable Configurations |
|
|
XML Viewer |
||
View Formatted XML |
|
|
Search Using Element Name |
|
|
Search Using XPath |
|
|
XSLT Transformations |
|
|
Integrated Scripting |
||
Connect to Multiple Configured Databases |
|
|
Execute Queries |
|
|
Access Column Data in Result Tables |
|
|
Import and Export Excel Spreadsheets |
|
|
Search, Edit and Transform XML Documents |
|
|
SQL Extensions |
||
Export Data to a File - @export() |
|
|
Filter Variables - @var() |
|
|
Insert Update SQL or Large Object Columns |
|
|
Connections |
||
Multi-database |
|
|
Optional Auto Commit |
|
|
Save and Share Queries |
||
Save/Load Queries from Network Drive |
|
|
Sample School Database |
||
Database |
|
|
Basic Queue Explorer (No Queue Access Feature shown below) |
||
Connect to IBM WebSphere MQ (MQ Client Required) |
|
|
Connect to RedHat Artemis (AMQ Derivative) |
|
|
Connect using Userid/PW or no Credentials |
|
|
Browse/Search Messages on one or more Queues at a time |
|
- Maximum of 50,000 messages in result |
Text Searching |
|
|
Put Messages to Queue |
|
|
Put Messages from File to Queue |
|
|
Requeue Message from Backup Queue |
|
|
Move Messages to Backup Queue |
|
|
XPath Searching of XML Messages |
|
5 matches only |
Dynamic Searching/Filtering of Result Set |
|
5 matches only |
Browse/Search across two of more Queue Managers at a time |
|
|
Put Messages from Archive File to Queue |
|
|
Backup Messages to Archive before Deleting from Queue |
|
|
Full Scripting Integration |
|
|
Feature |
Queue Access Feature |
|---|---|
Queue Explorer |
|
Connect to IBM WebSphere MQ (MQ Client Required) |
|
Connect to RedHat Artemis (AMQ Derivative) |
|
Connect using Userid/PW or no Credentials |
|
Browse/Search Messages on one or more Queues at a time |
- Unlimited |
Text Searching |
|
Put Messages to Queue |
|
Put Messages from File to Queue |
|
Requeue Message from Backup Queue |
|
Move Messages to Backup Queue |
|
XPath Searching of XML Messages |
|
Dynamic Searching/Filtering of Result Set |
|
Browse/Search across two of more Queue Managers at a time |
|
Put Messages from Archive File to Queue |
|
Backup Messages to Archive before Deleting from Queue |
|
Full Scripting Integration |
|