KeepTool Blog - Current

KeepTool now empowers you to configure and monitor Oracle’s native SQL*Net encryption and data integrity checksumming, even when connecting directly via TCP/IP. You can enforce encryption parameters (ACCEPTED, REQUIRED, etc.) without altering sqlnet.ora, and easily track both encryption and checksum status per session in the new Sessions → Network client tab—giving you full visibility and control over your network security.

KeepTool lets you flag your database objects—assign icons like colored bullets, stars, or warning signs directly within your object overview. Once flagged, items remain visually marked across all KeepTool components—from the query builder to ER diagrams—making it fast and easy to keep track of the tables, packages, or sequences you're focused on managing.

KeepTool 15 introduces enhanced performance, compatibility, and security for Oracle databases. With full support for Windows 11 and Oracle 21c, new XML DB features, direct TCP/IP encryption, and visual object flagging, this release streamlines daily work for developers and DBAs. Experience faster workflows, better integration, and modern security — all in a single, intuitive tool.

KeepTool enables you to explore dependencies between Oracle database schemas through a clear diagram on the Schema page. It highlights upstream and downstream relationships for the current schema—master schemas that it depends on and detail schemas that depend on it. Plus, digging deeper is simple: click any schema to display related objects and their specific dependencies in adjacent tables.

KeepTool now supports Oracle’s Memoptimized Rowstore (introduced in Oracle 18c), enabling blazing-fast lookups on tables primarily accessed by primary key. By activating this feature and populating the in-memory pool, queries bypass traditional I/O and SQL processing to deliver rapid results—perfect for high-frequency workloads like IoT or real-time dashboards.

KeepTool Hora now enhances your INSERT, UPDATE, and MERGE scripts with an option to escape non-ASCII or control characters using the UNISTR() function. This ensures your SQL remains robust and consistent—regardless of NLS settings or unseen characters—by automatically transforming special characters like ß into their \00DF escaped counterparts.

KeepTool’s SQL Execution History feature logs every SQL statement you run. Quickly view, filter, and re-execute previous commands – no need to retype complex queries. Whether you’re debugging, auditing, or analyzing performance, the history view provides full transparency and control right inside the SQL Editor.

KeepTool makes managing multiple Oracle databases easier than ever. Connections are now automatically grouped by hostname and service name, giving DBAs and developers a clear overview of all servers and environments. Find and connect to your databases faster — whether through SQL*Net or direct TCP/IP.

KeepTool’s ER Diagrammer automatically creates professional, easy-to-read ER diagrams from your Oracle database. Generate focused sub-diagrams, link them with HTML documentation, and gain a clearer view of complex schemas. Perfect for developers, DBAs, and analysts who want to model, explore, and document Oracle databases faster and smarter.

KeepTool’s Reverse Database Engineer lets you script both the structure and data of Oracle schemas with ease. Choose which objects or tables to include, add filters, and generate INSERT or MERGE statements instantly. Ideal for migrating databases, creating backups, or documenting schema changes — all with the flexibility and control that Oracle developers and DBAs need.