KeepTool Professional 15.0.0

Prend en charge Oracle 21 et Microsoft Windows 11.
Décembre 7, 2021
Nouvelle Version

Fonctionnalités

  • KeepTool now supports Oracle 21 as well as Microsoft Windows 11.
  • Database object flagging:
    • Both on Hora’s tables/views and PL/SQL overview grids as well as on the data content browser, query builder, sequences and PL/SQL types overview grids you can now flag individual database objects. A combo box in the new “Flag” column allows you to select a symbol such as a colored bullet, a warning mark, etc. Use the built-in filter technologies to filter objects by symbol.
    • The data object browser in the right of the editor window now displays the symbols as well, but you cannot change them there. Press F5 to refresh.
    • Hora’s master/detail view now displays the symbols within the shape that represents the table.
    • ER diagrammer displays the symbols in both listboxes for selected and remaining tables.
    • Added two new buttons for each listbox which allow you to select flagged or unflagged tables.
  • The connect dialog now allows you to star connections as favorite. The list of recent connections now shows the ‘favorite’ property as first column. Use built-in filter technologies to filter favorite connections.
  • The embedded SQL editor component allows you to drag & drop code snippets from a tree view into the code window. Up to KeepTool 14, the data source was a text file CodeSnip.txt located in %programdata%\KeepTool14\Templates.
    • Moved to XML in order to support multi-line snippets. The data source has been relocated to %appdata%\KeepTool15\Templates\CodeSnip.xml and can be changed using the settings dialog.
    • You can now add, change and remove Code snippets interactively. Press the “save” button to persist changes. Use the “refresh” button to reload changes made in another instance of Hora.
  • Hora’s data content browser now shows a tooltip hint for the caption of the detail table view.
  • The hint now displays the table comment of the detail table, similar to the existing behavior of the master table.
  • The header of Hora’s Java overview page now shows the concatenated package path for the currently displayed Java object.
  • Hora’s data content browser page allows you to display a detail view of a page that has no foreign key relation to the master table. You can now add multiple free detail tables. After one detail table has been added, a new tab for adding the next detail appears.
  • Hora’s data content grids and record views now display a ‘key’ icon in each key column header.
  • Hora’s Tables | Master/Detail diagram now displays the table’s comment as a tooltip.
  • For Oracle 11g and later, Hora’s session | open cursors page:
    • Displays an additional column “User”.
    • Shows records in gray if:
      • The cursor type column does not contain “OPEN”.
      • The optimizer column is null.
      • The new user name column does not match either the “User” or “Schema” column displayed in the sessions overview data grid.
  • Added an additional tab “Network client” on the sessions page. It shows network adapters that have been loaded.
    • That may indicate that encrypted network communication (SQLNET.ENCRYPTION) has been enabled as well as active data integrity options (SQLNET.CRYPTO_CHECKSUM).
    • It lists more client information such a OCI client version and client character set.
    • The overview grid displays two new columns “Encryption” and “Checksum” in the “Client machine” group that summarizes the most relevant information regarding encryption and checksumming.
  • Added a new “Direct TCP/IP” options tab on the settings dialog. The “IP version” select has been moved there.
    • Two new combo boxes “Encryption” and “Crypto checksum” implement a behavior similar to the sqlnet.ora levels ACCEPTED and REQUIRED for both SQLNET.ENCRYPTION_CLIENT and SQLNET.CRYPTO_CHECKSUM_CLIENT entries. The default value for both is “Accepted”.
      • Change to “Required” mode to enforce security.
      • “Requested” mode has not been implemented yet.
  • Hora’s schema dependencies diagram has been moved from the database page to users page. Double-click a schema to navigate to the appropriate user in the overview grid.
  • Hora’s Container database overview page now shows:
    • NLS character set and NLS language.
    • Another detail grid that displays recent PDB plugin violations.
  • Hora’s create DB link dialog now shows a combobox for the referenced service name. In case of a SQL*Net connection, it lists the TNS aliases from the client. Make sure the selected alias has been configured on the server as well if you want to share one tnsnames.ora include file with all machines.
  • For PL/SQL object types, Hora now shows a new context menu item “Generate XML schema”. It creates a XSD file using Oracle’s dbms_xmlschema package and shows it in a popup window.
  • Several improvements for XML schemas and XML_TYPE tables and columns:
    • New options have been added to the create “XML schema” dialog.
    • All XML DB pages now are filtered by the current schema, similar to other Hora pages.
    • XML elements page now shows the element’s XSD part as a detail information to the tree view.
    • Added new XML columns sheet.
    • Added dependecies tab.
    • Improved DDL generation for XML_TYPE tables and columns.
    • Reverse DB now generates code to register XML schemas.
    • DB Compare now considers XML schemas.
  • Hora’s refresh group data grid on the Material Views page:
    • Shows an additional column that counts the number of refresh children in the group which allows you to identify non-trivial refresh groups on a single glance.
    • Both Show DDL and Destroy menu items are enabled for multi-selection now.
    • There is a new context menu item ‘change’ to modify a refresh group.
    • For non-trivial refresh groups, the ‘DDL’ creates an empty refresh group and then adds material views one by one. This makes your manual changes easier to perform.
    • MAKE() is followed by a CHANGE() to make sure both NEXT_DATE and INTERVAL parameters are set.
  • SQL query builder now uses bold font for primary key columns.
  • ER Diagrammer has got a new context menu item for entity/table shapes. “Copy table name” allows you to copy the table name to the clipboard.
  • DB Compare now includes Oracle Contexts, as long as the user has select privileges on DBA_CONTEXTS. There are no ALL_ and USER_ views for contexts.
  • DB Compare’s logic for creating schema consolidation script has been improved:
    • The DB object treeview now has got a root item “Schema”. If this “Schema” item is been focused, the schema consolidation script processes all changed objects. Unchecked objects are excluded.
    • If a DB object type node such as “Tables” is focused, the schema consolidation script processes all changed objects of the appropriate object type. Unchecked objects are excluded.
    • If a DB object node such as “EMPLOYEES” is focused, the schema consolidation script considers the focused DB object only.
  • The SQL Editor now shows additional elements for the bread crumb bar that shows the file path:
    • Buttons to navigate the history.
    • Combobox button.
    • Refresh button.
    • Explorer-like search box.
  • Form painting on resize has been improved resulting in a smoother experience.
  • The 15.0.0.0 setup installs the latest Wibu CodeMeter runtime version 7.30a. It is strictly recommended to update the CodeMeter runtime on your network license server as well.
KeepTool Professional

KeepTool Professional

Outils de base de données Oracle intuitifs.

KeepTool Professional est également disponible en :

Vous avez une question ?

Discutez en direct avec l'un de nos spécialiste des licences KeepTool .