ODBC PowerPack 1.8.3 released

Posted on by
Contents hide
1 Introduction
2 New Features/Improvements
3 Bug fixes

Introduction

This release brings tons of new features and bug fixes. We have added new connectors for FastSpring, Power BI, Zoho SalesIQ and new endpoint for Azure DevOps. It fixes important issues with connectors for JDBC Bridge Driver, Shopify, API Connector Framework and Data Gateway. To see full release notes click here

New Features/Improvements

  • NEW: API Connector – SharePoint – Modify get_main_site uses endpoint to use SiteId parameter so Test connection doesn’t fail due to default root site usage
  • NEW: All API Drivers – Add Support for NOT IN clause
  • NEW: All Drivers – Edited Custom Object name is not selected or visible
  • NEW: API Connector – Azure DevOps – Add new endpoints get_queries and get_workitems_by_query_id to fetch result from predefined query by its id
  • NEW: API Connector – ElasticSearch – Add Anonymous / Windows Authentication (No UserId/ Password)
  • NEW: API Connector – FastSpring – New connector to read / write data in FastSpring (Accounts, Orders, OrderItems, Products, Subscriptions, Quotes and more)
  • NEW: API Connector – Google BigQuery – Add Project and Dataset dropdown for easy selection on connection screen
  • NEW: API Connector – Power BI – New connector to read / write Power BI Datasets, Query using DAX
  • NEW: API Connector – Shopify – Add Insert, Update and Delete operations for Product, ProductVariant
  • NEW: API Connector – Shopify – Add new tables Locations, InventoryItems, InventoryLevels, Payouts
  • NEW: API Connector – Shopify – Allow Product Add, Update, Delete
  • NEW: API Connector – Shopify – By default include all orders (rather than just Open orders) to show POS orders
  • NEW: API Connector – Zendesk – Added API call delay property NextUrlWaitInMs to avoid error 429 (too many requests) during Pagination
  • NEW: API Connector – Zendesk – Added CRUD operations (Insert, Update, Delete and Upsert) for Users and Organizations table. For Users table you can do Upsert in Bulk mode
  • NEW: API Connector – Zendesk – Change Domain Label to Sub Domain to avoid confusion
  • NEW: API Connector – Zoho SalesIQ – New connector to read data from Zoho Chat System (SalesIQ) – Read Chats, Operators, Feedbacks, Reports and more
  • NEW: API Connector Framework – Add an option CacheClearFor to trigger cache invalidation for specific endpoints when this endpoint is called
  • NEW: API Connector Framework – Allow <Column Name=”my_array_name[].id” along with DotAsPath to produce SingleDataset input (e.g. nested Array as input without using LayoutMap)
  • NEW: API Connector Framework – Allow row column values in ValueTemplate for Input/Output Columns (i.e. Calculated Column Scenario) – Example <Column Name=”Display” ValueTemplate=”<<[$parent.first$] [$parent.last$],FUN_TRIM>>” … >
  • NEW: API Connectors – Zendesk – Allow bulk update for Users / Organization table
  • NEW: General – Improve license validation speed, add Subscription Id in UI
  • NEW: General – Show better message that you need Admin permission rather than “Custom object wasn’t saved”
  • NEW: JDBC Bridge – Add Support for Infor JDBC running on Java11, Java17 (right now copy of ionapi file needed)
  • NEW: JDBC Bridge Driver – Add custom QuoteChar option for underlying JDBC Driver (<blank>=never quote)
  • NEW: JDBC Bridge Driver – Add support for additional properties (not passed via Connection URL) – Salesforce CDP usecase
  • NEW: JDBC Bridge Driver – Add support for removing catalog, schema and quoted identifiers issued by apps like Power BI in Table mode (helps when JDBC driver doesnt support SQL sent by caller app)
  • NEW: JDBC Bridge Driver – Add support for removing Schema, Catalog names from table name (Use cases – Salesforce CDP in Power BI Table import)
  • NEW: JDBC Bridge Driver – Add support for reporting multiple catalogs (useful 3-levels nested Power BI view)
  • NEW: JDBC Bridge Driver – Add support for unquoting objects (Use cases – Apache Drill, Salesforce CDP in Power BI Table import)
  • NEW: JDBC Bridge Driver – Allow JdbcBridge.properties file location in Root directory or Local directory (i.e. where JdbcBridge.jar found) – Local file should take precedence
  • NEW: JDBC Bridge Driver – Allow Proxy settings (via JdbcBridge.properties file in java.args)
  • NEW: JDBC Bridge Driver – Java missing prompt should allow to choose Java version use like to install (e.g. Java11, 17, 21) rather than default to Java 8
  • NEW: JDBC Bridge Driver – Log additional properties on JDBC Bridge Log file
  • NEW: JDBC Bridge Driver – Log MM/dd prefix in Java log
  • NEW: JDBC Bridge Driver – Provide a way to do rolling log
  • NEW: JDBC Bridge Driver – Provide a way to include dependency jar files like DBeaver and other tools like BRIC
  • NEW: JDBC Bridge Driver – Provide a way to use user defined path for JAVA Version in JdbcBridge.properties file (e.g. java.path=c:\java\java8\bin)
  • NEW: JSON Driver – Add support for “@param” syntax along with “?” to support apps like MS Access + Data Gateway using SQL Native Client in ODBC

Bug fixes

  • FIX: All Drivers – Order grid not sorting by actual value
  • FIX: All Drivers – Some apps (e.g. Informatica ASCII instance requests SQL_C.CHAR) shows null string data due to invalid string length error (Apps requesting unicode string SQL_C.WCHAR works fine)
  • FIX: All Drivers – When Driver={….} is missing in connection string Load Settings fail
  • FIX: API Connector – Shopify – Product and ProductVariant table shows wrong datatypes
  • FIX: API Connector Framework – Allow brackets and other special character as column name for [$parent.column_name$] placeholder
  • FIX: API Connector Framework – AllowParamBindForLayoutMap and MultiSelectTemplate doesn’t work with ValueTemplate
  • FIX: API Connector Framework – Endpoint flagged as AllowParamBindForLayoutMap=true not visible in EndPoint list on UI
  • FIX: API Connector Framework – Larger than 64MB file upload hangs (or timeout) – SharePoint, OneDrive, Google Drive Connector upload issue
  • FIX: API Connector Framework – Multiple Template Usage can cause issue if you do not set EndPoint Properties in first Template
  • FIX: API Connector Framework – ValueTemplate invokes DirectPlaceholder function in wrong order (i.e. its called before {$value$} and [$param$] )
  • FIX: API Driver – Add support for 3 Part Column names so apps like MS Access works fine with Linked Table mode
  • FIX: API Driver – INSERT then SELECT cause Object disposed error
  • FIX: API Driver – near “Order”: syntax error (For any Reserved Keywords)
  • FIX: API Driver – Query Builder doesnt generate column list for Dynamic Expanded Columns which requires Parameters
  • FIX: API Driver – Query Builder shows unquoted Name in some cases
  • FIX: Data Gateway – Code Generation doesnt comment some unwanted lines and used wrong user name
  • FIX: Data Gateway – Service doesn’t restart if JDBC Bridge request was made in last one minute (jar file locked)
  • FIX: Data Gateway – Some apps like MS Access might fail to connect via SQL Native Client 11.0 – Object reference not set
  • FIX: Data Gateway – Use SHA256 for encryption to avoid FIPS violation
  • FIX: Data Gateway – When FIPS Policy turned on you cannot use Gateway UI – Provide a better error message with workaround
  • FIX: Data Gateway – You may get Object reference not set error when no users / dataset defined
  • FIX: JDBC Bridge – Large decimal types throws error – Unsupported numeric type (E.g. NUMERIC(255,2))
  • FIX: JDBC Bridge Driver – Dates like 0001-01-01 not allowed- Error: Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks.
  • FIX: JDBC Bridge Driver – Improve GetColumns ODBC compatibility
  • FIX: JDBC Bridge Driver – MA Access – List Tables fails
  • FIX: JDBC Bridge Driver – read error if column type is NUMERIC and precision > 28
  • FIX: JDBC Bridge Driver – Same table name in multiple catalogs cause issue (generate 3 parts table on UI table list pick if catalog is present)
  • FIX: JDBC Bridge Driver – Some JDBC Drivers (e.g. Amazon Athena) fails to query table list – Error : Unrecognized table type: “‘TABLE'”
  • FIX: JDBC Bridge Driver – TIME datatype throws error – Row read error: JBR error: java.lang.IllegalArgumentException at java.sql.Time.getYear(Time.java:161)
  • FIX: JDBC Bridge Driver – Very long sql statement cause IO Exception – Throw meaningful error
  • FIX: JDBC Bridge Driver, Salesforce Driver – Implement default QuerySpecialColumns
  • FIX: JDBC Driver – Wrong column metadata returned in some cases when you query multiple tables over same connection
  • FIX: JSON, XML, CSV Drivers – “Meta” property does not support columns with square brackets in the name
  • FIX: Salesforce Driver – MS Access Failed in Linked Table Mode – Didn’t understand relationship ‘DATA’ in field path
  • FIX: Salesforce Driver – Nested Subquery IN clause not supported
  • FIX: Salesforce Driver – Python 64 Bit Error – The driver did not supply an error!
  • FIX: Salesforce, API Driver – If you use true/false keyword in SQL it throws error – Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
Posted in Announcements.