{"id":10173,"date":"2023-08-03T05:57:58","date_gmt":"2023-08-03T05:57:58","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=10173"},"modified":"2023-08-03T05:57:58","modified_gmt":"2023-08-03T05:57:58","slug":"odbc-powerpack-1-8-0-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/","title":{"rendered":"ODBC PowerPack 1.8.0 released"},"content":{"rendered":"

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

This release brings tons of new features and bug fixes. We have added new connectors for CosmosDB, Azure DevOps (TFS), ServiceNow, MailChimp, API Drivers and Data Gateway. It includes many enhancements around All Drivers and JSON \/ XML \/ CSV Driver.<\/p>\n

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

New Features\/Improvements<\/h3>\n
    \n
  • NEW: <\/span>API Driver – CosmosDB – New connector to Read \/ Write \/ Query documents and other objects (e.g. Database, Containers)<\/li>\n
  • NEW: <\/span>API Driver – Azure DevOps (TFS) – New connector to Read \/ Write \/ Query items (e.g. Tasks, Bugs, User Story)<\/li>\n
  • NEW: <\/span>API Driver – ServiceNow – New connector to Read \/ Write \/ Query tables (e.g. Incidents, Tasks, Users)<\/li>\n
  • NEW: <\/span>API Driver – MailChimp – New connector to Read \/ Write \/ Query MailChimp data (e.g. Campaigns, Lists, Subscribes, Reports)<\/li>\n
  • NEW: <\/span>All API Drivers – Allow bool as alias for boolean type in META clause (e.g. META=’flag: bool’)<\/li>\n
  • NEW: <\/span>All API Drivers – Allow just column names without datatype in Meta – use string(2000) as default if type missing (e.g. select * from tbl WITH(META=’col1;col2;col4;col5:int;col6:string(100)’) )<\/li>\n
  • NEW: <\/span>Amazon JSON \/ XML \/CSV Driver – Update AWS SDK (Core Driver to v3.7)<\/li>\n
  • NEW: <\/span>API Connector Framework – Add Support for Multiple LookupEndPoints based on Parameter count (LookupEndPoint=”ep_by_customerid, ep_by_orderid”)<\/li>\n
  • NEW: <\/span>API Driver – HubSpot – Add Upload File endpoint<\/li>\n
  • NEW: <\/span>Data Gateway – Encrypt Setting File with user defined password<\/li>\n
  • NEW: <\/span>General – Update Client Side Query Engine to v3.40<\/li>\n
  • NEW: <\/span>JDBC Bridge Driver – Add logging<\/li>\n
  • NEW: <\/span>JSON \/ XML \/ CSV Driver – Add option to Create new API Connector File from UI settings on the Preview Tab<\/li>\n
  • NEW: <\/span>JSON \/ XML \/ CSV Driver – Add support for reading *.tar.gzip file (multiple files in one tar.gzip)<\/li>\n
  • NEW: <\/span>JSON \/ XML \/ CSV Driver – ClientCertificate not supported if you change SslVersion settings other than Default<\/li>\n<\/ul>\n

    Bug fixes<\/h3>\n
      \n
    • FIX: <\/span>All API Drivers – Certain errors not bubbled up to the caller application<\/li>\n
    • FIX: <\/span>All API Drivers – When META is set to int, bool, date and you encounter blank data then it throws error about conversion (we should treat blank number, date, bool as null) – Error Input string was not in a correct format.<\/li>\n
    • FIX: <\/span>All Drivers – Misleading error is thrown (Value cannot be null) when you run Stored Proc which has syntax issue (i.e. not starting with CREATE PROC statement)<\/li>\n
    • FIX: <\/span>All Drivers – Duplicate column names in SELECT cause misleading error (Item Key already added)<\/li>\n
    • FIX: <\/span>All Drivers – More than 900 columns throws error – too many SQL variables<\/li>\n
    • FIX: <\/span>All Drivers – Preview Tab shows duplicate entries in Table dropdown if you click Dropdown multiple times too quick<\/li>\n
    • FIX: <\/span>All Drivers – View Metadata shows wrong code for API Connector XML option (Rather than DataType=xx , it shows Type=xx)<\/li>\n
    • FIX: <\/span>API Driver – Always Treat Blank Number, Date, Bool as Null is not working<\/li>\n
    • FIX: <\/span>API Driver – Delete \/ Update clause does not set Table Parameters from WITH clause<\/li>\n
    • FIX: <\/span>API Driver – Limit rows coming back from WHERE clause in Update \/ Delete in Preview (Honor Max Rows setting)<\/li>\n
    • FIX: <\/span>JDBC Bridge Driver – Cache Settings not saved<\/li>\n
    • FIX: <\/span>JDBC Bridge Driver – Stored Proc doesnt return output<\/li>\n
    • FIX: <\/span>JSON \/ XML \/ CSV Driver – Direct String option not saved and only works if you use WITH (DATA=xxxx) in SQL, UI option ignored<\/li>\n
    • FIX: <\/span>JSON \/ XML \/ CSV Drivers – Value for Direct Data and Keep Date As String Option not saved<\/li>\n
    • FIX: <\/span>JSON, XML , CSV Driver – Placeholder function doesnt work in URL \/ Body \/ Headers (When entered on UI) – Works ok if you override in WITH Clause SRC<\/li>\n
    • FIX: <\/span>JSON, XML Driver – Curly bracket in comment section cause error when URL JOIN (e.g. JOIN_1 in WITH ) feature is used – Error – Input string was not in a correct format<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      Introduction This release brings tons of new features and bug fixes. We have added new connectors for CosmosDB, Azure DevOps (TFS), ServiceNow, MailChimp, API Drivers and Data Gateway. It includes many enhancements around All Drivers and JSON \/ XML \/ CSV Driver. To see full release notes\u00a0click here New Features\/Improvements NEW: API Driver – CosmosDB […]<\/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.8.0 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"ODBC PowerPack 1.8.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-8-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.8.0 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"ODBC PowerPack 1.8.0 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2023-08-03T05:57:58+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=\"3 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-8-0-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/\",\"name\":\"ODBC PowerPack 1.8.0 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2023-08-03T05:57:58+00:00\",\"dateModified\":\"2023-08-03T05:57:58+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"ODBC PowerPack 1.8.0 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-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-8-0-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODBC PowerPack 1.8.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.8.0 released | ZappySys Blog","description":"ODBC PowerPack 1.8.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-8-0-released\/","og_locale":"en_US","og_type":"article","og_title":"ODBC PowerPack 1.8.0 released | ZappySys Blog","og_description":"ODBC PowerPack 1.8.0 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/","og_site_name":"ZappySys Blog","article_published_time":"2023-08-03T05:57:58+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/","url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/","name":"ODBC PowerPack 1.8.0 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2023-08-03T05:57:58+00:00","dateModified":"2023-08-03T05:57:58+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"ODBC PowerPack 1.8.0 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-0-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-8-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-8-0-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODBC PowerPack 1.8.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\/10173"}],"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=10173"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10173\/revisions"}],"predecessor-version":[{"id":10174,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10173\/revisions\/10174"}],"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=10173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=10173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=10173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}