ODBC PowerPack 1.6.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 a new connector for Excel Driver.

To see full release notes click here

New Features/Improvements

  • NEW: All API Drivers – Add support for OAuth 1.0 with SHA256 (Usecase like NetSuite API)
  • NEW: All API Drivers – Add Support for Tls 1.3
  • NEW: All API Drivers – Allow Regular Expression Extract for Paginate using [Response Header Contains Continuation Toke] Mode (e.g. nextHeader=someResponseHeader(your-regular-expression) )
  • NEW: All API Drivers – Allow to use different header name for next request for Paginate using [Response Header Contains Continuation Toke] Mode (e.g. header::nextHeader=someResponseHeader )
  • NEW: All API Drivers – Generate Meta data in compact mode by default, also give option to generate legacy Json based format
  • NEW: All API Drivers – List custom PROC in Preview Dropdown
  • NEW: All API Drivers – Paginate using Pass Response Header to Next URL Mode throws error – Specified value has invalid HTTP Header characters
  • NEW: All API Drivers – Provide right click menu – for Create new Table (SQL Mode) or new table (ConnectionString Mode) – Faster (for New Virtual Table)
  • NEW: All API Drivers – When you add custom object (Table Type) user doesnt have option to choose Mode (i.e. SQL or Connection)
  • NEW: All SFTP Drivers – Add support for Ed25519 (EdDSA on edwards25519 curve)
  • NEW: API Driver – Add support for Zip format
  • NEW: API Driver – Show Virtual Tables on Preview Dropdown
  • NEW: Data Gateway – Add new Connector for Excel
  • NEW: Excel Driver – New ODBC Driver to read / write Excel
  • NEW: General – Remember last N query for specific Data Source
  • NEW: JDBC Bridge Driver – Clicking view Meta data throws error in some case – Requested value ‘Int16’ was not found.
  • NEW: JDBC Bridge Driver – Some cases you might get Key not found error
  • NEW: JSON, XML, CSV , Azure , Amazon , SFTP Drivers – Recursive Scan option doesnt work
  • NEW: OAuth Connection Manager, Google Data Connection Manager (Google Analytics) – Use Loopback Redirect URL for Custom App to comply with new Google Changes (Disallow – Redirect to urn:ietf:wg:oauth:2.0:oob for apps created after Feb 2022)

Bug fixes

  • FIX: All API Driver – Custom Object Save saves bad syntax without warning
  • FIX: All API Drivers – Add support for 3 parts in SELECT Column names to support apps like MSAccess which can issue query like this (i.e. select DATA.Customers.CustomerID from DATA.Customers )
  • FIX: All API Drivers – Add support for 3 parts in SELECT Column names to support apps like MSAccess which can issue query like this (i.e. select DATA.Customers.CustomerID from DATA.Customers )
  • FIX: All API Drivers – Compact Mode Metadata might cause odd error about invalid syntax – SQL logic error or missing database
  • FIX: All API Drivers – ContineOnErrorForStatusCode doesnt work (Due to MatchForEqual is always Set as False rather than True)
  • FIX: All API Drivers – More than 16 arguments in function or VALUES clause throws error
  • FIX: All API Drivers – OAuth Option [Do Not Send Credentials in Body] doesnt work (It sends secret in Body regardless)
  • FIX: All API Drivers – Preview doesnt generate columns for Virtual Tables if it has columns with space inside it
  • FIX: All API Drivers – Preview for Custom Object hangs
  • FIX: All API Drivers – Warn user if trying to load wrong driver connection string
  • FIX: All API Drivers – You may get object reference not set error on Connection Configure link click
  • FIX: API Driver – Changing Refresh token path not detected once you wipe out file path
  • FIX: API Driver – Column listing fails for some tables (specially table name contains space or special character like $ or dash, do)
  • FIX: API Driver – Comment WHERE Key=somevalue part in generated SQL when WITH clause is included to avoid bad SQL
  • FIX: API Driver – Get Tables Operation fails for some apps (i.e. Sage)
  • FIX: API Driver – Query Builder does not recognize column mapping to Param and shows same in WHERE clause (needs to comment WHERE clause)
  • FIX: API Driver – Query Builder doesnt produce correct query for SELECT (Column list + WHERE clause issue)
  • FIX: API Driver – When you choose Table from Preview Dropdown it may not show Builder UI to choose required parameters
  • FIX: Data Gateway – Save Operation throws error – NullReference when Service not found
  • FIX: Data Gateway – Some users might get error on connection – The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel
  • FIX: General – Log doesnt include timestamp
  • FIX: General – Show errors in red on Custom Object UI
  • FIX: JDBC Bridge Driver – Support some advanced datatypes
  • FIX: JDBC Bridge Driver – Table mode fails from some tool (like Power BI – Table mode) – Throws Invalid object (when object is stored in non default schema)
  • FIX: JDBC Bridge Driver – When object name contains space – Table mode fails from some tool (like Power BI)
  • FIX: JDBC Bridge Driver – When object name contains system reserved word (i.e. dbo.Case )- Table mode fails from some tools like Power BI
  • FIX: JSON Driver – Virtual Table query fails to get metadata – Hangs on Fetching metadata step
  • FIX: Salesforce Driver – In some cases syntax of External Query might be cause object reference not set error
Posted in Announcements.