{"id":7296,"date":"2019-06-25T13:35:30","date_gmt":"2019-06-25T13:35:30","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=7296"},"modified":"2019-06-25T13:36:02","modified_gmt":"2019-06-25T13:36:02","slug":"odbc-powerpack-v1-1-3","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/","title":{"rendered":"ODBC PowerPack v1.1.3 Released"},"content":{"rendered":"<h2>What&#8217;s New<\/h2>\n<p>In this release we focused on adding URL JOIN Features which may allow many multi steps scenarios in one query. Bing Ads, Amazon MWS, Google BigQuery, Amazon Athena all these supports Job style queries which needs 3 step process (Create job, keep checking status, once done read report data). We also improved compatibility with Informatica and MS Access.<\/p>\n<h2 class=\"vertitle\">Version 1.1.3.10621 [Jun 24, 2019]<\/h2>\n<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Add option to replace placeholders in File content if you use IsMultiPart = True<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Add option EnableBodyPlaceholderForMultiPart to support replacing placeholders in file content in IsMultiPart mode (E.g. replace &lt;%access_token%&gt; or [$token$] or [$alias.MyJoinColumn$] )<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Add option OutputAsRawDocumentSingleRow (Returns __DOCUMENT__ field with entire File \/ Response string in one field)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Add Options to parse from any unstructured data &#8211; RawOutputExtractMode, RawOutputDataRowTemplate, RawOutputFilterExpr<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Add Status Check feature for all API drivers (Keep sending request until desired value found) &#8211; Options added EnableStatusCheck, StatucCheckMaxWaitSeconds, StatucCheckIterationWaitSeconds, StatusSuccessValue, StatusFailureValue<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Add support for ConnectionType in URL Join<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All API Drivers &#8211; Add Support for HMAC Authentication<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>All ODBC Drivers &#8211; Add support for Parameters<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Add Code Generator UI for SQL \/ Java<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Allow to add firewall rule via UI<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Data Gateway &#8211; Better logging about connected devices<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Salesforce Driver &#8211; Add support for Select * FROM<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers &#8211; joinXX_DataConnectionType Option not supported in JOIN URL<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>All API Drivers- Show meaningful error when same option used twice in WITH clause (Right now you see odd error &#8211; An item with the same key has already been added)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Apps &#8211; Informatica &#8211; Driver may output many extra empty rows in some cases<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Apps &#8211; MS Access &#8211; Linked table throwing call fail error (due to missing support for parameters in current driver)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; Certain errors not reported correctly back to caller<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; Enabling caching options may hang query in some case<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; Generic ODBC Connection Type fails with error Connection is Busy<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Data Gateway &#8211; When you use Meta option in WITH clause you may see empty rowset rather error in some cases<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Can not load table list in Excel \/ Power BI<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Failed to preview data in Power BI<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Load ConnectionString doesnt set Username<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; Nested queries not supported &#8211; You may get syntax error<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Driver &#8211; SSIS ODBC destination showing bad Table names in list<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>What&#8217;s New In this release we focused on adding URL JOIN Features which may allow many multi steps scenarios in one query. Bing Ads, Amazon MWS, Google BigQuery, Amazon Athena all these supports Job style queries which needs 3 step process (Create job, keep checking status, once done read report data). We also improved compatibility [&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,336,380,394],"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 v1.1.3 Released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"ODBC PowerPack v1.1.3 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-3\/\" \/>\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.3 Released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"ODBC PowerPack v1.1.3 Released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/\" \/>\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-06-25T13:35:30+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-06-25T13:36:02+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=\"2 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-3\/\",\"url\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/\",\"name\":\"ODBC PowerPack v1.1.3 Released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2019-06-25T13:35:30+00:00\",\"dateModified\":\"2019-06-25T13:36:02+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"ODBC PowerPack v1.1.3 Released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#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-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODBC PowerPack v1.1.3 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.3 Released | ZappySys Blog","description":"ODBC PowerPack v1.1.3 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-3\/","og_locale":"en_US","og_type":"article","og_title":"ODBC PowerPack v1.1.3 Released | ZappySys Blog","og_description":"ODBC PowerPack v1.1.3 Released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2019-06-25T13:35:30+00:00","article_modified_time":"2019-06-25T13:36:02+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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/","url":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/","name":"ODBC PowerPack v1.1.3 Released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2019-06-25T13:35:30+00:00","dateModified":"2019-06-25T13:36:02+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"ODBC PowerPack v1.1.3 Released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/odbc-powerpack-v1-1-3\/#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-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODBC PowerPack v1.1.3 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\/7296"}],"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=7296"}],"version-history":[{"count":2,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7296\/revisions"}],"predecessor-version":[{"id":7298,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7296\/revisions\/7298"}],"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=7296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=7296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=7296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}