ODBC PowerPack 2.1.0 Released

Announcements ODBC PowerPack
1

Version 2.1.0.10627 [Jul 16, 2025]

To view full release notes (including previous versions): click here

Download Latest Version

New Features/Improvements

  • NEW: All Drivers - Add support for Uid / Pwd mapping to Driver UserName / Password connection property (For Json / Xml Driver if OAuth used then Map Uid to ClientId)
  • NEW: All Drivers - Enhanced logging (For ODBC Log and JDBC Bridge - Java log)
  • NEW: All Secure FTP Drivers - Detect FIPS setting when Negotiation fail error happens and report a workaround (Better message)
  • NEW: API Connector - Google Ads - Added support for v20 and removed depricated versions (i.e. v17, v18, v19)
  • NEW: API Connector - Google Ads - Generate more accurate metadata with all columns supported by the resource, better names for column (e.g. rather than app.id call it AppId)
  • NEW: API Connector - Google Ads - Table outputs max 100 fields if more than 100 fields found
  • NEW: API Connector - Google Search Console Connector - New connector to read google search console data (Organic traffic)
  • NEW: API Connector - Google Search Console Connector - New connector to read google search console data (Organic traffic)
  • NEW: API Connector - JIRA - Add support for cascade selection field (parent-child dropdown)
  • NEW: API Connector - JIRA - Add support for cascade selection field (parent-child dropdown)
  • NEW: API Connector - OneDrive - Added an option for get_excel_worksheet and get_excel_worksheet_autodetect to read the formatted text values for date time or other types (e.g. rather than 44563.25 return 01/03/2022 06:00)
  • NEW: API Connector - OneDrive - Added response caching for get_excel_worksheet and get_excel_worksheet_autodetect endpoints for better speed and reduced API calls
  • NEW: API Connector - OneDrive - Added support for Certificate Authentication (Sign JWT using Certificate File / Private Key - *.p12, *.pem, *.pfx)
  • NEW: API Connector - OneDrive - Remove unused scopes Sites.Read.All, Sites.ReadWrite.All
  • NEW: API Connector - SharePoint - Added an option for get_excel_worksheet and get_excel_worksheet_autodetect to read the formatted text values for date time or other types (e.g. rather than 44563.25 return 01/03/2022 06:00)
  • NEW: API Connector - SharePoint - Added response caching for get_excel_worksheet and get_excel_worksheet_autodetect endpoints for better speed and reduced API calls - Copy
  • NEW: API Connector - SharePoint - Added support for Certificate Authentication (Sign JWT using Certificate File / Private Key - *.p12, *.pem, *.pfx)
  • NEW: General - Add new features for FUN_PROPERCASE function (new parameters for case_type for ProperCase or camelCase, segment_split_character, search_for_regex_pattern, replace_with, segments_to_remove )
  • NEW: General - FILE_CREATE_DATE and FILE_LASTEDIT_DATE - Add new parameters (date_format and is_utc)
  • NEW: JDBC Bridge Driver - Include sample JdbcBridge.properties in the Installation directory
  • NEW: JDBC Bridge Driver - New ConnParam Provide a more generic way to force reading data using specific JDBC method (e.g. read oracle.sql.TIMESTAMP using getTimestamp( ) function rather than getObject( ) to avoid Serialization error)
  • NEW: JDBC Bridge Driver - Provide a new option [app.port=12345] in the JdbcBridge.properties file to choose a custom Tcp Port for JDBC Bridge Server (Helps if port conflict with other app or NAT reserved range)
  • NEW: JSON / XML / CSV Driver - OAuth Connection - New Provider GenericJwt for Private Key Authentication (Sign JWT using Certificate File / Private Key - *.p12, *.pem, *.pfx)
  • NEW: Salesforce Driver - Add support for mapping uid and pwd connectionstring parameters to UserName, Password, SecretToken or ClientId, ClientSecret, RefreshToken (allow [$UID$] , [$PWD$] placeholders to replace value in specific field)

Bug fixes

  • FIX: API Connection Manager - Google BigQuery Connector - [AuthorizationCode parameter] Value cannot be null
  • FIX: API Connectors - SharePoint - list_folders endpoint look for *.xls files rather than folders
  • FIX: Excel Driver - You may get an error string was not recognized as a valid DateTime.
  • FIX: JDBC Bridge Driver - Add fallback method to detect Metadata when getMetadata for prepareStatement( ) fails or not supported by JDBC driver (Usecase Infor JDBC in SSIS - shows blank metadata)
  • FIX: JDBC Bridge Driver - For some JDBC returning Time value as DateTime rather than Timespan you may get error - System.InvalidCastException: Specified cast is not valid (Usecase: Trino Time type)
  • FIX: JDBC Bridge Driver - Java Logger doesnt append log once new java.exe session starts (overwrites old file)
  • FIX: JDBC Bridge Driver - java.lang.IllegalArgumentException: Can't serialize class oracle.sql.TIMESTAMP
  • FIX: JDBC Bridge Driver - Throws exception after hitting [Preview Data] button second or more times (Neo4j or Druid) - New Command created each time
  • FIX: JDBC Bridge Driver - UserId and Password not supplied correct way from Uid / Pwd attribute
  • FIX: JDBC Bridge Driver - You may ger Java NullPointer Exception on Table dropdown click in v1.8.x or higher (v1.7 works)
  • FIX: JDBC Bridge Driver - You may get error - class java.lang.ClassCastExceptio: class java.lang.Long cannot be cast to class java.lang.Short in some cases (Usercase: Trino)
  • FIX: JSON / XML / CSV Driver – Metadata Issue: When creating a custom object (stored procedure) and assigning an alias to a string-type column, the driver incorrectly detects the column as Int32
  • FIX: JSON / XML / CSV Driver - OAuth Connection - CacheToken option doesnt work in some cases when Expiration Time is not returned in token response
  • FIX: JSON / XML / CSV Driver - OAuth Connection - For OAuth1 sometimes bad signature generated (Specially you have Query parameters in URL with special chars e.g. [ ] )
  • FIX: JSON Driver - Pagination stops randomly for counter based pagination mode when array filter with condition or nested field used (e.g. $.somearray[?(@comments==0)] --OR-- $.somearray[*].nestedfield )