ODBC PowerPack 1.6.1 released

Introduction

This release brings tons of new features and bug fixes. We have added a new connector for Youtube, Stripe, Zoom, Amazon Ads, ManageEngine ServiceDesk Plus and for support add HubSpot and SharePoint.

To see full release notes click here

New Features/Improvements

  • NEW: API Driver – Youtube – New connector to read, search Videos / Playlists and other information (like, view, share, title, watch time etc)
  • NEW: API Driver – Stripe – New connector to read / write Customers, Orders, Invoices, Products, Subscriptions and more
  • NEW: API Driver – Zoom – New connector to read Meetings, Webinars, Attendees and other information from Zoom Service
  • NEW: API Driver – Amazon Ads – New connector to read reports for Amazon Ads Account
  • NEW: API Driver – ManageEngine ServiceDesk Plus- New Connector to read data from Requests, Tasks, Notes, Worklog and more
  • NEW: API Driver – HubSpot – Add support for PrivateApp Authentication (Using Static Access Token)
  • NEW: API Driver – SharePoint – Added support for Managed Metadata fields (Show Label, WssId and TermGuid)
  • NEW: General – Show user friendly license error when either valid license not found or its expired

Bug fixes

  • FIX: All API Drivers – Duplicate Custom Objects entries listed sometimes on Preview Table for Table dropdown
  • FIX: All API Drivers – WaitTimeMs conflicts with other property, RetryMode appears twice
  • FIX: All Drivers – After you preview 100 queries you start getting error – capacity was less than the current size
  • FIX: All Drivers – Generated query should quote around name if it contains @ char
  • FIX: All Drivers – Saving Metadata option not working
  • FIX: All Drivers – When you use parenthesis or some other invalid chars in DSN names it throws error
  • FIX: API Driver – OAuth Generate Token button remains disabled in some cases also not showing count down
  • FIX: General – WHERE clause not invoked when called from SELECT * INTO
  • FIX: JDBC Bridge Driver – BigInteger error
  • FIX: JDBC Bridge Driver – If you choose object with space in the name from non default schema – you might get error – Incorrect syntax near
  • FIX: JDBC Bridge Driver – Metadata for string columns not reported correctly (Length always zero)
  • FIX: JDBC Bridge Driver – Numeric values might fails to import in apps like SSIS
  • FIX: JDBC Bridge Driver – Some datatypes not handled correct way (e.g. variant in MSSQL)
  • FIX: ODBC SFTP JSON / XML / CSV Driver – You may get Object must be the same type as the enum error when you click on preview tab (It only happens if DSN not saved)
Posted in Announcements.