Home »  Products »  DB Cruiser  » Features & Benefits

DB Cruiser: Features & Benefits

Overview:

The unique query-oriented approach allows you to build SQL queries at almost any place. Specially, you can start build a query visually as soon as you view the table column definitions - no SQL to write [screen]. Furthermore, for each result set, you can view the SQL which produced the result, then modify and re-execute it right at the spot!

Highlights:

  • • Maintain multiple concurrent connections to different databases.
  • Report functionality
    • o Generation of ad hoc reports in HTML, EXCEL® and PDF .
    • Eesy-to-use report formatter. [screen]
  • Administration Console (web based) [screen]
    • Add, delete, modify, enable/disable connections on the dropdown list.
    • Monitor all the active database connections via DB Cruiser:
      • Who is connected; when the connection was last used, and what databases they connected to.
      • Disconnect any unwanted active connections.
    • Change debug level and other server parameters at runtime without restarting the servlet container.
    • View server status, like memory usage, classpath, etc.
    • Import and export DB Cruiser configuration
    • View server logs online
  • CLOB/BLOB (TEXT/BINARY) handling [screen]
    • View the content of CLOB up to maximum allowed size (configurable).
    • Download the whole content of CLOB and BLOB.
    • Modify/update the content of CLOB by simply typing.
    • Replace the content of BLOB by uploading
  • Open style login There are 3 way to connect to a database via DB Cruiser:
    • Select an existing connection from the dropdown list
    • Slightly modify an existing connection
    • Build a connection URL based on the database product and the JDBC driver.
  • Tables/Objects Explorer (search tables, system tables, views, synonyms, etc.) [screen]
    • Search tables by patterns, similar to LIKE statements in SQL.
    • May open tables in new windows so you can do side-by-side comparison.
    • Memorize tables visited so you may revisit them without re-searching.
    • Query Builder.
  • Tables Work Area
    • View column definitions, and start build queries without SQL.
    • View table size, primary/foreign keys, indexes, DDL, privileges, etc.
    • Insert new tables row without SQL, including CLOB/BLOB columns.
    • Retrieve last query result for the table.
    • Execute SQL statements.
  • Query results
    • View the SQL which produced the result, may modify and execute it again.
    • Modify the data in the result in a spreadsheet style - no SQL to write.
    • Export the result to HTML, PDF, EXCEL®, CSV, XML, TEXT, or INSERT statements
    • Change the display size (per page) and font size while viewing the result.
    • All query results are cached - you can view them at later time until they are overridden or deleted.
  • Foreign Keys [screen]
    • Expose both parent and child keys
    • Navigate tables among parent/child keys relationship.
  • SQL Editor (SQL Work Area, SQL Work Sheet)
    • Execute any standard SQL statements. [screen]
    • Execute multiple SQL statements simultaneously. [screen]
    • Show all the SQL statements executed in the session