ODBC PowerPack v1.1.3 Released

What’s New

In this release we focused on adding URL JOIN Features which may allow many multi steps scenarios in one query. Bing Ads, Amazon MWS, Google BigQuery, Amazon Athena all these supports Job style queries which needs 3 step process (Create job, keep checking status, once done read report data). We also improved compatibility with Informatica and MS Access.

Version [Jun 24, 2019]

New Features/Improvements

  • NEW: Add option to replace placeholders in File content if you use IsMultiPart = True
  • NEW: All API Drivers – Add option EnableBodyPlaceholderForMultiPart to support replacing placeholders in file content in IsMultiPart mode (E.g. replace <%access_token%> or [$token$] or [$alias.MyJoinColumn$] )
  • NEW: All API Drivers – Add option OutputAsRawDocumentSingleRow (Returns __DOCUMENT__ field with entire File / Response string in one field)
  • NEW: All API Drivers – Add Options to parse from any unstructured data – RawOutputExtractMode, RawOutputDataRowTemplate, RawOutputFilterExpr
  • NEW: All API Drivers – Add Status Check feature for all API drivers (Keep sending request until desired value found) – Options added EnableStatusCheck, StatucCheckMaxWaitSeconds, StatucCheckIterationWaitSeconds, StatusSuccessValue, StatusFailureValue
  • NEW: All API Drivers – Add support for ConnectionType in URL Join
  • NEW: All API Drivers – Add Support for HMAC Authentication
  • NEW: All ODBC Drivers – Add support for Parameters
  • NEW: Data Gateway – Add Code Generator UI for SQL / Java
  • NEW: Data Gateway – Allow to add firewall rule via UI
  • NEW: Data Gateway – Better logging about connected devices
  • NEW: Salesforce Driver – Add support for Select * FROM

Bug fixes

  • FIX: All API Drivers – joinXX_DataConnectionType Option not supported in JOIN URL
  • FIX: All API Drivers- Show meaningful error when same option used twice in WITH clause (Right now you see odd error – An item with the same key has already been added)
  • FIX: Apps – Informatica – Driver may output many extra empty rows in some cases
  • FIX: Apps – MS Access – Linked table throwing call fail error (due to missing support for parameters in current driver)
  • FIX: Data Gateway – Certain errors not reported correctly back to caller
  • FIX: Data Gateway – Enabling caching options may hang query in some case
  • FIX: Data Gateway – Generic ODBC Connection Type fails with error Connection is Busy
  • FIX: Data Gateway – When you use Meta option in WITH clause you may see empty rowset rather error in some cases
  • FIX: Salesforce Driver – Can not load table list in Excel / Power BI
  • FIX: Salesforce Driver – Failed to preview data in Power BI
  • FIX: Salesforce Driver – Load ConnectionString doesnt set Username
  • FIX: Salesforce Driver – Nested queries not supported – You may get syntax error
  • FIX: Salesforce Driver – SSIS ODBC destination showing bad Table names in list
Posted in Announcements, ETL - Informatica, ODBC Gateway, Reporting - Microsoft Access.