{"id":9759,"date":"2022-08-15T14:03:28","date_gmt":"2022-08-15T14:03:28","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9759"},"modified":"2022-08-15T14:03:28","modified_gmt":"2022-08-15T14:03:28","slug":"odbc-powerpack-1-6-0-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/","title":{"rendered":"ODBC PowerPack 1.6.0 released"},"content":{"rendered":"

Introduction<\/span><\/h3>\n

This release brings tons of new features and bug fixes. We have added a new connector for Excel Driver.<\/p>\n

To see full release notes\u00a0click here<\/a><\/p>\n

New Features\/Improvements<\/h3>\n
    \n
  • NEW:\u00a0<\/span>All API Drivers – Add support for OAuth 1.0 with SHA256 (Usecase like NetSuite API)<\/li>\n
  • NEW:\u00a0<\/span>All API Drivers – Add Support for Tls 1.3<\/li>\n
  • NEW:\u00a0<\/span>All API Drivers – Allow Regular Expression Extract for Paginate using [Response Header Contains Continuation Toke] Mode (e.g. nextHeader=someResponseHeader(your-regular-expression) )<\/li>\n
  • NEW:\u00a0<\/span>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 )<\/li>\n
  • NEW:\u00a0<\/span>All API Drivers – Generate Meta data in compact mode by default, also give option to generate legacy Json based format<\/li>\n
  • NEW:\u00a0<\/span>All API Drivers – List custom PROC in Preview Dropdown<\/li>\n
  • NEW:\u00a0<\/span>All API Drivers – Paginate using Pass Response Header to Next URL Mode throws error – Specified value has invalid HTTP Header characters<\/li>\n
  • NEW:\u00a0<\/span>All API Drivers – Provide right click menu – for Create new Table (SQL Mode) or new table (ConnectionString Mode) – Faster (for New Virtual Table)<\/li>\n
  • NEW:\u00a0<\/span>All API Drivers – When you add custom object (Table Type) user doesnt have option to choose Mode (i.e. SQL or Connection)<\/li>\n
  • NEW:\u00a0<\/span>All SFTP Drivers – Add support for Ed25519 (EdDSA on edwards25519 curve)<\/li>\n
  • NEW:\u00a0<\/span>API Driver – Add support for Zip format<\/li>\n
  • NEW:\u00a0<\/span>API Driver – Show Virtual Tables on Preview Dropdown<\/li>\n
  • NEW:\u00a0<\/span>Data Gateway – Add new Connector for Excel<\/li>\n
  • NEW:\u00a0<\/span>Excel Driver – New ODBC Driver to read \/ write Excel<\/li>\n
  • NEW:\u00a0<\/span>General – Remember last N query for specific Data Source<\/li>\n
  • NEW:\u00a0<\/span>JDBC Bridge Driver – Clicking view Meta data throws error in some case – Requested value ‘Int16’ was not found.<\/li>\n
  • NEW:\u00a0<\/span>JDBC Bridge Driver – Some cases you might get Key not found error<\/li>\n
  • NEW:\u00a0<\/span>JSON, XML, CSV , Azure , Amazon , SFTP Drivers – Recursive Scan option doesnt work<\/li>\n
  • NEW:\u00a0<\/span>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)<\/li>\n<\/ul>\n

    Bug fixes<\/h3>\n
      \n
    • FIX:\u00a0<\/span>All API Driver – Custom Object Save saves bad syntax without warning<\/li>\n
    • FIX:\u00a0<\/span>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 )<\/li>\n
    • FIX:\u00a0<\/span>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 )<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – Compact Mode Metadata might cause odd error about invalid syntax – SQL logic error or missing database<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – ContineOnErrorForStatusCode doesnt work (Due to MatchForEqual is always Set as False rather than True)<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – More than 16 arguments in function or VALUES clause throws error<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – OAuth Option [Do Not Send Credentials in Body] doesnt work (It sends secret in Body regardless)<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – Preview doesnt generate columns for Virtual Tables if it has columns with space inside it<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – Preview for Custom Object hangs<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – Warn user if trying to load wrong driver connection string<\/li>\n
    • FIX:\u00a0<\/span>All API Drivers – You may get object reference not set error on Connection Configure link click<\/li>\n
    • FIX:\u00a0<\/span>API Driver – Changing Refresh token path not detected once you wipe out file path<\/li>\n
    • FIX:\u00a0<\/span>API Driver – Column listing fails for some tables (specially table name contains space or special character like $ or dash, do)<\/li>\n
    • FIX:\u00a0<\/span>API Driver – Comment WHERE Key=somevalue part in generated SQL when WITH clause is included to avoid bad SQL<\/li>\n
    • FIX:\u00a0<\/span>API Driver – Get Tables Operation fails for some apps (i.e. Sage)<\/li>\n
    • FIX:\u00a0<\/span>API Driver – Query Builder does not recognize column mapping to Param and shows same in WHERE clause (needs to comment WHERE clause)<\/li>\n
    • FIX:\u00a0<\/span>API Driver – Query Builder doesnt produce correct query for SELECT (Column list + WHERE clause issue)<\/li>\n
    • FIX:\u00a0<\/span>API Driver – When you choose Table from Preview Dropdown it may not show Builder UI to choose required parameters<\/li>\n
    • FIX:\u00a0<\/span>Data Gateway – Save Operation throws error – NullReference when Service not found<\/li>\n
    • FIX:\u00a0<\/span>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<\/li>\n
    • FIX:\u00a0<\/span>General – Log doesnt include timestamp<\/li>\n
    • FIX:\u00a0<\/span>General – Show errors in red on Custom Object UI<\/li>\n
    • FIX:\u00a0<\/span>JDBC Bridge Driver – Support some advanced datatypes<\/li>\n
    • FIX:\u00a0<\/span>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)<\/li>\n
    • FIX:\u00a0<\/span>JDBC Bridge Driver – When object name contains space – Table mode fails from some tool (like Power BI)<\/li>\n
    • FIX:\u00a0<\/span>JDBC Bridge Driver – When object name contains system reserved word (i.e. dbo.Case )- Table mode fails from some tools like Power BI<\/li>\n
    • FIX:\u00a0<\/span>JSON Driver – Virtual Table query fails to get metadata – Hangs on Fetching metadata step<\/li>\n
    • FIX:\u00a0<\/span>Salesforce Driver – In some cases syntax of External Query might be cause object reference not set error<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      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\u00a0click here New Features\/Improvements NEW:\u00a0All API Drivers – Add support for OAuth 1.0 with SHA256 (Usecase like NetSuite API) NEW:\u00a0All API Drivers – Add Support for Tls 1.3 NEW:\u00a0All API Drivers […]<\/p>\n","protected":false},"author":6,"featured_media":16,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442],"tags":[],"yoast_head":"\r\nODBC PowerPack 1.6.0 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"ODBC PowerPack 1.6.0 released - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"ODBC PowerPack 1.6.0 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"ODBC PowerPack 1.6.0 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2022-08-15T14:03:28+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"77\" \/>\r\n\t<meta property=\"og:image:height\" content=\"70\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/\",\"name\":\"ODBC PowerPack 1.6.0 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2022-08-15T14:03:28+00:00\",\"dateModified\":\"2022-08-15T14:03:28+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"ODBC PowerPack 1.6.0 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"width\":77,\"height\":70,\"caption\":\"ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODBC PowerPack 1.6.0 released\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"url\":\"https:\/\/zappysys.com\/blog\/author\/hshah\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ODBC PowerPack 1.6.0 released | ZappySys Blog","description":"ODBC PowerPack 1.6.0 released - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/","og_locale":"en_US","og_type":"article","og_title":"ODBC PowerPack 1.6.0 released | ZappySys Blog","og_description":"ODBC PowerPack 1.6.0 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/","og_site_name":"ZappySys Blog","article_published_time":"2022-08-15T14:03:28+00:00","og_image":[{"width":77,"height":70,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/","url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/","name":"ODBC PowerPack 1.6.0 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2022-08-15T14:03:28+00:00","dateModified":"2022-08-15T14:03:28+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"ODBC PowerPack 1.6.0 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","width":77,"height":70,"caption":"ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-6-0-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODBC PowerPack 1.6.0 released"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","caption":"ZappySys"},"url":"https:\/\/zappysys.com\/blog\/author\/hshah\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9759"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=9759"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9759\/revisions"}],"predecessor-version":[{"id":9760,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9759\/revisions\/9760"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/16"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=9759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=9759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=9759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}