{"id":7971,"date":"2019-09-11T19:47:17","date_gmt":"2019-09-11T19:47:17","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=7971"},"modified":"2019-09-11T19:47:17","modified_gmt":"2019-09-11T19:47:17","slug":"odbc-powerpack-v1-1-4-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/","title":{"rendered":"ODBC PowerPack v1.1.4 Released"},"content":{"rendered":"<h2>What&#8217;s New<\/h2>\n<p>In this version we focused on many bug fixes. Among them most important bug was limitation of only 2000 characters for SQL Query using OPENQUERY statement. Now you can use up to 8000 characters for OPENQUERY and if that&#8217;s not enough use EXEC AT statement to send query to Data Gateway. We also made many improvements with our Salesforce Driver so now you can use it along with Data Gateway or any other Reporting \/ ETL tools.<\/p>\n<h2 class=\"vertitle\">Version 1.1.4.10904 [Sep 11, 2019]<\/h2>\n<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All Drivers &#8211; New DSN dialogbox should suggest unique DSN name if already exists (Prevent accidental overwrite)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All Drivers &#8211; Add support for named parameters for stored procs (e.g. exec webrequest @uri=&#8217;https:\/\/abc.com&#8217; )<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Give Export \/ Import Settings option<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Provide list of database to caller App<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Use default log file name if only folder name is supplied<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Salesforce Driver &#8211; Add Placeholder Engine Support<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Query builders shows Password and Default Attributes on first time launch<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; RetryInfo not included in Connectionstring or generated SQL<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; URL JOIN may cause error for decimal values &#8211; Query execution error: Input string was not in a correct format.<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; URL on general tab is wiped out when you use save HTTP Connection<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; Field names are wrong StatucFieldxxxxxxx and StatucCheckxxxxxx rather than StatusCheckxxxxxx and StatusFieldxxxxxxx<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>CSV Driver &#8211; JOIN query fails in CSV driver with invalid format detected<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; MS SQL Server &#8211; Support more than 2000 characters for SQL in OPENROWSET and EXEC &#8211; In old version you may get error &#8211; Data is invalid if text is longer than 2000 characters<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; Query with Caching Option hangs<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; Use of META in WITH clause prevents error in some cases<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; You may get &#8220;The data is invalid&#8221; error when the query is too long<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; You may get Data is invalid error for OAuth Authorization failure<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; When you execute INSERT via Linked Server Query it Inserts row but fails with error at the end<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Load ConnectionString action throws Object reference not set to an instance of an object.<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Click on Generate SQL throws Object reference not set to an instance of an object<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Data is not returned in Excel when you use [From Microsoft Query] option<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; DELETE statement not working<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Escape sequence not supported (e.g. WHERE name =&#8217;Sam\\&#8217;s&#8217; )<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; OPENQUERY \/ EXEC AT doesn&#8217;t work with DELETE \/ UPDATE \/ INSERT<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; SSIS Failed to Generate Metadata due to character encoding issue<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Using * in SELECT with WHERE is not working<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What&#8217;s New In this version we focused on many bug fixes. Among them most important bug was limitation of only 2000 characters for SQL Query using OPENQUERY statement. Now you can use up to 8000 characters for OPENQUERY and if that&#8217;s not enough use EXEC AT statement to send query to Data Gateway. We also [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442],"tags":[494,210,83],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>ODBC PowerPack v1.1.4 Released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"ODBC PowerPack v1.1.4 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-v1-1-4-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 v1.1.4 Released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"ODBC PowerPack v1.1.4 Released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2019-09-11T19:47:17+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:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\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-v1-1-4-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/\",\"name\":\"ODBC PowerPack v1.1.4 Released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2019-09-11T19:47:17+00:00\",\"dateModified\":\"2019-09-11T19:47:17+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"ODBC PowerPack v1.1.4 Released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-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-v1-1-4-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODBC PowerPack v1.1.4 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\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ODBC PowerPack v1.1.4 Released | ZappySys Blog","description":"ODBC PowerPack v1.1.4 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-v1-1-4-released\/","og_locale":"en_US","og_type":"article","og_title":"ODBC PowerPack v1.1.4 Released | ZappySys Blog","og_description":"ODBC PowerPack v1.1.4 Released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2019-09-11T19:47:17+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_creator":"@https:\/\/twitter.com\/zappysys\/","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-v1-1-4-released\/","url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/","name":"ODBC PowerPack v1.1.4 Released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2019-09-11T19:47:17+00:00","dateModified":"2019-09-11T19:47:17+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"ODBC PowerPack v1.1.4 Released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-4-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-v1-1-4-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODBC PowerPack v1.1.4 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\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7971"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=7971"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7971\/revisions"}],"predecessor-version":[{"id":7972,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7971\/revisions\/7972"}],"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=7971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=7971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=7971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}