Version 2.2.0.11008 [Oct 16, 2025]
To view full release notes (including previous versions): click here
Download Latest Version
New Features/Improvements
- NEW: All API Drivers - Add new commands CREATE VIEW and DROP VIEW to create/drop VIEW (Custom Object)
- NEW: All API Drivers - Enhanced Tls1.3 capability with modern encryption ciphers and security standards
- NEW: API Connector - Azure DevOps - Added new columns Severity, ProposedFix, Symptom, RootCause, HowFound, FoundInEnvironment, BusinessValue, ValueArea, TestedBy, TestPriority, Activity - Copy
- NEW: API Connector - Azure DevOps - Added new field ResolvedBy for WorkItem operations (SELECT/UPDATE/INSERT) and added three new params (BypassRules, SuppressNotifications, ValidateOnly) - Copy
- NEW: API Connector - AzureDevOps - Added support for ParentId column and Expand Parameter (To get ParentId, you must set Expand Parameters=Relations)
- NEW: API Connector - Gmail - New connector to read / download mail and attachments from Gmail email account
- NEW: API Connector - JIRA - Added a new endpoint get_worklogs_after to fetch worklogs entries modified after a specified date/time
- NEW: API Connector - Outlook Mail - Add a new endpoint download_messages to download all messages as *.EML file for specififed search criteria / user mailbox / folder
- NEW: API Connector - Outlook Mail - Added a new endpoint delete_message to delete message by MessageId
- NEW: API Connector - Outlook Mail - Added a new endpoint delete_messages_by_search to delete multiple messages (bulk operation) by User / Folder / Search conditions
- NEW: API Connector - Outlook Mail - Added new endpoints get_groups and get_group to read Group data
- NEW: API Driver - Allow Select all for CheckBox MultiSelect Dropdown Selection
- NEW: Data Gateway - Provide an option to Edit User (Right now you have to delete and add just to change password)
- NEW: General – Dialog boxes always open on primary screen in multi-monitor setups
- NEW: JDBC Bridge Driver - Add more logging details (e.g. statement handle)
- NEW: JDBC Bridge Driver - Changed default Java to 21 from 8 when it's missing (Driver can still run on minimum Java 8, but we recommend Java 21 now for maximum compatibility with modern drivers)
- NEW: JSON / XML / CSV Driver - Show paginated API calls in the log (when Logging Mode=Debug or higher)
- NEW: Salesforce Driver - Document BULK Insert Example using Mixed mode and windows auth
- NEW: Salesforce Driver - New Connection / Login call happens on every SQLDatastatment rather than new SQLConnection
Bug fixes
- FIX: All API Drivers - Preview dropdown hangs if URL JOIN query used inside Virtual Table (Custom Object)
- FIX: All API Drivers - Query Custom Object (Virtual Table) hangs or behaves unpredictably
- FIX: All API Drivers - Static META is ignored when EXEC usp_proc called via OPENQUERY
- FIX: All API Drivers - URL JOIN - UI data caching issue on preview (First run shows less rows, second run works fine)
- FIX: All API Drivers - Virtual Table with nested loops produce wrong metadata
- FIX: All API Drivers - When Virtual Table is misspelled or not found you get misleading error - No data returned for specified table name or filter expression -OR- ERR_NO_DATA_OR_INVALID_EXPR: No records found in specified table. Manually enter output columns.
- FIX: All API Drivers - WHERE condition is not working in Virtual Table (View) - select * from vt__MyTable WHERE id=123 ignores where clause
- FIX: All Drivers - Sometimes errors not reported and you may see generic message
- FIX: All Drivers - Wrong executation time reported on Preview UI
- FIX: API Connector - JIRA - You may get error Remote server returned 401 Gone. This is due to CHANGE-2046 (/search endpoint deprecated, now use /search/jql)
- FIX: API Connector - Outlook Mail - Clicking on MailFolderId parameter may throw error 400 bad request (due to /users/users twice in the URL)
- FIX: API Connector - SmartSheet - Table list shows only 100 sheets (stopped working after recent SmartSheet API changes related to totalCount attribute)
- FIX: API Driver - Generic Request other than Json not working (i.e. ResponseFormat=Csv / Xml)
- FIX: Data Gateway - API Call may hang for URL JOIN Pattern when no data found for specified Filter (Json Path)
- FIX: Data Gateway - Encountering column-related errors while attempting to load data from the Gateway to Microsoft Excel using the ODBC DSN via the ODBC Data Source option
- FIX: Data Gateway - JDBC Bridge Driver - Binary type may report wrong length causing error - The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted
- FIX: Data Gateway - JDBC Bridge Driver - Protocol error in TDS Stream (when TIMESTAMP with TIMEZONE / DATETIMEOFFSET datatype found) - Invalid statement
- FIX: Data Gateway - Multiple connections may hang in some situation
- FIX: General - Preview UI may hang / freeze on some queries
- FIX: General - Preview UI reports wrong query execution time
- FIX: JDBC Bridge Driver - Preview metadata issue (column / row count cached) - Causing error - Index was outside the bounds of the array
- FIX: JDBC Bridge Driver - Previous query metadata used in some cases
- FIX: JDBC Bridge Driver - Some JDBC drivers may hang on connect when compiled with higher Java version than installed Java version (e.g. Neo4j or MongoDB)
- FIX: JDBC Bridge Driver - You may get error if - Index was outside the bounds of the array
- FIX: JDBC Bridge Driver - You may get error if you try to read datetime field - java.lang.IllegalArgumentException: Can't serialize class java.time.LocalDate
- FIX: JDBC Bridge Driver - You may receive error: System.InvalidOperationException: Unexpected FetchRow call
- FIX: Salesforce Driver - Add support for cancellation for long running query (trigger on CommandTimeout or Cancel)
- FIX: Salesforce Driver - Update SOURCE clause Examples to clearly mention that using Windows Auth needs extra SQL login setup (ZS Data Gateway Service account must be added as SQL Login)