ODBC PowerPack 1.5.0 released

Posted on by
Contents hide
1 Introduction
2 New Features/Improvements
3 Bug fixes

Introduction

This release brings tons of new features and bug fixes. We have added new connectors for API Driver.

To see full release notes click here

New Features/Improvements

  • NEW: All API Drivers – Allow to use Custom SQL for Virtual Table
  • NEW: All API drivers – META with extended query syntax cause invalid syntax error
  • NEW: All Drivers – Add option to export preview result to CSV / TSV file or copy to clipboard
  • NEW: All Drivers – Allow to cancel query execution on the preview tab
  • NEW: All Drivers – Show Preview errors in non-blocking text area rather than Blocking Popup
  • NEW: API Connector Framework – Allow to map __RAWDOC__
  • NEW: API Driver – Enhance Query Builder to add column list / key in WHERE for SELECT, UPDATE , INSERT, DELETE
  • NEW: API Driver – Some changes on UI not saved in active connection causing failure on Preview / Test Connection
  • NEW: API Driver – Support WHERE Clause in DELETE / UPDATE Operations
  • NEW: API Driver – Support WHERE Clause in SELECT
  • NEW: API Driver – Support WHERE clause server side execution for UPDATE / DELETE / SELECT if API can handle it
  • NEW: API Driver, Salesforce Driver – SOURCE clause should invoke on the same connection if Driver Type and ConnectionString parameters are not supplied
  • NEW: CSV Driver – Provide an option to output blank value as null
  • NEW: Data Gateway – Log Additional System Info
  • NEW: Data Gateway – Show warning about service restart required in order to apply changes
  • NEW: Data Gateway – Update SSL support to accept Tls1.1 and Tls1.2
  • NEW: General – Place holder function FUN_IF_NULL ( Syntax: input_value { |~| template_for_null_input } { |~| template_for_non_null_input } {|~| value_encoding_style } ) , Example: <<some input |~| Input is null |~| Input is $1 |~| jsonenc , FUN_IF_NULL>>
  • NEW: General – Provide F5 shortcut for Preview Data button
  • NEW: General – Provide max Log File Size option
  • NEW: JDBC Bridge Driver – Add path browse option for jar file
  • NEW: Jdbc Bridge Driver – Add Support for DateTimeOffset Type
  • NEW: Jdbc Bridge Driver – Return BIGINT type as Int64 rather than decimal
  • NEW: JSON Driver, XML Driver – Add Support regular expression in Filter (i.e. select * From $ WITH (Filter=’$.[?(@.Company =~ /^Micro(.*)$/)]’ ) )
  • NEW: JSON Driver, XML Driver – JSONPath Filter support for root objects (e.g. $..[?(@country==’USA’)] )
  • NEW: JSON, XML, CSV Driver – Add Option to parse output from command line Standard Output Stream (e.g. select * from $ WITH(Data=’cmd:>curl -k http://httpbin.org/get’) )
  • NEW: Salesforce Driver – Add support for OAuth Tokens security rather than Password (useful for 2FA / MFA handling)

Bug fixes

  • FIX: All Drivers – Add Support for ODBC Command Timeout
  • FIX: API Driver – Add Support for RefreshTokenFilePath (Changing Token Pattern)
  • FIX: API Driver – GUID type might cause error – Unknown SQL Type – 0
  • FIX: API Driver – Hide any Endpoint which needs {$row$} input at runtime
  • FIX: API Driver – LIMIT Clause is not honored when you execute query outside Preview Tab (i.e. Call from ODBC Apps)
  • FIX: API Driver – UPDATE / DELETE may throw error when you have space in object name and WHERE clause is used
  • FIX: Data Gateway – Code generator uses SQLNCLI rather than SQLNCLI11 for SQL Server Linked Server creation code – This cause issue with some query because wrong driver is being used
  • FIX: Data Gateway – Default Script cause issue for EXEC AT with INSERT – Error in TDS Stream – The operation could not be performed because OLE DB provider “SQLNCLI11” / “MSOLEDBSQL” for linked server “ls_Json” was unable to begin a distributed transaction
  • FIX: Data Gateway – In some cases long running HTTP requests might hang connection (This usually happens when HTTP exception happens after Caller Timeout or CommandTimeout set too low or exception happens after CommandTimeout)
  • FIX: Data Gateway – New version throws error about SSL/TLS negotiation in some cases
  • FIX: Data Gateway – Query hangs on certain exceptions and might crash gateway
  • FIX: Data Gateway – When you click Restart button on gateway UI – You may receive Time out has expired and the operation has not been completed
  • FIX: Data Gateway – When you open UI it may open multiple instances
  • FIX: Data Gateway – You might get random license error when too many connections made same time
  • FIX: General – Brackets around column name in UPDATE does not work or throw error (i.e. UPDATE tbl SET [my column] = 1 )
  • FIX: General – Preview Grid might throw error when you sort column by clicking on header – Error – Object must be of type string
  • FIX: JDBC Bridge Driver – Add Support for TIMESTAMP_WITH_TIMEZONE JDBC Type
  • FIX: JDBC Bridge Driver – Do not invoke SQL Parser (because syntax like CTE or CAST (c as varchar) fails )
  • FIX: JDBC Bridge Driver – Exception in thread “main” java.lang.NoClassDefFoundError:
  • FIX: JDBC Bridge Driver – Set working directory same as JDBC Driver (This helps scenario like Infor-ION driver JDBC Driver)
  • FIX: JDBC Bridge Driver – Show meaningful error rather than Pipe is broken (Capture unhandled exception right way)
  • FIX: JDBC Bridge Driver – When Pipe is broken error occurs certain Client Apps connecting to Gateway might hang
  • FIX: JDBC Bridge Driver – You might get misleading message if JRE missing – Failed to launch interop server host process
Posted in Announcements.