{"id":9403,"date":"2021-10-07T12:58:30","date_gmt":"2021-10-07T12:58:30","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9403"},"modified":"2021-10-07T12:58:30","modified_gmt":"2021-10-07T12:58:30","slug":"odbc-powerpack-1-4-2-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/","title":{"rendered":"ODBC PowerPack 1.4.2 released"},"content":{"rendered":"<h3 class=\"versubtitle\">Introduction<\/h3>\n<p>We are excited to release tons of new features and fixes in this version. It includes many enhancements around All API Drivers and Multi statement support in Salesforce Driver. We also added many new features in various drivers along with bug fixes\/performance improvement features.<\/p>\n<p>To see full release notes <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/release-notes.htm\" target=\"_blank\" rel=\"noopener\">click here<\/a><\/p>\n<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Add support for window functions (e.g. ROW_NUMBER , RANK, PERCENT_RANK, NTILE, NTH_VALUE, LEAD, LAST_VALUE, LAG, FIRST_VALUE, DENSE_RANK, CUME_DIST)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Provide a setting to apply META in merge mode in simple, extended, URL join queries<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Provide an example of merge mode ( OverrideMode )<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All Drivers &#8211; Mask Connectionstring by default in Import Settings dialogbox by default (and give option to unmask)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All Drivers &#8211; More than 655 columns throws error about FillWeight<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Driver &#8211; Add Support for META clause<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Driver &#8211; Reset Table dropdown only when you leave Tab not clicking any where outside tab (e.g. Generate SQL Button)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Add support for SSL \/ TLS Encryption for Secure TDS Protocol<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Provide IP \/ Range Block \/ Allow Feature (with Last Successful \/ Failed Login Attempt Indication)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Support Dynamic SQL using Exec AT with parameters<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add Online page for SQL UDF<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Installer &#8211; Rename License Manager to ODBC License Manager<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Salesforce Driver &#8211; Multi statement support<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Driver &#8211; Quote symbol issue in SQL generation<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; ConvertFormat has no effect if you set via UI<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Enable Custom Replace is not working when you set options from UI (however setting options in WITH clause works fine)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Extra unwanted columns produced in some extended queries when * is used (provide * + const\\expr columns support)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Function names with builtin operator cause issue<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Headers grid is not reset after loading new Connection String<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Looks like if you use more than 8 parameters then you get error<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Pagination from Custom Header throwing error if you use EnablePageTokenForBody (i.e. use of [$pagetoken$] in body)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Placeholder functions not working in URL (fails only if column type is numeric)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Quote Symbol issue in ConnectionString generation<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; When Connection String contains RequestData='[$tag$]&#8217; it removes brackets when you load connection string<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; When same attribute name supplied multiple times in WITH clause, you might get misleading error<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Driver &#8211; Changing settings on UI (e.g. Connector File) doesnt reload Table dropdown on Preview Tab<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Driver &#8211; do not detect string as Int32 \/ Int64 (i.e. { id: &#8220;123&#8221; } JSON should be treated as string if in double quotes)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Driver &#8211; Floating numbers are failed to parse for non English environment (i.e. Finland) &#8211; e.g. Number &#8220;1.267662916E9&#8221; failed with error Cannot convert [1.267662916E9] to [Double]<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Driver &#8211; New values not updated &#8211; Table dropdown reset based on old connection<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Driver &#8211; Show user friendly message when value is too large o fit &#8211; e.g. Int32 field may throw &#8211; Value was either too large or too small for an Int32.<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>CSV Driver &#8211; User may get unclear error if different value type detected after 300 rows &#8211; Input String is not in correct format error<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; Many parallel connection can cause License not found error<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; Multiple connections from the local device sometimes throws CAL error (if 127.0.0.1 is reported as local IP along with 192.xxx)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; When column name is great than 128 chars you may see odd error &#8211; Deferred prepare could not be completed<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>General &#8211; Function search by name not working in example browser<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>General &#8211; Undo is not possible after using query from Query Builder in Preview<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JDBC Bridge Driver &#8211; NULL schema name cause issue with Power BI<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JDBC Bridge Driver &#8211; On some queries you get error &#8211; Pipe is broken<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JDBC Bridge Driver &#8211; You may get error &#8220;Host Process Broken&#8221; if data contains certain datatype<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JSON Driver &#8211; Regex is truncated when loading the connection<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Query with SOURCE and WITH using wrong order throws object reference not set error rather than Grammer error<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>XML Driver &#8211; Error in OpenQuery when Nested query is used with BASE64 decode function<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around All API Drivers and Multi statement support in Salesforce Driver. We also added many new features in various drivers along with bug fixes\/performance improvement features. To see full release notes click here New Features\/Improvements NEW:\u00a0All [&hellip;]<\/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":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>ODBC PowerPack 1.4.2 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"ODBC PowerPack 1.4.2 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-4-2-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.4.2 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"ODBC PowerPack 1.4.2 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2021-10-07T12:58:30+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=\"4 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-4-2-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/\",\"name\":\"ODBC PowerPack 1.4.2 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2021-10-07T12:58:30+00:00\",\"dateModified\":\"2021-10-07T12:58:30+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"ODBC PowerPack 1.4.2 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-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-4-2-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODBC PowerPack 1.4.2 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.4.2 released | ZappySys Blog","description":"ODBC PowerPack 1.4.2 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-4-2-released\/","og_locale":"en_US","og_type":"article","og_title":"ODBC PowerPack 1.4.2 released | ZappySys Blog","og_description":"ODBC PowerPack 1.4.2 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/","og_site_name":"ZappySys Blog","article_published_time":"2021-10-07T12:58:30+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/","url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/","name":"ODBC PowerPack 1.4.2 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2021-10-07T12:58:30+00:00","dateModified":"2021-10-07T12:58:30+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"ODBC PowerPack 1.4.2 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-1-4-2-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-4-2-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODBC PowerPack 1.4.2 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\/9403"}],"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=9403"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9403\/revisions"}],"predecessor-version":[{"id":9404,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9403\/revisions\/9404"}],"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=9403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=9403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=9403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}