ODBC PowerPack 1.2.0 released

New Features/Improvements

  • NEW: All API Drivers – Add Custom Stored Procedure support (With Compiled Metadata support for faster performance)
  • NEW: All API Drivers – Add support for count(*)
  • NEW: All API Drivers – Add support for multi statements
  • NEW: All API Drivers – Add Support for Placeholder functions in HTTP Dynamic Token Request (i.e . Headers/Body/URL)
  • NEW: All API Drivers – Add support for temp tables (Save result into temp table and use in different query or in JOIN Syntax)
  • NEW: All API Drivers – Add two default headers Accept, Cache-Control
  • NEW: All API Drivers – Change IncludeParentColumns default to True
  • NEW: All API Drivers – Give option to pass content-type for multi-part upload request (Right now its guessed from file extension) – Google Drive Upload API Usecase
  • NEW: All API Drivers – OAuth Connection – Detect changing refresh token pattern and prompt to define file path on generate token click
  • NEW: All API Drivers – OAuth Connection – Implement External Browser Token Extract (Need this feature for APIs like Google which stop supporting Embedded Browser in App)
  • NEW: All Drivers – Allow to use Placeholders any where in Query Text (e.g. select * from $ WITH(Src=’http://httpbin.org/get?id=2020-04-27′) )
  • NEW: All JSON Driver, All XML Driver – Support Custom column list in Complex 2D Transform
  • NEW: Data Gateway – Add correct message in TDS response when no license found (it sends “Client unable to establish connection due to prelogin failure”.)
  • NEW: Data Gateway – Improve Gateway Log (Added IP, Query Time, UserID, DB Name, SessionID, CPU %, Memory and more )
  • NEW: Data Gateway – Provide a clear indication which IPs using Gateway connections when license error is thrown
  • NEW: Data Gateway – Use of invalid catalog name can throw confusing error in SQL Linked server
  • NEW: General – Provide confirm dialog box before overwrite DSN with same name on config save

Bug fixes

  • FIX: All API Driver – Extended Query report Int32 data as Int64
  • FIX: All API Drivers – After entering URL in the path if you browse path it will not show local files
  • FIX: All API Drivers – Alias doesn’t work for nested sub query
  • FIX: All API Drivers – AWS v4 Signature Provider doesnt work when you have URL like https://something.execute-api.eu-central-1.amazonaws.com/part1/part2/somename
  • FIX: All API Drivers – Changing Headers in Grid mode doesnt save when you close UI
  • FIX: All API Drivers – Escape Sequence issue for single quote in WITH clause
  • FIX: All API Drivers – Invalid meta entry name cause path not found error
  • FIX: All API Drivers – OAuth Connection – Retry option cause issue with Amazon MWS API
  • FIX: All Drivers – Driver name attribute is treated as case-sensitive
  • FIX: Amazon S3 Drivers (CSV, XML, JSON), Azure Blob Xml Driver – You may get error for – Rebex.Zip dll is missing
  • FIX: Amazon S3, Azure Blob, SFTP Drivers – Source Path hint is wrong – Change http:// in path to /myfolder to avoid confusion
  • FIX: Apps – MS Access – Selecting Primary Key field for Linked table fails
  • FIX: Data Gateway – CAL Limit error from multiple connection from same IP
  • FIX: Data Gateway – When CacheAll is enabled you may get zero rows in some cases if META clause used
  • FIX: Data Gateway – When CacheAll setting is On you may get Object reference not set error
  • FIX: Distinct doesnt work if WHERE clause / GROUP BY / ORDER BY not used
  • FIX: General – Help file doesnt show all examples
  • FIX: General – Installer doesnt prompt UAC in some cases
  • FIX: Informatica – nvarchar columns are loaded with scale > 0 causing issue in informatica developer IDE
  • FIX: JSON Driver – You may get error – Value was either too large or too small for an Int64
  • FIX: JSON Driver, XML Driver – When you select sub document as filter (e.g. $docs[*].info ) rather than array node (e.g. $docs[*] ) it may output NULL values
  • FIX: Salesforce – WHERE clause filter on DateTime field is not supported (i..e LastModifiedDate field)
  • FIX: Salesforce Driver – You may get error on Bool datatype
  • FIX: You may get error when you use URL JOIN – Input string was not in a correct format.
Posted in Announcements.