DBHawk Release Notes
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
DBHawk 6.4.8 Release – December 17, 2021
Improvement
– Display user role information on the profile screen
– Various Query Manager enhancements - Added lazy lading, Excel import export for saved queries
– Change Job Owner change UI
– Rename SQLPLUS utility to SQLRunner
– Email setup should not depend on a Job module
– Support SQL Runner settings with DBHawk
– Add delivery column on the main admin Job History screen
Bugs
– While changing Job Owner for the job with the report, it's not changing owner for the report
– When Email setting is open and clicking on the Profile update button, it shows Login Error
– CSV Export is not exporting all data for Redshift
– Missing S3 in s3 job notification
– Alias is not working with ACL when alias name is with / e.g percentage/investment
DBHawk 6.4.6 Release – November 12, 2021
New Feature
– Allow Admin to change job owner from the Admin Job Execution History Screen
– On Admin Job History screen add new features to do various search with the filter
– Allow to display DBHawk environment - Customer should be able to name the DBHawk environment and also change login box color to distinguish environment
– Add search group feature
Improvement
– Tag value is missing in DBHawk table log grid
– Reduce edit and new row max height to 70% -
– MySQL Text column needs to provide accessing data with the text area while accessing with SQL Editor
– LDAP Enhancements - Allow LDAP without auto sync to avoid importing many groups. Also add a feature to apply 2FA for all imported LDAP users.
– Provide support for MySQL JSON data type
– Close connection should release DBHawk temp cached files
– Change dateFormat label to date with time format
– DBHawk is not able to load UTF-16 LE and other file formats. Add auto detect file format feature to load various files with different format
– Test and fix DBHawk connectivity with MongoDB 4.4
– Improve DBHawk settings screen - Create various settings groups to make settings screen easy to work with
– Show query for failed jobs on Job history for reports - customer
Bugs
– LDAP User Job is not working
– Job history is not working due to some special character issues
– Duplicate label is causing ACL issues
– License Expire screen is not working
– Export data with NULL adds extra quotes
– While exporting more than million rows on Redshift as excel, it gives memory error
– Logging import job SQL
DBHawk 6.4.5 Release – September 24, 2021
New Feature
– Add compress job output and password protect feature
– Allow to export job data to S3
Improvement
– Add Job ID to the job screen and history screen
– For Redshift export, do not run query twice
– Set default database to DBO for MSSQL
– Implement ‘dateFormat’ and ‘dateOnlyFormat’ settings for Redshift and PostgreSQL
– Set the default database on a create login to master
– Add new DBHawk setting for S3 root bucket
– Result pane is not adjusting height when you move the size
– Improve main login screen
– Implement same changes as SQLCMD for SQLPLUS Also
– Name backup file with DBHawk and database version
Bugs
– Job with create table as select from other tables is not working
– Alias with _ (under score) is not working with ACL
– When open a SQL Editor and click on Object resize window - it messes up the screen
– Postgres Export Insert functionality is not working
– Incomplete Data in Exported file \(HTML\) \(schema/after query execution\) for Postgre DB
– Unable to open Exported file \(Export XLSX \)\(schema/after query execution\) for Postgre DB
– File manager access is showing local IP
– Cannot access link for some jobs
– MSSQL Import is failing for table with $ sign in a name
– Max rows is not correct for T-SQL or insert into statement
– User login roles is not selecting correct database
– Single statement parsing issue with SQL Server
– When job fails, it does not show next run
– Job history from admin screen not showing any history for the first time
– Report is not working with data type year
– Teradata load more is not working
– MySQL displaying wrong time in timestamp column with report
DBHawk 6.4.3 Release – August 9, 2021
New Feature
– Automatically purge old job history for Admin User
– Allow to update user without any group
– Create a UI to show users for the group and also allow to remove users from the group
– Add Show SQL on Logins create and update screen for SQL Server
– Add Show SQL On Create and Update MSSQL users
Improvement
-Do not allow to delete log and backup files from the admin screen
– Allow group without any datasource
– SQL Server logins create and update is not working for SQL Server version 2008 R2
– Update the Error Message when user tries to input invalid username and password
Bugs
– Redshift import is not working as expected
– ACL on MSSQL allows to display view names even there is no access
– Connection timeout on some db connection cause other connection in wait mode
– When try to clone datasource and datasource with name already exists – give proper name warning to user
– MySQL Report date is wrong
– Load more is not checking ACL and displaying all tables
DBHawk 6.4.1 Release – July 12, 2021
New Feature
– Develop SQL Runner utility for SQL Server
– Add query tag column to db logs -SQL Server
– Job History screen for Admin
– Add new setting flag for enable disable API
– Snippets with another snippet as parameters
Improvement
– Allow UNION AND UNION ALL with SELECT with ACL
– Add support for Various T-SQL Commands for SQL Server
– Change file manager files sorting
– Improvements for SQLCMD utility output
– Various improvements to SQLPLUSRunner utility for SQLCMD and SQLPLUS
– Add 2 new icons for groups and SAML on Admin home screen
– Allow users to delete data from File Manager
– Move User Query History and Saved Query details to the database
– Add elapsed time, data source name to job history
– SQL background utility logging
– Change DBHawk backup with dropdown values
– Set SAML ACS url based on DBHawk hostname
– Move Job Notification Fields to below Internal
– Add Sign in with SAML login display on the main screen when SAML is enabled
– Allow Oracle built in functions with ACL query
– SAP-HANA add limit to display tables
Bugs
– DBHawk error when DB is integer with auto generated SELECT
– Okta user with a long group name is not showing group name error
– Save query is not working for DynamoDB
– DBHawk is not supporting us-east-2 for DynamoDB
– MSSQL Error with database name as integer values
– MySQL is not allowing to update records with composite PK
– PostgreSQL data import is not working as expected
– Incorrect sql syntax in MSSQL
– Hide Insert Statement and Update Statement for Analyst User
– DBHawk upgrade with ACL is not setting default value for export caused NLP
DBHawk 6.3.0 Release – May 24, 2021
New Feature
-Add new flag in settings to use single stmt parser for sql server
-New DBHawk setting for enable/disable File Manager
-Add logging for file manager activities
-Customer -Add query tagging feature – only for SQL Server
-Add User directory manager and file sharing
-Develop Job History page to display job run status with log details for each execution
Improvement
-Need SQL Server parser changes to allow multiple SQL statements for SQL Server
-Applying encryption key logic when updating DBHawk with SQL changes
-Job notification – Add for job success and failure
-Job or report should not send empty files in email
-Allow option to disable import csv with ACL
-SAML Override group changes
-SAML integration improvement for group claim
-Fix log file names and change size
-Restrict dashboard open access with the link
-Add Delete ALL on Saved Query
-Autocomplete should also add views
-When masked data makes connection read only – do not allow to remove read only on data source
-Allow to clear SQL Query History
-Do not change SQL Editor window height for each SQL Execution
Bug
-Adding masked column doesn’t make ACL connection read only
-Do not allow to use slash symbols / \\ in job names
-ACL Is not allowing to use brackets with the join condition
-MSSQL and other databases job edit is not working
-We should not allow to create same user with a different case
-ACL is not displaying Views when selected all objects for the schema
-Fix SAML setting changes log details
-Getting error 500 on view sql results
-DBHawk is not displaying Oracle package when spec is open
-DB Logs not saving logs with Oracle connection
-Autosuggestion deletes table name
DBHawk 6.2.0 Release – April 6, 2021
New Feature
– Add new API to update user
– Allow user to choose file encoding while uploading data
– Support Oracle BLOB data in SQL Editor with query
– Once ACL has applied on data source, display information on data source grid
– While running DBHawk upgrade. run DBHawk backup first
– Change DBHawk upgrade message
– Display Table comments
– Show datatype information on the results grid header
Improvements
– Display ACL/Read Only on Connection tab
– Fix auto complete issues
– Change POST /api/point to POST /api/add-data source
– Create new api – post/api/remove-data source
– BLOB data display auto file detection
– Read write ACL does not allow insert update delete with SQL editor
– Monthly Schedule Job change to 30 days and also add label
– Add Commit and rollback command with RW ACL
– MSSQL SQL Parser changes to allow go to statement and also SQL statements without ;
– Remove un-used JS calls
– Save query as submitted
Bugs
– DBHawk job schedule ignore repeat interval value
– SAML long group name auto import causing DBHawk to hang
– Display proper error message with SAML/LDAP Integration
– Job lock DBHawk while updating job details
– Fix DBMS_OUTPUT issue with a function call
– SQL History is not saving all queries
– Update is updating number of rows and displaying wrong number of rows updated
– Query with / getting saved automatically instead of saving as query history
DBHawk 6.1.0 Release – March 4, 2021
New Feature
– Allow to export and import users query
– Add search feature on User query history
Improvements
– API Cleanup – API with default values
– Use upper case with Oracle create tables or new objects
– Allow receiving user to delete shared query
– Add timer while loading long raw data on Oracle
Bugs
– Create User API Expire date is not working
– oracle Rowid column not working
– oracle object filter search is not working with lower case objects
– SAX lib upgrade causing issues
DBHawk 6.0.1 Release – February 23, 2021
New Feature
-AMI User fields for RDS and Redshift
– New role change with API
– Changes for Snippet
– Add create table screen feature for redshift
– Add new DBHawk User Role – Analyst
– New API to change group
– Add EDIT columns feature for Redshift
Improvements
– Remove index from Redshift
– Not logging Oracle user creation
– Query Saving is very slow
– SQLPlus background utility should check user email address before submitting a job
– MongoDB not working with Jackson lib changes
– Update user email address with profile should not require user to logout and login back for the effect
– Allow to set logout page
– Create user API call for admin user with expire date
– Time display issue – Redshift database
Bugs
– MongoDB SQL stopped working
– Export: XLSX export doesn’t work with MSSQL-Azure
– When deleting user, it should give user name warning
– DBHawk displays table name which should be not accessible with ACL
– Issues with Redshift UDFS
– Redshift timestamp columns are causing error
– LDAP is not working with new libs
– Unable create a report based job
– Save queries got overwritten by query history query
– Creating stored program with redshift issue -customer
– DBHawk cannot connect to LDAP and goes into infinite loop when cannot find login user’s group
DBHawk 5.6.0/5.7.0 Release – December 17, 2020
New Feature
– Add user query history
– Add Run vacuum analyze or other maintenance tasks by right clicking on the table or similar interface
– Add option to disable or copy all data with ACL
– Add SFTP to job
– Add AMI Users support for Redshift, Athena, DynamoDB
– Allow to store access and SQL logs in database tables
Improvements
– Change max number of data source warning logic
– Add username attribute with SAML
– Fix sorting order for Redshift schema list
– Job module https access issue
– Disable local DB startup when remote DB is running
– Upgrade various libs as per the security scan report
– Auto import groups with dynamic flag for LDAP and SAML Integration
Bugs
– ACL: snippets does not work if SQL disabled
– Permissions on ACL is not maintaining state while updating
– CSV Scheduler Job producing empty files
DBHawk 5.5.0 Release – September 14, 2020
New Feature/Improvement
– fix dark theme style for mask acl
– add ACL or some icon to indicate connection has Object Access control policy
– Add some indication to show DBHawk groups are LDAP groups
– Allow bulk delete on datasource screen as we have on users screen
– In-Active group
– Adding/Removing MSSQL Users
– Change max number of data source warning logic to warn before adding data source
– User default profile is not visible
– ACL: “Find objects” doesn’t work
Bugs
– ACL: Catalog value is always empty in the list of ACL
– Report: Null message shown when opening query window. (ACL applied).
– ACL: Unable to change acl settings for Masked column
– When you update the group name – assigned group to user keeps the old name
– Redshift: Masked column of a table with space in name can be queried
– ACL: Masked column can be queried with WHERE clause
– Masked data is readable via sql column alias
– Managed to get masked data using Join
– Masked data can be retrieved using WHERE masked_column IN
– Masked data can be retrieved using column reference
– NULL values in masked columns ignored
– It doesn’t quote objects in SQL query in Oracle
– SELECT * FROM doesn’t work for Oracle connection with ACL
– Unable to mask view in Teradata
– Managed to use WHERE clause for a Job in MSSQL
– SQL SELECT doesn’t work with ACL
– Error while trying to change schema on MSSQL
– MSSQL SQL DDL generation missing columns
– Data source sorting on label give error
– When MongoDB Connection open – it times out other open connection
– Postgres. Masks. Empty values exported
– Mssql. Acl: Managed to write masked data into a table using SELECT INTO statement
– Various ACL Issues on build 5.5.0
– ACL: issue with “Grant All” option
– ACL Postgres: Row data window is empty for masked tables
– SAP: Query builder doesn’t work for views
– ACL: UI issue
DBHawk 5.4.0 Release – July 13, 2020
New Feature
-Support for Snowflake Database
Bug
-PUBLIC schema access with Oracle ACL
-ACL Permission does not allow to modify same job
-Issue with SAML User – Error while saving profile
-Describe on Oracle cause connection to run forever
-Allow LDAP to connect to the group without case restrictions
-Redshift: SQL query throws an error if ACL applied
-ACL: Can’t proceed to the next step in MSSQL if catalog wasn’t selected
-Commit button doesn’t work on the SQL Tab
-Snippets/Dashboard doesn’t work – Error with session
-Snowflake SQL editor is not using the current selected database
Improvement
-Allow contains search on group datasource assignment
-Modify search on Datasource and Users screen from like to contain
-Change group Icon
-Give warning on MSSQL Login screens while locking/unlocking users
-New User screen on the MSSQL improvements
-Add load more on scrolling on Connect to database dropdown
-Add filter and sorting on the group screen
-Rename Manage DBHawk Users menu name to -> Manage Users & Groups
-Any database user creation with password must not log plain password text in a log file
-Redshift is not supporting spectrum schemas and tables
DBHawk 5.3.0 Release – May 4, 2020
New Feature
-Support for DynamoDB
-DBHawk Dark theme selection.
-Security Key Rotation
Bug
-Scheduler: “alert” Job type is not working
-SQL Query is not working without alias
-Presto SQL Query Builder is not working
-Remote database backup is not working
-Issue with the snippet security
-Fix average and other function display on Cassandra
-Chart title supports HTML tags
-Fix object access control policy for MSSQL
-Autocomplete on describe is throwing NLP
-Various API Issues
-Cannot Delete User
-Cannot delete data source – getting constraint error
Improvement
-Enable Export All for Excel
-Create dynamic logo settings to address all themes
-Redshift auto-complete SQL is not working
-Add pagination and search to the users’ screen
-create search and pagination on data source screen
-Add search feature to connection and Users dropdown when there are so many connections
-Multiple groups with some group inactive
-Scheduler time change issue
-Allow Describe and Explain Plan on MySQL read-only DB
-Change connection drop-down filter condition to “contains” instead of “begin”
DBHawk 5.2.1 Release – February 10, 2020
New Feature
[DBHAWK2-900] – Add New themes
[DBHAWK2-905] – Add Vertica database support
Bug
[DBHAWK2-897] – QB with MySQL not working
[DBHAWK2-898] – MySQL Constraint is showing errors
[DBHAWK2-901] – Cassandra Table Data Issue with Map data type and column wrong order
Improvement
[DBHAWK2-884] – When Data source information changed, add that information in dbhawk_user_activities.log file
[DBHAWK2-890] – About Screen
DBHawk 5.2.0 Release – February 3, 2020
New Feature
[DBHAWK2-860] – Allow admin user to login with only localhost
[DBHAWK2-878] – Upgrade DBHawk remote database automatically
[DBHAWK2-879] – Add SAML override group check
Bug
[DBHAWK2-776] – DBHawk Settings: “columnsNum” is not working.
[DBHAWK2-801] – Add support long password – for database authentication
[DBHAWK2-834] – Upload SQL adds * in start of the line
[DBHAWK2-842] – fix parameter issue
[DBHAWK2-845] – fix issue with hive
[DBHAWK2-851] – Add graph for SGA
[DBHAWK2-866] – API Issue
[DBHAWK2-880] – Presto is showing errors for some tables
[DBHAWK2-882] – Snippet is not working
[DBHAWK2-886] – Read only connection should not allow to insert, create or any other SQL except SELECT
[DBHAWK2-887] – Fix snippet max data rows
[DBHAWK2-889] – groups with same connection is causing error
[DBHAWK2-896] – snippet is not working in a new session
Improvement
[DBHAWK2-802] – Verify support of IAM Auth Type for AWS RDS
[DBHAWK2-843] – Improve data masking to display stars only for the value
[DBHAWK2-850] – Fix data masking error
[DBHAWK2-874] – Improve 2FA
[DBHAWK2-891] – Fix ACL issue when you drop ACL connection
DBHawk 5.1.7 Release – January 19, 2020
New Feature
[DBHAWK2-854] – Allow DBHawk to use MySQL as its database
Bug
[DBHAWK2-852] – Teradata is showing NO PK – while PK is there
[DBHAWK2-853] – Teradata is throwing lot of errors
[DBHAWK2-864] – Impala -DBHawk get stuck if it cannot connect to the connection
[DBHAWK2-865] – Fix email pattern issue
[DBHAWK2-866] – API Issue
[DBHAWK2-876] – Fix log for read-only database access
Improvement
[DBHAWK2-743] – Add last login tracking for all types of logins
[DBHAWK2-868] – Update Athena JDBC Driver
[DBHAWK2-877] – display label for database with group
DBHawk 5.1.62 Release – November 18, 2019
Improvements
-Fix for create connection API issue
-Fix for new user creation Email pattern issue
DBHawk 5.1.6 Release – October 18, 2019
Improvements
-Various backend changes for DBHawk support with load balancer
DBHawk 5.1.5 Release – August 19, 2019
Improvements
-Added open database transaction check with SQL Tab for Oracle database
-Improved Admin Security Login
-Various SAP HANA database related improvements
-Object Access Control now supported for SAP HANA database
-Display connection Label name while creating ACL
-Changed file upload icon
-Add a new feature to allow clickable data with html link in a data
Fixes
-Fixed copy data-source with null label value
-Fixed issues with snippet error message
-Fixed Oracle charts for Data Files and Tablespaces
-Fixed MySQL issue with reading user variable
-Fixed issue with the import error message
-ACL issue with data masking – Query Builder was showing an error
-Fixed error with renaming MySQL table when table name has reserved words (e.g order)
DBHawk 5.1.4 Release – July 8, 2019
Improvements
-Improved MongoDB Test connection – Now if MongoDB is not available, it will display appropriate error
-Default two-factor authentication – Now default the 2-factor authentication for new users, added a new property to the DBHawk settings screen activate2factorAuthenticationByDefault.
This property will activate 2-factor authentication by default for newly created users
-Improved SQL Auto-Completion Now auto-completion will work without the schema name
-Extended the width of the “Connect to database” combo-box
-Added label to the data-source to allow to choose label with connection to the databases
-Displaying a recognizable NULL icon when it’s null – Added this to distinguish NULL values and empty strings in a SQL result
Fixes
Fixed issue with the ACL – It was displaying create Job even though there was no permission to create a Job
Fixed the issue with show login box – It was not displaying data when user sign in with the login box with a different schema
fixed issue with the report – Report was not working when query has ; in it. It was giving /by zero error
Fixed the issue with the date format- If you change the data in settings, it was not changing the date format
Fixed issues with the MongoDB Collection when collection has dash or underscore in a name
DBHawk 5.1.3 Release – June 10, 2019
Improvements
-Fixed the issue with MSSQL data masking ACL
-Help file access to logged in user only
-Fixed Insert/Update table data issue
-Various UI issues with ACL
-MongoDB Shell improvements
DBHawk 5.1.2 Release – May 30, 2019
Improvements
-Fixed the issue with Job Module ACL Issue
DBHawk 5.1.1 Release – May 27, 2019
Improvements
-Fixed MongoDB Open stream error Issue
DBHawk 5.1.0 Release – May 20, 2019
New Features
-Added MongoDB Shell
-Added manage server roles for Windows logins
Improvements
-Fixed ACL Issue
-Fixed issue with F8 and auto complete
-Fixed Windows group under logins in the UI for MSSQL
-Other minor fixes
DBHawk 5.0.0 Release – April 26, 2019
New Features
-Multiple user group support for DBHawk users including support for Okta and LDAP
-SQL Window as a Tab and with new separate connection
-Universal data filter on SQL Window
-SQL Script execution at the cursor position
-Option to stop SQL Script at the error
Improvements
-Fix all rows export on the snippet
-Fix for LDAP group import issue
-Support for MySQL Latest version
-Reset SQL Window
-Add execution time on MySQL Results
-Fix for Performance issues with a large number of table columns
DBHawk 4.8.7 Release – March 18, 2019
New Features
-Added SQL Editor message tab to copy results
-Added new feature to allow storing audit logs in a MySQL database
-Added create Windows SQL Server Logins
-Support for OpenLDAP
-Now displaying user group in a User profile screen
Improvements
-Redesigned LDAP feature to import groups
– Fix schema refresh issue
– Fix Teradata long column issue
– Improved audit log
DBHawk 4.8.6 Release – Feb 22, 2019
New Features
-Added support to store logs in a MySQL database
-Added SQL autocomplete
Improvements
-Fixed export csv data issue for Oracle
-Fixed refresh button issue
-Added an auto-commit selection for MySQL
-Removed print button
DBHawk 4.8.2 Release – Dec 12, 2018
New Features
-Added Okta integration support
-Upgraded Redshift JDBC driver to RedshiftJDBC42-1.2.16.1027.jar
-Upgraded Teradata JDBC driver to 16.00.00.34
-Allow creating DBHawk user as an Okta user
-Added reports for Teradata
-Added Object access control for Redshift and Teradata
Improvements
-Disabled data edit icons for read-only connection
DBHawk 4.8.1 Release – October 17, 2018
Improvements
-Added parameters to charts
-Added PDF export for dashboard
DBHawk 4.8.0 Release – August 16, 2018
Improvements
-Re-write charts/dashboards to make it easy and intuitive for users
DBHawk 4.5.0 Release – May 08, 2018
New Features
-Added support for Presto
-Added query history for MongoDB
-user creation with temp password and expiration date
-Support DBHawk with Amazon Athena
-Export csv data for MongoDB
-Add chart and dashboard for MongoDB
-combo chart needs second y-axis
Improvements
-Various Query builder improvements
-SQL history Queries need a feature to name it
-make ACL intuitive and easy
-MongoDB connection info missing MongoDB user name info
-Add export data button on MongoDB Collection and apply date format on export
-add grouping and other things with charts
-add explain plan for Teradata
Bug Fixes
-Fixed issue with Redshift Query Builder
-fixed various issues with Hive
-In the “Query Builder” make SQL Query Window non-editable
-missing data on mongo table view
-Snippet reverse the multiple parameters order
-When removing a group with still a user in it give a ‘technical’ error message
-Fix for Oracle ACL
-an issue with DBHawk username (removed case sensitive username)
-various issues with SQL History
-dashboard first row with a single column is not working
-DBHawk charts are not working with YYYY-YY kind of year formats
-an issue with MySQL import data
-for metrics columns on the dashboard, a user should be able to create small height and width components
-MySQL update statment is missing one `
-hive export is not working
-hadoop is not displaying block information
-connection refresh issue causing a connection to change the name
DBHawk 4.1.6 Release – March 26, 2018
Bug Fixes
-Fixed issue with the new user notification
-added export MongoDB data with date format
-Data masking for Oracle database
DBHawk 4.1.5 Release – February 16, 2018
Bug Fixes
-Fixed issue with SQL Server Execution Plan
Added support for Cassandra
Added support for MongoDB Charts and Dashboard
DBHawk 4.1.4 Release – February 16, 2018
Bug Fixes
-Fixed Query builder issue
DBHawk 4.1.3 Release – February 8, 2018
Bug Fixes
-Some export features were not working due to java lib conflicts
-dbms_output with Oracle database
-fixed snippet parameter order issue
-fixed issue with MongoDB Upload
-Added new feature to rename SQL History Query
DBHawk 4.1.2 Release – January 24, 2018
Bug Fixes
-DBHawk user activities log files are not getting written due to an issue with slf4j-nop-1.6.jar file
– Workaround with 4.1.1 release is to delete this jar from lib folder.
DBHawk 4.1.1 Release – January 22, 2018
New Features
-Added access for AWS S3
-Added support for MongoDB Atlas and mLab
-Added support for MongoDB SQL Query
Improvement
– Text area to edit MongoDB value
– Fix link with the text
– Allow map chart small value to display as a bigger bubble
– Add new config to send an email notification to new users
– Added SQLPLUS runner for Oracle
Bug Fixes
– An issue with import Job window
– fix various labels issues with charts
– When trying to update varchar2 on Postgres – getting unparsable date error
– ACL should not display other tables with autocomplete
– User can see the column names of the table in the report creating even for this table access is limited
– Invalid object name for the snippet
– Cannot run MSSQL query with some calculation without column name
– The read-only connection should not display as an error while connecting to the database
– The incorrect type of the MongoDB document is displaying
– Issue with charts
– Fix mongo records
– An issue with data grid filter with an integer value
– Allow setting multiple emails for the job
– Import mapping is not working
– Make connection change disable on the ACL