A milestone release for DBHawk: an embedded AI assistant, audit & compliance dashboards for security teams, and a full UI modernization — alongside a broad set of improvements and bug fixes.

New Features

HawkAI — AI assistant in the SQL workspace
– Added an AI assistant directly into DBHawk.
– Supports plain-English prompts to generate SQL queries.
– Added AI-powered query optimization suggestions with side-by-side variants.
– Added chart generation based on query result data.
– Added conversational sessions with saved history.
– Supports OpenAI, Azure OpenAI, and Ollama providers.
– AI-generated queries are validated against the user’s access-control list.
– Added a new AI Helper menu permission that can be configured per connection.

New Data Import Utility for Oracle
– Added a redesigned drag-and-drop data import utility for Oracle databases.
– Supports CSV, Excel, and Parquet files.
– Compressed files are automatically decompressed.
– Automatically detects columns and data types before import.
– Users can review and adjust column mappings.
– Data is loaded in batches within the connection transaction, allowing explicit commit or rollback.
– Added support for creating a new table or importing into an existing table.

Audit & Compliance Dashboards
– Added new reporting dashboards for security and compliance teams.
– Audit History dashboard includes users, sessions, login patterns, anomalies, and a user-by-database access matrix.
– Compliance & Security dashboard includes authentication security, sensitive-data access, privileged activity, and SOX ITGC checks.
– Added checks for segregation-of-duties conflicts and dormant accounts.
– Dashboard metrics support drill-down into underlying records.
– Added CSV export support for dashboard data.

Migrate to MySQL Utility
– Added a migration utility for moving DBHawk’s internal schema and data to a MySQL database.
– Added a dual-list interface for selecting migration objects.
– Added foreign-key-aware data loading.
– Added adaptive handling of large inserts for more reliable and efficient migrations.

Forced Password Change on First Admin Login
– Default administrator accounts are now required to change the default password during their first login.
– This prevents continued use of the default administrator credentials.

Improvements & Enhancements

UI Modernization
– Added selectable Light, Dark (Slate), and Accessibility high-contrast themes.
– Themes can be configured independently for each user.
– Replaced legacy bitmap icons with a new SVG icon set.
– Standardized button, hover, and focus styles throughout the application.
– Redesigned interfaces across the SQL Editor, result grids, Visual Query Builder, wizards, and other application areas.

SAML Role Mapping
– Added SAML role mapping for Admin, Developer, and Analyst roles.
– Identity-provider roles can now be mapped individually to DBHawk roles.
– Added support for configuring a default fallback role.

SFTP Job Error Reporting
– Improved SFTP job error handling to display the actual underlying failure cause instead of a generic error message.

Dropdown Search
– Standardized search behavior across dropdowns and search controls throughout the application.

Bug Fixes

Database & SQL Editor
– Date, Time, and Timestamp Handling: Fixed export and import handling of Date, Time, and Timestamp values to maintain consistent formatting across supported databases.
– Oracle Autocomplete: Fixed an issue where SQL autocomplete added unnecessary quotes that could produce invalid queries.
– Oracle Autocomplete: Schema identifiers are now converted to uppercase before quoting to prevent ORA-00942 errors.
– Oracle Autocomplete: Added savepoint handling so autocomplete metadata lookups no longer abort uncommitted user transactions.
– Oracle Packages: Fixed SQL Editor failures when creating Oracle PACKAGE or PACKAGE BODY objects using the EDITIONABLE or NONEDITIONABLE keywords.
– MySQL Repository: Fixed an issue causing the Job module to fail when DBHawk uses MySQL as its backend/repository database.

Logs & System Stability
– Audit & Session Logs: Added log sanitization that removes NUL characters from audit and session log files.
– Log Management: Added safeguards to active-log management and download processes to prevent corrupted log files.
– License Menu: Improved null handling and fallback logic for license-controlled menus to prevent NullPointerException errors.
– Custom Logo: Removed unnecessary console and log errors generated when no custom logo is configured.

Job Scheduling
– Duplicated Jobs: Fixed an issue where a job duplicated from a paused job executed immediately after activation instead of waiting for its configured schedule.

DBHawk 6.7.4 Release – April 29, 2026

This release focuses on expanding environment compatibility, optimizing metadata performance for cloud warehouses, and refining data formatting across all supported databases.

Improvements & Enhancements
Core Infrastructure & Performance
– Java Modernization: Added full support for Java 17, 21, and 25, ensuring compatibility with the latest LTS versions.
– Tomcat Upgrade: Updated internal Apache Tomcat to v11.0.21 for improved security and performance.
– Redshift Optimization: Optimized column metadata queries to significantly decrease wait times when fetching table details.
– Snowflake Enhancements: Improved performance when retrieving table and column metadata.
– – Added support for displaying Primary Key information for Snowflake tables.
– System Logs: Implemented pagination and a maximum data limit on the database log display grid to ensure stability and speed.

Data Formatting & UI
– Global Number Formatting: Added advanced decimal formatting options for numeric columns. This has been standardized across:
– – Oracle, MySQL, SQL Server, PostgreSQL, Redshift, Greenplum, Teradata, Vertica, SAP HANA, Snowflake, DB2, CSV2, Azure SQL, and Athena.
– Temporal Data Refinement: Improved formatting options for Date, Time, and Timestamp columns in SQL Server, Azure SQL, and Oracle.
– Security Default: New Admin users created via SAML now will have access to data as standard new user feature

Bug Fixes
Database & SQL Editor
– MySQL JSON Handling: Fixed an issue where JSON column outputs were HTML-encoded (displaying " instead of quotes).
– Snowflake DDL: Resolved an error preventing DDL retrieval for tables within the SNOWFLAKE_SAMPLE_DATA schema.
– CSV2 Execution: Fixed a bug where execution times were incorrectly reported as “undefined” for SELECT queries.
– VQB Integration: Corrected an issue where mycsv queries built with the Visual Query Builder could not be opened in the SQL Editor.
– View Management: Fixed a bug where modifying a View or SQL would still reference the old name after a rename operation.
UI & Access Control
– Responsive Design: Fixed a UI bug where Edit/Delete actions in the Mask Log Data grid were cut off at 1366×768 resolution.
– Analyst Permissions: Corrected a visibility bug to ensure the “Export Table To” option is hidden for users with the Analyst role.
– SAML User Management: Resolved a conflict that prevented the deletion of SAML users if they had shared queries associated with their account.
– Integration Testing: Refined HashiCorp integration tests to display clean error messages instead of raw HTTP exceptions.

DBHawk 6.7.3 Release – February 10, 2026

Improvement
– Improve date format for various date and timestamps
– API: Log Expire token API Call and also send Email to Admin User too for token expiration
– Allow bulk BLOB data download with Oracle database
– Inactive user group Override DBHawk settings applied when multiple groups assigned
– SAP Hana: Maximum Rows not getting reflected correctly
– Add logs for event when some other admin gives or removes access to data
– With CSV data query open in SQL Editor by default add Limit
– Allow DBHawk backend database MySQL to run with parameterize values
– Robust web application security enhancements

New Feature
– Allow CSV and Athena data to be exported as Parquet format

Bugs
– DB2: SQL Query Builder: When closing/deleting table after selecting columns it’s not clearing in SQL
– Oracle : “AS OBJECT” incorrectly added in CREATE TYPE BODY generation
– Import data from Athena — Only last row is imported
– SQL Server : Export Data screen shows AdventureWorks2019 schema and tables instead of new database tables
– Unable to delete a paused scheduled job after deleting the associated report
– PostgreSQL: Missing and Inconsistent Data Types When Adding Columns to Table and create new table
– Job details : Reset Filter selects both Active & Paused checkboxes but shows only Active jobs
– Oracle compare utility do not compare objects in same order and hence show difference
– NULL Values Displaying Incorrectly in Grid
– Power BI via DBHawk Proxy (JDBC-ODBC\) does not enforce ACL & data masking consistently
– JSESSIONID: Previously Logout Session is not invalidated
– MySQL – All : Time field shows date picker and wrong format label
– Explain Plan displays raw HTML instead of formatted output
– DBHawk generates MySQL DELIMITER syntax when creating DB2 functions, causing execution failure.
– DBHawk goes into infinite loop while activating license automatically when license is not valid or cannot activate
– SQL Query Builder fails in Oracle for reserved keyword columns

DBHawk 6.7.2 Release – November 6, 2025

New Feature
– API: Groups: Update Group APIs for Enable/Disable feature changes
– Develop a data migration utility from one database to another based on the schema selection
– For admin type users, add new flags to control to have access to the databases connection

Improvement
-Redshift: Remove Run Procedure and Run Function Button
-MySQL: Foreign Key link is not visible
-API: Log Request body for all API Calls
-Db2: Unable to rename column from Edit Column dialog — Name field disabled
-Password Policy: System should only enforce minimum length when no policy checkboxes are selected

Bugs
-Teradata My Export Window Not Opening on Click
-MySQL is not showing data on the table but SQL Editor shows data
-API: Create Datasource API – Getting an Error: “This feature is not available with the license you have”
-SQL Server-Azure: Unable to get Table SQL
-Job: Reset Filter selects both Active & Paused checkboxes but shows only Active jobs
-Import Data job : Import job from S3 fails while export to S3 works successfully
-Db2: DBHawk UI fails to alter Db2 tables with lowercase names
-Db2: Getting Error when creating a table with comments using DBHawk UI for Db2
-Db2: Getting Error when create Sequence in Db2
-Db2: Getting Error When Using “Truncate before insert” in Db2 Export table to
-MySQL, SAP HANA, Athena :Showing Not Committed when auto commit is on
-SQL Server: Save SQL from Synonyms not getting SQL query only Empty file is downloaded
-MySQL – ALL: UI incorrectly shows USING options for FULLTEXT and SPATIAL indexes
-Oracle: Numeric data columns is showing null in Materialized View
-PGSQL – NEW Getting Error when drop Materialized View
-Oracle: Getting Error when creating synonyms for SEQUENCE, FUNCTION, PROCEDURE, PACKAGE, JAVA CLASS, and TYPE.
-Redshift: Inconsistent data type options when creating table
-Filter is not working with Draft Queries
-Pivot: Unable to save pivot table
-Dependencies for views show duplicate entries and SQL Editor does not open
-API: API calls to Athena fail with error
-Athena connections only display the Export option, while other databases display both Export and Export All Rows.
-H-del: Showing Not Committed when auto commit is on
-HSQLDB, Db2, SAP Hana: BLOB data preview shown twice when table has a primary key
-Uploaded file name not displayed for BLOB column
-SAML2 Setting: Unable to Edit SAML Setting
-Override DBHawk Settings allows blank or invalid values causing login failure

DBHawk 6.7.1 Release – August 28, 2025

Improvement
-Various Java libs upgrade
-My Queries: Remove Migrate Old Option
-Move DB Logs menu item under Logs manager
-Upgraded Apache Tomcat version to 11.0.10

Bugs
-Autocomplete is not working as expected
-Password Mismatch : Validation Not Working Properly
-Inconsistent base URL in user creation email when user is created via API
-CRUD: getting 500 Error for invalid query
-Export Table to : Remove ‘Load More’ from Connection Level – Should Only Show Under Tables Tree
-Athena : Visual Query Builder is not working with date and timestamp columns
-Closing CRUD Utility as Dev User Redirects to Admin Screen
when SSO Enabled is false in licence , it is not allowing to access api
-API: Analyst User Creation Issue and Auto-Generated Password Includes Special Characters Even When Disabled
-API:datasource api is not working for mysql
-Visual Query Builder:Incorrect SQL Syntax \(! =\) Generated by Visual Query Builder
-UI Allows Creating User with Multiple Emails – Should Be Restricted
-Visual Query Builder : Visual Query Builder does not generate SQL when dragging filtered table in MSSQL
-DBHawk goes into loop when we upload an expired license and does not allow to upload any new license
-When try to send test email from the email screen, it gives 500 error
-ACL : Data Masking on BLOB Column Breaks on Link Click – Reveals Original Data
-API: Put-Update User: username is not getting updated
-API : API Output Row Limit Setting Ignored – Always Returns 500 Rows
-API: Delete Inactive User – Update response message
-API: Delete ACL – Read only is not removed when ACL getting deleted by name
-Job : Duplicate job from paused job runs immediately on activation instead of at scheduled time

DBHawk 6.7.0 Release – June 25, 2025

Improvement
-Dependencies vulnerability fix
-when send test email with the email settings, let’s make sure to log successful email sent with the test email address
-Move all DBAs related menu items under DBA main menu for all databases
-Change dimension and metrics order on the Visual Query Builder
-Map SAML role with DBHawk role
-When export data to s3 – export to a unique folder with table name or a unique timestamp (sql window)
-Allow LISTAGG function on ACL for Oracle database
-Add file size details on the My Export screen
-Change allowed maximum value for Snippets = 50,000,000

New Feature
-Add Explain plan for db2 SQL queries
-DBHawk admin screen to enable disable various features at the group level

Bugs
-DB2: Unable to truncate table
-When DB2 user do not have access to any objects, it should not throw errors
-Snippet : Getting validation Error for Maximum rows
-Aws-Redshift with limited access – Getting an Exception (Long Error) when trying to access Session Management
-MySql Dump: Getting Exception Error when trying with Select All data objects
-Visual Query Builder with Teradata is not opening up the query in SQL Editor
-Teradata right click SQL is not working
-Show default screen when all tabs are closed
-DB2: Getting Error in DB2 Session Management and Storage Manager
-Databricks connection is not working with its new setup with token
-API: Azure AD: Unable to connect azure database when Updating secret Key
-After inserting many records and pressing commit button does not show correct status on the message window

DBHawk 6.6.9 Release – April 21, 2025

Improvement
-Develop a feature to export data from one database table and import to other database table (MsSql, MySql, Postgres, RedShift, Db2)
-Add job log message for job edit event
-Upgrade DBHawk with Spring 6, Java 17 and Tomcat 11

New Feature
-Develop a new utility for DB2 database to allow running various SQL queries against multiple databases

Bugs
-On the database object tree, load more is not working, it’s not loading more tables and collapsed all
-Duplicate metadata entries appear when compiling an invalid trigger multiple times

DBHawk 6.6.8 Release – March 7, 2025

New Features
-While viewing the audit log, it is not possible to see if user was accessing mask data or not
-Create a comprehensive report detailing the specific data access permissions granted to each user
-Allow to disable EMAIL results in the job module
-Implement support for tab-separated values (TSV) as a data separator, while ensuring compatibility with other standard data formats

Improvements
-Get Tables API not giving result in order by asc alphabetically
-Swagger : Add details about which type of user role can call API
-Job Module Missing in Cassandra
-Quick Filter: Add Auto Suggestion for easy use
-Refresh Button : Add Refresh button on Grants Screen
-Change JDBC URL to JDBC Parameters in API call
-Various DBHawk job enhancements
-All databases connection, set program name = DBHawk-
-ACL: When ACL delete then update connection to as its original State
-Change license expiration date email formatting
-API: PUT datasource API: add dbPassword field
-Increase default number of job threads = 50
-Add Source, Message, and other details to user authentication history
– Export data in the same format and column order as displayed in the user interface.
– If the query results display a subset of available columns, the export should include all columns.
-User Access: Add Enable Daily Purge History Job to delete data
-Display newest data on the top for Pivot tables
-Label Change: Add Pivot Table /Snippet in place of Pivot Table
-DBHawk Setting: Maximum Execution Time: to 1440

Bugs
-MSSQL: binary and varbinary Data Type: Getting Null Pointer Error when click on link from Table data
-Format: CSV- Database – Format is not giving correct and getting an Error
-Db2: SQL tab is missing in Visualisation
-Save SQL: Export : Getting an Error:The maximum length of cell contents (text) is 32767 characters
-DBHawk gives error for Oracle database while generating DDL
-Duplicate create job with the end date keeps creating job with the end date
-Duplicate job: When opening Cron Duplicate job getting an Error
-SQL: All columns name are not getting added into Select query
-Job: RunNow is not working
– Upon user creation, automatically trim leading and trailing whitespace from input fields to prevent subsequent errors
-Snippet: Getting Dual Grid when Click on Run again/first time
-Column : Getting an Error when renaming the column in PGSQL
-Getting Error While exporting Data from One database to another
-Database logs with Oracle SSL Connection is not writing data in log tables
-With Oracle or other jdbc databases when user updates the connection to advance jdbc driver and change it back, it still keeps the old setting
-Password: When user try to change Theme getting password policy Error

DBHawk 6.6.7 Release – November 19, 2024

New Features
-Implement data migration between two Oracle database tables
-Support logo uploads for branding purposes
-Add indexes and triggers to Db2 objects tree
-Add dependencies information for various Db2 objects
-Allow users to create pivot tables to summarize and analyze data online.
-Enable configurable data masking in logs
-Introduce a feature to send email reminders to administrators about upcoming license renewals
-Display Db2 users

Improvements
– Create a database log to store DBHawk login information.
-Filter: Across DBHawk filter should work correctly
-Log all relevant information about CSV uploads, including upload time, user details, and any errors encountered.
-Include a “Test Connection” button to check the status of job configurations
-Implement detailed logging for UI-driven data modifications
-AWS-RedShift: Add Data and Date time format when exporting with CSV
-Add Db2 version and patch information on connection information
-Update MySQL Jar file to the latest version of 8.3.0
-Db2 database is missing length and other information for the edit data window
-Add new DBHawk property to change click behaviour on the database Tables
-API: Add Auto generate password variable for New create user also notify user
-API: Enforce password policy for UpdateUser API
-Restore old data snippet feature
-API: Add Maximum Number of API Output Rows field on API Management Screen
-Correct Snippet execution query icon
-For Db2 Add Triggers and Indexes in the Object Tree
-Fix Visual Query Builder to not to create SQL without column names when applying summarization
-API: Add the database name while creating a new Generic data source via API.
-Visual Query Builder is missing AVG function for group by
-Upgrade ldap-core library
-To access DBHawk swagger API documentation, user must requires to login to DBHawk
-Fix JS Errors while adding a new line to the SQL Editor
-When saving objects SQL, make sure to save it with the object name
-API: Do not return binary Data in API output – JSON – Example blob
-Improve various UI components in SQL Server Database
-Log: Log wrong filenames warning/error log details into the dbhawk.log file instead of console
-Improve various UI components in other Important Databases same as SQL Server Database
-Db2: Add Save SQL/Save button for Triggers and Indexes
-Upgrade jQuery version to 1.13.2 or latest or more advance version
-Replace MySQL Engine and Job Details Icons
-On Users detail screen, add User Role column in Manage Users Page
-Display Db2 fix pack information
-Remove current transaction check on Db2
-Format SQL for Db2 is adding wrong space
-Add display confirmation while Commit and rollback button pressed
-Add support for Db2 identity column
-Replace Save query icon
-Change auto draft query display order to display latest auto saved queries on the top

Bugs
-Default SFTP setting displayed as Active
-Chart and Dashboard showing Invalid Data
-PGSQL is not displaying constraint information on latest postgres version
-Add column error via interface (MySQL)
-List: Redirection Issue (2nd time – Job/Report/Snippet List)
-Upload CSV: If user upload file which have only columns then on csv database getting null error
-When you create new database for Oracle it shows azure ad connection
-Fix scrollbar on Export screen
-CSS: Date in Dark Theme not able to see Date
-Export error for tables with xml type
-Snippet file manager action missing DB_User, database, and connection information
-SAP HANA Indexes : Getting Error when trying to open Indexes of any table
-Remove Starting Space from Database Connection Name – Connection dialog box
-Jobs dates sorting not working
-Filter: MsSql – Filter always applied even user clear filter and view table data again
-DBHawk Admin Home screen does not refresh when New License is uploaded
-Right click on SQL Editor is not working and giving error
-DBHawk is not showing correct dependencies for SQL Server database
-Cannot export SQL/DDL for database sequence
-SQL Server trigger shows wrong dependencies
-DBHawk Job screen keeps flickering and make it hard for customers to click on the -Create Job button
-Visual Query Builder adds space with COUNT(*)
-Upload Sql File Name: Support/Allow only this special characters to File Name
-When there is no data in Db2 z os getting null error
-SAP HANA: Unable to Add Row
-Error Message add time setting to show message
-Export: Implement Selected Column Export to Result Set (similar as Table Export)
-Stop on Error: Save this setting on cache or something like \(How we save Table filter)
-Label: Change this from Database Name to Database Information
-DBHawk shows wrong data type on Db2 editor screen
-Db2 shows other objects when user type is Business Analyst
-When there is no not null column, Db2 does not show any error while creating a PK
-Db2 does not display correct message when permission is missing
-Db2 grant screen is not displaying correct details and it is not providing correct grants
-For Db2 DDL is not working for a normal non-admin user
-Db2 LUW – Check ADMIN user and then display admin related information – otherwise display – you do not have access to this information
-Visual Query Builder is not working for non-admin Db2 user
-When filter is applied, cannot open overloaded proc in Redshift

DBHawk 6.6.6 Release – August 9, 2024

New Features
-Auto save user session queries
-Store job logs in user’s database
-Add a new flag in settings to use single statement parser for sql server
-Develop Db2 Session Manager
-Develop Db2 Storage Manager
-Add date formatting on Visual Query Builder on other database
-Add save as snippet icon on Visual Query Builder to save built query with snippet
-Add support for Google Big Query with DBHawk
-Add data files for SQL Server
-Enable ACL for Db2
-Implement get tables API
-Add a new API to format user SQL

Improvements
– Chart parameters have data types whereas parameters in other places do not.
-When uploading mongodb data files as import or export, log the file name
-Change Oracle Compare Schema utility to allow to compare schema from other Oracle database connection
– Address Various Vulnerabilities in DBHawk
-Save Charts and Dashboards with the title name
-Add a separate message into log and email for actual job and for retry job for/avoid any confusion
-Remove Add row from Snowflake, Databricks and Google BigQuery
-Add VQB formatting option for SAP Hana
-Upgrade DBHawk libs to remove spring-web and other vulnerabilities
-When user stores logs into their own database, add missing logs to database
-Change SQL Server default jdbc driver on the connection settings to Use Microsoft JDBC Driver
-Enable daily backup with DBHawk by default
-API: Allow Developer & business analyst users to run getTables, runSQL and formatSQL API
-When export data to the Excel, do not zip the output file by default
-Add validation for required fields for the new database connection dialog
-Job retry should not run if someone run job manually and it runs successfully

Bugs
-Table filter gets reset after collapsing/expanding Tables
-Snowflake does not show data with Java 17
-Oracle Schema comparison is not working
-Cannot run select statement with lowercase tables in Db2
– MongoDB view shows error while clicking on the statistics
-Db2 session program name and client ip address is not showing correct information
Export error for tables with xml type
-Job: Validation is not displayed in Dark Theme
-Oracle VARCHAR2 lengths in DBHawk shows value 4 times bigger than the actual value
-‘go’ being stripped from a text field
-API: Generated API Link looks incorrect and unable to get details when calling api
-Job Details: When User Search with Text it’s not showing Job or Correct result
-Complete Oracle SQL query giving 500 error
-Create new user is not working with auto generated password
-SQL Server database connection showing errors while viewing Stored functions, procedures etc
-Visual Query Builder generates error with SQL query for mssql database but works with SQL Editor
– ACL: Multiple Catalog causing issue on Catalog Name and Multi Catalog table not able to added from UI
– DBHawk does not log update operation with the wrong column values
– Db2 database not able to show default set database
– Export: Getting multiple column in Export

DBHawk 6.6.5 Release – May 29, 2024

New Features
-Add MySQL dump utility to export all databases objects with data
-Add charts export data feature on each chart and also allow to display parameters drop down for dashboard
-Add pivot table capability for end users on the snippet data grid
-Add retry job feature while job fails to execute

Improvements
-Fix issue while job module is not connecting, report generation goes into loop
-Fix various modal windows and UI issues
-Add date and number formatting on Visual Query Builder
-Allow and run repetitive job to new scheduled time
-Add Cancel button on long running import
-Fix Snowflake database connectivity with Java 17
-Fix Redshift parameters displaying as numbers
-Add support for substr and instr functions with Oracle database with ACL
-Replace icons

Bugs
-MySQL displaying invalid data for tinytext data types
-MySQL Index with composite key is showing error
-PostgreSQL display error when Table Export to CSV
-Export feature is not working for SAP Hana Database
-Data import with different separator is not working.
-Wrong menu for Snowflake and Databricks databases
-Getting corrupted Image(QR Code) while login with 2FA user
-Wrong warning message on info on oracle
-SAML users cannot save profile. Getting NLP and not allowing to change profile
-Allow LDAP integration to connect to the group without case restrictions

DBHawk 6.6.4 Release – April 1, 2024

New Features
-Add new API to get existing ACL policy by name
-New API to remove list of users from the group
-Add new API call to add azure active directory settings
-When importing SQL queries on SQL editor, add an option to share imported queries with the group
-Allow to export data only with selected columns
-Add support for MongoDB Views

Improvements
-Upgrade Tomcat version to the latest release to remove various vulnerabilities
-Do not run Job automatically when updating SQL or any other properties on the existing job
-Allow SAML SSO user to import with a default different role
-Edit row on table that have no Primary Key for Oracle, SQL Server, MySQL, PostgreSQL databases
-Allow to bulk delete selected groups
-Various improvements with Visual Query Builder
-Display Foreign Key column name in the constraints
-Improve large export data issues
-Sort groups on user screen in alphabetical order
-Change csv export option to display to zip or not to zip output
-Support DB2 database connection with SSL

Bugs
-DBHawk does not detect correct PK and FK with Visual Query Builder and SQL Query Builder
-Visual Query Builder is not showing all columns on Summarize Data
-Drop table with Cassandra gives timeout error
-DB2 is not working with fetch data size
-DBHawk updates user profile and theme based on shared dashboard profile
-DB2 public schema table shows up in another schema
-With visual query builder, custom formula column is giving error while trying to use with summarize data
-Group by on data grid not working
-Save query with override is not working and giving null error

DBHawk 6.6.3 Release – December 22, 2023

New Features
-Allow to delete job execution history on the Admin screen
-Allow users to upload csv files to the their file manager
-Allow to share SQL query results with another user as a CSV results with export
-Add a feature on Table data browser to view data with the foreign key
-Allow Admin to run any jobs from the Admin job screen
-Add a feature to configure and display license expiring warning on the admin screen
-On DBHawk V2 API add missing azureAdAuth and autocommit properties on the datasource

Bugs
-While Duplicating Job – End At field is Disable

Improvements
-Change background color for SQL Query Builder for dark theme
– Add support for NOT EXISTS and SIGN functions with Oracle ACL
-Add database field on PGSQL connection screen for a new connection and update connection
-Add filter on file manager files
-Develop a feature to store Job success/failure details into the database when it cannot send email notifications
-Add Subkey ID field for PGP encryption for jobs dialogs.
-All charts, dashboards, snippets should show latest on the top
-To improve the job history screen performance for each database job history, load only Active jobs by default
-Fix various issues with Snowflake database
-Add file size/number of rows as well as file name on the notification emails for when a job is successful
-Disable IP address lock feature by default
-Allow LDAP settings search for groups outside the user search path
-Allow DB2 database auto commit value to change on the database connection
-Add a cancel button on new connection screen
-When Show Login Box is enabled, allow to pass database username and password to the runSQL API call
-Arrange all menu items in the alphabetical order for DBHawk Setting
-Add new V2 API to add connection to the group
– Add new V2 API to remove connection from the group
-Improve API logs to make sure whenever possible user name and db user name information is logged
-Improve data grid on the dark theme
-Improve users and groups search with wildcard
-Print Log message when user create ACL via API in the log file

Bugs
-While Duplicating Job – End At field is Disable
-DBHawk Setting screen section is not visible with the dark theme
-Databricks queries does not run without providing full schema name and catalog name
-SQL Query Builder wrong behavior with multiple drag and drops of same table
-Pagination: Sequence getting started with 1 from next page
-Export to JSON for Oracle is giving error
-Autocomplete is not showing all column names
-Job Pop up not getting closed when moved to File Manager Screen
-Oracle DDL fails when the table name has special characters like . in the name
-DBHawk is not allowing to insert or duplicate rows with identity column for SQL Server database
-DB2 export as insert statement is not working when filter applied
-Do not allow to change auto commit for redshift database
-Redshift is throwing error when custom domain name is used for endpoint
-Fix various issues with Dynamodb
-Missing session id log information for file downloads
-When DBHawk cannot read the license file in dbhawk_data folder, it throws code error
-DBHawk allows to upload files with special characters

Security
-Enhance DBHawk security to make sure all access controls are implemented with the server-side. This will not allow any unauthorized access to databases, groups, or any other features
-Fix various DBHawk settings on the setting screen and other places to prevent XSS
-While 4xx or 5xx error occurs, do not reveal server details

DBHawk 6.6.2 Release – September 14, 2023

New Features
– Support dbhawk config with customer database – MySQL
– Display PK information on Data edit, new row sceen
– Support materialized views with PGSQL
– Add a feature to get the list of blocked IP address and also allow to add or remove IP address from the list with V2 API

Improvements
– DBHawk load datasources, users, user groups very slow with many ACL policies
– Change cron job to not to run for less than minimum time setting
– Allow Datasource search with Datasource name and label name both
– MySQL and other databases batch import does not show how many records has been inserted
– Provide feature to hide pg_temp schema for PostgreSQL and Redshift databases
– Fix various critical dependencies
– Allow job history to display all job including the one which has no history also
– Add filter bar on table data viewer-Add alert on the data/structure modifications buttons
– Flag tab with uncommitted results
– Oracle Package Bodies management to see list of functions included in the package body with a link to it
– Add information about job is compressed or encrypted on the job screen
– Import job does not show what database table its importing data
– Allow to copy cell value from the result data grid
– Display length of varchar column on edit and add new row screen for PostgreSQL

Bugs
– Procedure/Functions with same name but with different parameters do not load correctly
– DBHawk job is not running for CSV/PDF/TEXT for Databricks connection
– With databricks jobs, it produced wrong output
– MySQL show login box connection is not working with the secret manager
– DBHawk settings screen allows to change value such a way that it can become boolean values
– Export PDF is not working with chinese characters
– Job Log writing whole exception stack error in the Job Logs
– Import: S3 – Unable to Import Job with Developer User Type
– Password policy not applied on Profile screen
– MySQL Is giving bad SQL grammar error
– API: Implement/Add lock property on Create/Update and Get User API
– PostgreSQL XML value truncated on the edit screen window-PostgreSQL Sequence wrong validation
– PostgreSQL View data is giving error with data
– PostgreSQL Insert/Edit screen shows wrong values for XML record
– PostgreSQL Export JSON is giving wrong output
– PostgreSQL all indexes are not listed
– PostgreSQL shows duplicate constraints
– PostgreSQL shows Wrong constraint name
– Type of constraint is missing on PostgreSQL create new constraint screen
– PostgreSQL missing various data types on create table screen
– Add a checkbox to create a view as Materialized view on a PostgreSQL screen
– PostgreSQL Create procedure errors
– PostgreSQL Function is located under Procedures
– PostgreSQL Materialized view indexes are missing
– PostgreSQL Trigger exists but not listed in menu Triggers
– PostgreSQL create new procedure screen is not working
– PostgreSQL create new function screen is not working
– Allow window functions for schema with ACL with Oracle database
– PostgreSQL create trigger screen is not working

DBHawk 6.6.1 Release – July 24, 2023

New Features
– Allow to deliver jobs output files with encryption
– Allow to delete user with API whose last activity is older than 30 days
– MongoDB: add export button for filtered collection
– Allow ACL to do the subquery

Improvements
– Add a cancel button on the LDAP test screen to cancel the operation
– When there is another SQL and running explain plan with the selected SQL, it does not work
– Display latest report on the top
– Logout Redirection for HTTP User
– Allow users to view shared snippet SQL
– Turn on auto complete SQL for databases connection with ACL
– Display joins for PostgreSQL databases with SQL Query Builder
– Add refresh button on all PostgreSQL sequence screen to get the latest values from database
– Rename maximum records label to maximum rows
– Increase panel width in Enable/Disable Constraints/Triggers

Bugs
Databricks shows default schema 2 times
– MongoDB atlas connection shows JDBC URL text and do not allow to test database connection
– Fix various issues with date only and date with timeStamps data types
– User id is missing in SQL query log
– MongoDB Atlas: Unable to Create Duplicate Connection
– Postgres update insert boolean value is not working
– If User run manually job before the next run, next run value getting blank
– Change commit message for auto commit connections
– For duplicate jobs, in the backend database – it is not writing a copy with encrypted SQL
– When multiple SQL and User click execute at cursor and click on Explain Plan, it is not working
– MongoDB Import of large data failed
– PostgreSQL Date Data Type values are lost after update
– Table data still shows lot of space between header and data
– Applied filter condition is no more displayed in the Filter popup
– While editing data through edit data window, it’s not showing correct data format based on the DBHawk setting screen
– With different date and time settings, DBHawk is not allowing to insert new data in the MySQL database
– Row count with Oracle table name with mix case is not working
– Oracle create view has a different preview SQL value and cause SQL to fail
– PostgreSQL sequence current value always display 1 and does not display correct values
– ACL is not allowing to call function within Oracle package
– Create job button is not visible on a small screen
– PostgreSQL is not showing PK and FK for some users due to permission issues
– PostgreSQL Text Data Type values are lost after update
– Oracle Line update raises a blocking error when decimal values are separated by comma
– Mozilla browser is not showing X close button and other things on the light theme
– DBHawk displays wrong data with SQL Editor for Azure or SQL Server
– PostgreSQL connection info has some extra white space
– MySQL database data corruption after update -empty values replaced by NULL values
– Problem with columns that use reserved keywords
– Display NULL values for edit and new screen with (NULL) placeholder
– MySQL database problem with export insert for text data type
– Zip file and gz files with password is not working

DBHawk 6.6.0 Release – June 9, 2023

New Features
– Add Google Cloud Secret Manager integration
-Add a copy/duplicate job feature
-Add end time for the DBHawk jobs
-Add runSQL API support for all databases

Improvements
-Make Candlestick type Required
-Fix Explain Plan screen
-When there is another SQL and when we run Explain plan with the selected SQL, it does not work
-With ACL SQL query is sometimes not working when there is no ; at the end
-Increase the LDAP Filter and SAML group filter character limit to 4000
-RO and ACL icons are missing while trying to choose ACL Connection
-DBHawk job shows status running when DBHawk is stopped while running
-Remove test data source api
-Fix databricks connection with new driver
-Allow to choose date format option for DBHawk report

Bugs
-Some Version 1 APIs are not working with tomcat9 Java 8version
-SQLRunner is not working with the latest 6.5.8 Mail Libs
-Fix console error with MongoDB
-Issue with Oracle Date format
-DBHawk job is not allowing to store more than 7 or 8 emails
-Oracle create procedure is not working as expected
-SQLRunner is not running with Java 17
-Mongodb Atlas is not working now
-MySQL is not displaying values and displaying as a wrong data type
-Some complex queries with Oracle database is not working with ACL
-Azure AD is giving error
-When you create a new group with Data source it is not adding a default flag
-DBHawk create job button is not displayed on the small screen

DBHawk 6.5.9 Release – May 1, 2023

New Features
– Add a new security policy to enforce password strictness
-Create a new API which will only allow DBHawk administrator to run SQL queries
-Support for secure DBHawk metadata SSL connection

Improvements
-Allow xlsx-report result with multiple queries on each excel sheet
-Add Swagger API URL on API Screen
-Add group filter on SAML settings
-Change auto generate password method to support DBHawk new password policy
-Chnage DBHawk native user to SAML user when user login with same username using SAML
-Change link color on the dark theme to white
-Change SAML label for login to SSO
-Oracle call procedure function missing schema name
-Add select statement with Oracle view
-With Expose API data with PLSQL code run for Oracle add checkbox to run it with DBMS_OUTPUT
-Allow Oracle PLSQL Functions and Procedures to run with ACL
-API access should be restricted to the users who created API and the connection they have access to
-When connection is read only, allow only SELECT statement with API

Bugs
-MySql: Decimal (dataType-Double) values are not displayed on DbHawk
-DBHawk is not showing correct group label on Edit user group screen
-Empty job is still returning results
-With API creating new user group should have default value = Y for the active flag
-When show login box is enabled on datasource and when login to connection, it logs wrong information for userid
-When you try to format query with column name = record#, it adds space between record and #
-DBHawk adds extra quotes into SQL Log file
-ACL Does not allow to revoke whole schema
-When Authenticate with API, it’s not logging user id
-DBHawk does not create backup database with HSQLDB SSL Connection

DBHawk 6.5.8 Release – March 23, 2023

New Features
– Add new V2 API to test connection with SQL
– Provide a feature for Redshift database to not to change default search path
– Create new UI to manage DBHawk V2 API tokens and other details
– Develop a feature to get database password from the AWS Secret Manager and Azure Key Vault
– Add Swagger support for V2 API
– Add new log file to log API call details
– Add Funnel. Histogram, Candlestick new charts support
– Add Dark/Light Icon and change profile based on that
– New feature to Lock DBHawk account access with wrong passwords or usernames attempts
– Allow SQL Server Azure database to connect with Azure Active Directory credentials with two factor authentication

Improvements
-Remove alert job type from jobs
– Query-Builder: how to change relation/join settings again
– Improved PDF generation with the report and also with the export data
– When user click on run job now, open Job history screen after clicking on the button
– On add ACL screen connections apply case sensitivity
– Add fetch data features for all databases
– When SAML private key is stored and checkbox is checked, maintain that key value while upgrading other values
– Remove DB2 connection type and use generic type instead
– When running Oracle proc or function with the parameter screen, display status message
– Allow user to expire by time instead of date
– Allow Oracle aggregate functions with ACL
– Add number of records that were produced with each job run
– Allow DBHawk to use Public Synonym for the DS_PLAN_TABLE
– Support for AWS athena tables and views
– All v2 API must be accessible by only admin role users

Bugs
– While importing users with SAML or AD, DBHawk should check the existing local user for duplication
– Oracle ACL is not allowing to select more than 1000 objects – and throwing Oracle ERROR ora-01795-maximum-number-of-expressions-in-a-list
– Report is truncating column names in a output file
– Search on ACL Objects screen is not working as expected
– Column shifting issue at the end with many rows and columns of data

DBHawk 6.5.6 Release – December 20, 2022

Improvement
– When downloading multiple files from the File Manager, log each file name
– When authentication is uncheck on email, remove entered username and password
– DBHawk Cron jobs are not running at the desired scheduled time
– Allow Insert with SELECT statement with ACL
– Upgrade various java libraries based on recent Java Vulnerability scan
– Add a feature to cancel long running job
– Add Search, Filter and pagination on the Job Scheduler screen
– Memory consumption optimization for Job export to PDF functionality.
– Add the filename on the log message for the job
– Oracle with large data set query taking long time on Windows – Add Fetch rows on the database connection
– For Oracle explain Plan table various changes

Bugs
– Fix Import Data Issues
– SQL Server generate DDL does not work with different collation
– DBHawk Single row viewer on SQL Editor results stopped working
– DBHawk jobs are not working when SQL has comment in it
– Error while viewing MongoDB Data
– SQL Editor window resize issue
– Report preview is not working
– SFTP job is not clearing files from the temp directory
– When you update query on the job screen, it is not closing the window
– Cron job it is not showing correct details on the admin job history screen
– Cron job is not running on First Run time or Scheduled Time
– Explain plan is not working for SQL Server database
– Customer cannot access any tables in PGSQL databases when database name is with the mix case
– Sort on the job history screen is not working when filter is applied
– SFTP job is not working with the zip file

New Feature
– Connect to SQL Azure Using Active Directory Authentication
– Add username password window for ACL
– Add Display of Sequences for SQL Server database
– Explain Plan enhancement for SQL Server
– Allow DBHawk to communicate and encrypt/decrypt SAML response with IDP via private X509 cert
– Provide feature to name a job output file and also the report output file
– Allow CSV and Txt output job files to choose various settings for the data
– Add Cron job expression validation for Cron Jobs
– Add option to run any job manually with new button called Run Now
– Allow SQL Editor to show multiple results in a horizontal tabs
– Add deleteGroup API
– When there is no data found for the job query, do not send empty files by email or sftp

DBHawk 6.5.5 Release – October 17, 2022

Improvement
-Do not allow to kill session or stop query on the PostgreSQL read only connection – session manager screen
– Upgrade SQL Runner spring libs for CVE 2022-2950
– PostgreSQL is missing column type details on the edit/insert row screen
– Change post deleteACL to DELETE acl API
– On PostgreSQL Constraint screen, reference table name is missing for FK details
– When connected to database, on the tab title – add DBHawk database name
– Add partition details for the PostgreSQL tables
– SQL Server DDL is missing constraint name
– Fix PostgreSQL Session information with correct setup during connection
– Fix DDL For PostgreSQL
– Allow to download multiple files from the file manager
– Show log files with sort by date
– Change order for Job Start and End Time and description in DBHawk settings screen
– Support for SQL Runner with Oracle Data Guard connection
– When for some reason job creation does not work, display message to the user
– Job Logs improvement Merge dbhawk_job_log and dbhawk_job_sql.log files to only one file name: dbhawk_job.log

Bugs
– PostgreSQL ACL is broken with new tables changes
– Redshift query jdbc error message String out of range error
– DBHawk Create User auto generated password is not sending email
– PostgreSQL data duplicate is not working
– When DBHawk connection details are wrong, it goes into infinite loop and prevent DBHawk to access other screens
– PostgreSQL SQL Format is not correct
– SQL Server Dependencies are not listed
– With latest PostgreSQL 14.5-1.pgdg18.04 – Sequence is not working
– SQL Server DDL is missing the foreign key constraint and also the cluster-keyword for the primary-key is missing
– For SQL Azure DDL shows all columns will be generated as Nullable
– DBHawk is not showing full explain plan for SQL Server
– Cannot edit sql server date fields
– SQL Runner is not setting correct user through ALTER SCHEMA
– When email setting has a wrong password, it gives NLP error
– SQLRunner not showing correct error when issue connecting with the Oracle database
– DBHawk max rows and default rows logic does not work when try to upgrade both records at the same time
– Import job is not working – Getting error about directory does not exists even though directory is there
– DBHawk Import job is causing all jobs to disappear
– Header and results are not aligning with zoom or under zoom

New Feature
-Job Scheduler need a new option to save output file FORMAT as a .txt
– Add select SQL and comment out feature on SQL Editor
– Add Referentials feature for SQL Server
– Add new API to get single connection details
– Add new API to get single group details
– Develop an API to delete a single user group
– Develop and API to remove user/users from the single group
– Add get API to display all details for the DBHawk user
– Add new API to list only DBHawk usernames
– Add delete ACL API
– Add new API to get one ACL policy details
– Add new API to create new ACL policy
– Create a new API to add users to the group
– Add button to run explain plan on PostgreSQL session manager SQL
– Add PostgreSQL version information in Connection Info Screen
– Add parameters screen for Postgres
– Allow jobs export to set delimiter for CSV export
– CSV export to file manager

DBHawk 6.5.4 Release – August 4, 2022

Improvement
-DBHawk is not supporting SQL Server Case Sensitive databases
-Display read only or Oracle error warning for PL SQL run call
-Display production environment name with rectangle border with the color as per the settings
-On the File Manager change the job output directory label to data (jobs)
-Change job error message when job run successfully but email fails
-Upgrade netty-codec library
-Remove or upgrade jackson data bind lib reference from htrace-core.jar file
-DBHawk stores license on dbhawk/conf/ folder with connection to a remote db
-Add Oracle to connect with the JDBC String to support Oracle Data Guard connection
-Name dashboard and snippet export file name with the dashboard name and snippet name

Bugs
-Encoding issue with upload SQL File
-Error viewing external Redshift tables
-DBHawk Code formatter is not working for Oracle PL SQL Code
-Oracle stored program wrong code formatting causing status to invalid
-Oracle procedure and functions must use arguments from dba_arguments with object id
-Create or replace with Oracle should work with next line or any other combinations
-Certificate on SAML should be a required field
-Snippet and other data export must enforce maximum rows limit
-New data source connection to the new group gives 500 error
-With load more packages and package body is not working for oracle
-With load more stored programs, it is not displaying the code
-Scrolling does not work on stored programs sometimes and code format is different than what is stored in database
-Getting Blank Index dialog box with Oracle index

DBHawk 6.5.3 Release – June 3, 2022

New Feature
-Add Oracle Data Guard connection capability

Improvement
-Allow to edit run once job
-MongoDB Collection names sort with alphanumeric
-When search user on users screen, trim the entered text
-Move logo file location for report to report directory
-Display Redshift table column comments on column information tab

Bugs
-Snowflake connection is not working
-When DBHawk is running with remote DB, it stores license file in a conf directory
-With SET_CATALOG_ROLE replace ALL_ with DBA_ and display missing details for all oracle objects

DBHawk 6.5.2 Release – May 10, 2022

New Feature
– Add explain and explain analyze for postgres
– Develop PGSQL Lock Monitoring
– Develop session monitoring for PGSQL
– Develop a screen to run Oracle stored procedure and function
– Set various settings for Group to override default settings

Improvement
– PostgreSQL JDBC Driver Vulnerability \(CVE-2022-21724\)
– Add SAML Cert verification during SAML creation or update
– Various Netezza fixes
– When Job Module is not working due to some url or other issues, do not allow to create job at the first place
– Upgrade spring libraries
– Upgrade Xtream library
– Display default folder on the right side on the File Manager
– Allow to edit queries while Query is Running
– jQuery and Bootstrap upgrades
– Save dashboard file with Dashboard name
– Add job id in Job log files
– DBHawk job with password zip file does not allow you to change the password
– Save SQL \(Create Table SQL\) Name as SchemaName.sql
– Reports that have multiple queries, allow to change the order of the queries
– Dashboards – use the parameters specified in the queries associated with the charts.

Bugs
– Saving My Queries sometimes gives Error:500
– Oracle functions procedures and packages are not displayed for other users
– MongoDB is not able to import some collections and giving 500 errors
– Job is not deleting after deleting some jobs
– Referentials dialog box is not opening
– “Insert statement” has minor syntax error
– Commented row is not grayed out for MySQL

DBHawk 6.5.1 Release – March 29, 2022

Improvement
– SQL Editor – Copy cells results from the Grid and allow to paste on Excel
– SQL Editor -Copy Results with CTRL C
– SQL Editor -Allow Shift+tab to reverse tab
– Change tab behaviour on SQL Editor for multiple lines
– SQL Editor Scrolling Jumping the cursor
– Display Total rows with filter on the table data
– Export-Import Logger Improvement
– Allow Oracle DDL to include all table details
– When error with job, still show SQL in log message

Bugs
– MySQL: Table Data Export\(html\) with Special Characters is not working
– Redshift object browser, if you attempt to select a stored procedure and view the definition, DBHawk will display an error. This is happening with same procedure or function name but different parameters
– Snippet export is not working with Redshift
– Multiple SLF4J: Class path contains multiple SLF4J bindings causing error

DBHawk 6.5.0 Release – March 2, 2022

New Feature
– Allow to generate DDL for oracle table with grants, triggers, constraints – all in one
– Allow job to automatically store data under S3 bucket
– Dashboards – Support dashboard with the parameters

Improvement
– Improve Job history search with ID and other search
– Allow Multiple Emails in Job
– Change db logs order by desc date
– Change log4j properties file for db logs
– Log Message should be Implemented for Share query Functionality
– Inappropriate validation message displayed \(While creating Duplicate Name UserGroup)\
– Pagination in Manage User Group Page
– Remove unnecessary directory setting from SQL Runner setting screen
– When DB Is read only, do not allow SQL Runner utility to run insert/update/delete/truncate SQL
– Job log should capture actual report error
– Report TabName is Static\(report5\)
– Job Scheduler screen is taking a long time to load

Bugs
– Oracle: Explain Plan is not working with commented Where clause in a SQL
– DBHawk shows tables from other schema for MSSQL
– Query Builder is adding extra space for various databases such as MSSQL, MySQL Etc.
– Multiple email address causing job to stuck
– Snowflake Query Builder is not working
– Load More objects is not working in certain cases
– Upload file is throwing error on the console
– Faded Pagination displayed in DBLogs
– Connection Search is not cleared
– ACL Is not allowing Subquery
– Oracle create user password with special character is not working
– Mask data acl should not allow to use WHERE clause when query does not return results

DBHawk 6.4.9 Release – February 1, 2022

Improvement
– LDAP Apply filter on the group while importing users
– Update log4 libs to the latest version – Log4j 2.17.1
– When job is paused or restarted, log events

Bugs
– User cannot see all his saved query