Release notes

If you already purchased software then you must download ODBC PowerPack installation file from Customer Download Area (Click here). You cannot activate purchased license key if you downloaded Trial build from public site. To apply license key you must download FULL version.

Version 1.9.0.11015 [Oct 29, 2024]

New Features/Improvements

NEW: API Connector - All Google Connectors - Add Redirect URL Property to support Web Application credentials (Advanced Option)
NEW: API Connector - All Google Connectors - Update instructions for all Google API Connectors to Publish App (without this custom app expires refresh_token every 7 days)
NEW: API Connector - Amazon Seller Partner (SP-API) - New connector to read / write data from SP-API (Orders, Reports, Inventory etc)
NEW: API Connector - Asana - Read / Write Tasks, Sub Tasks, Projects, Users, and more
NEW: API Connector - Azure DevOps - Query list doesnt refresh after changing Project prameter for get_workitems_by_query_id endpoint on Query Builder UI
NEW: API Connector - Azure DevOps - Updated datatypes for some endpoint columns (previously they were all string types)
NEW: API Connector - CosmosDB - Change default rows per page (MaxItemCount) from 100 to 1000 for performance improvement
NEW: API Connector - CosmosDB - Updated datatypes for some endpoint columns (previously they were all string types)
NEW: API Connector - Gmail - Add Htmlbody / PlainTextBody columns (Previously it was always null)
NEW: API Connector - Gmail - Add new feature to download attachments / list attachments
NEW: API Connector - Gmail - Added extra columns / fixed datatypes for Messages table
NEW: API Connector - Google BigQuery - Add support for TIMESTAMP columns to display as DateTime column along with original column (new column NameOfTimeStampColumn_DT)
NEW: API Connector - JIRA - Add option to choose custom domain in service URL
NEW: API Connector - JIRA - Add option to use PAT (Personal Access Token) for Authentication (Bearer Token)
NEW: API Connector - JIRA - Added Lookup support (WHERE Id=123) for SELECT / UPDATE / DELETE operations
NEW: API Connector - JIRA - Performance enhancements and datatype changes for TextArea fields (Detect them as DT_NTEXT rather than DT_WSTR)
NEW: API Connector - JIRA - support for writing Option / Radio fields by Value and Id (introduced new fields customfields_xxxx_id and customfields_xxxx_value)
NEW: API Connector - Outlook Mail (Office 365) - Allow to get messages from a specific folder for get_messages and get_my_messages endpoints
NEW: API Connector - Outlook Mail (Office 365) - New endpoint download_message_attachments to get multiple attachments by search condition
NEW: API Connector - Service Desk Plus ManageEngine - Add endpoints to read Project data (Projects, Memebers, Milestones, Comments)
NEW: API Connector - Service Desk Plus ManageEngine - Add endpoints to read Task data
NEW: API Connector - ServiceDesk Plus (Managed Engine by Zoho) - Added new tables / endpoints related to Projects, Members, Milestones, Changes, Assests, Problems, Contracts and PurchaseOrders
NEW: API Connector - Shopify - Change datatype for LineItems to DT_NTEXT to handle more than 4000 chars
NEW: API Connector - Smartsheet - New connector to read / write SmartSheet data (Sheets, Rows, Contacts etc)
NEW: API Connector - Zendesk - Add new endpoint search_export to read more than 1000 search records
NEW: API Connector - Zendesk - New incremental export endpoints for User, Organization and Ticket Metric Event (Fetch updated records only)
NEW: API Connector - Zendesk - Performance improvement for many paginated endpoints such as get_tickets, get_tickets_incr, get_users, get_organizations, get_ticket_metrics and more
NEW: API Connector - Zendesk - Update Offset based pagination to cursor based pagination (Zendesk Announced they will discontinue old pagination)
NEW: API Connector - Zoho CRM - Add support for new dataceneters (Saudi Arabia (SA), Canada (CA) and Japan (JP))
NEW: API Connector - Zoho CRM - Add support for V3, V4... V7 APIs
NEW: API Connector - Zoho CRM - Document Lookup write examples (Insert, Update)
NEW: API Connector - Zoho CRM - Support for choosing higher API version (e.g. V7) - Set at connection level
NEW: API Connector Framework - Add EndPoint property DisableChildEndPoint - Useful when used with ParameterScope (Zoho v3+ usecase)
NEW: API Connector Framework - Add new EndPoint Property PushToChildEndPoint - Support for passing Parent variable to child endpoint if parent is dynamically expanded (e.g. Zoho Usecase of get_[$parent.api_name$] used in child_Search)
NEW: API Connector Framework - Add new UI Editor type for Browse Folder (e.g. <Param ... Editor="FolderOpen" ... )
NEW: API Connector Framework - Add support for IF_NULL (conditional output based on null value) in Functions property for InputColumns and OutputColumns (Previously when null value ignored Functions property and results in null)
NEW: API Connector Framework - Add support for Key Attribute for Auth Parameters (Right now it must use Name)
NEW: API Connector Framework - Add Support for Static Options when MultiSelectAllOnBlank or MultiSelectAllOnDefault specified and no OptionsEndPoint listed
NEW: API Connector Framework - Allow KeyIf property to use flag for MapToParam and Name to use for Key column (matahc with Param name) - e.g. KeyIf="id|1|IdOrKey"
NEW: API Connector Framework - Allow option to hide Generate Token button and AccessToken (introduce TokenUIMode Property for OAuth connection type)
NEW: API Connector Framework - Allow Property Type Paramater with new attribute PropertyScope=ApiObject to make EndPoint Attribute Dynamic
NEW: API Connector Framework - Allow to use Column Placeholders in Function during Expand (e.g. <Column Exapnd="True" Functions="[$parent.id$].....".... > ) for Dynamic Columns (Expand=True)
NEW: API Connector Framework - Provide a way to use multiple endpoint names in OptionsEndPoint and Union Result (E.g. OptionsEndPoint="get_cars;get_bikes"
NEW: API Connector Framework - Three new properties for OAuth Connection - AuthorizeInFullBrowser, UseLoopbackUrlForDefault, CustomWarningForFullMode
NEW: API Connector Framework - Trim LayoutMap to avoid whitespace error
NEW: API Driver - Add support for BULK INSERT (useful for ETL Write Scenario in tools like Informatica, SSIS, Talend Targets with Bulk option ON)
NEW: API Driver - Add support for more granular datatypes (e.g. DT_STR (ANSI), DT_DBDATE...)
NEW: API Driver - Allow to run native SQL without #DirectSQL prefix - Add connection level option TreatAsDirectSqlWhenNoPrefix (use #ClientSQL to invoke client side SQL engine)
NEW: API Driver - Enable Direct Editing of Client Secret in the Connection Settings instead of clicking "..." button
NEW: API Driver - Enable Direct Editing of Client Secret in the Connection Settings instead of clicking "..." button
NEW: API Driver - Introduce a new option [CacheToken] on [Advanced] tab to enable reusing token / reduce number of token renew calls / share same token with multiple processes using same API credentials
NEW: Data Gateway - Update Code Generator to use new Provider MSOLEDBSQL rather than depricated SQLNCLI11 for Linked Server ( [Microsoft OLE DB Driver for SQL Server] is now preferred OLEDB driver and [SQL Server Native Client] is deprecated)
NEW: Excel Driver - Add new property [DateFormat] and [DateTimeFormat] to control Date format for Date value with or without time part (right now all date values (even without time part) displayed with long format yyyy-MM-dd HH:mm:ss and no way to control it)
NEW: Excel Driver - Provide additional system table __SheetList__ to return list of tabs on a sepected sheet
NEW: General - Add Encoding argument support for file_write_text
NEW: General - Add Generator Code button
NEW: General - Add Logo / Title / Description for API Connector and other Drivers
NEW: General - Add new parameter returnStaticValueOnBadExpression for FUN_TO_DATETIME / FUN_TO_DATE / FUN_TO_DATETIME_UTC - If user entered invalid expression then allow to return expression or inputvalue as is if supplied
NEW: General - Add option on License Manager (Logging Tab) to turn on global logging for HTTP / HTTPS Requests (Useful when Fiddler not installed)
NEW: General - Add support for RFC2397 style base64 string in BASE64_TO_FILE(...) function
NEW: General - Add ThrowIfMissing parameter for FUN_JSON_TO_TEXT (bad filter throws error if parameter is passed)
NEW: General - Added details for ODBC Logging
NEW: General - Allow suffix in placeholder function name "_safe" or "_strict" (e.g. FUN_READFILE_SAFE) to fail or return error message rather than ignoring error (current behavior)
NEW: General - FUN_IF add two new match operators - In / NotIn - Example <<2|~|In|~|1,2,3,4|~|found|~|not found,FUN_IF>> - Use comma to supply options
NEW: General - FUN_IF date time compare doesnt work in Eq, NotEq, Lt, Gt, LtEq, GtEq operator
NEW: General - FUN_IF numeric / datetime compare doesnt work for some culture (e.g. German, Finland with comma as decimal point) - Operator Failed Eq, NotEq, Lt, Gt, LtEq, GtEq operator
NEW: General - New placeholder function FUN_CASE with (example <<some_color_here|~|eq:red|~|color is red|~|eq:green|~|color is green|~|default message,FUN_CASE>> ) - Allowed Match Operators are Eq, NotEq , Gt, GtEq, Lt, LtEq, Between, Contains, ... few more
NEW: General - Provide an extra property SettingsFile in ConnectionString to overcome 1024 chars limit for some Programming languages (e.g. C# OdbcConnection class)
NEW: JDBC Bridge Driver - Fix JDBC prepare and params
NEW: JDBC Bridge Driver - Provide a new Metadata option (JdbcTablesMetaMode='IgnoreTypes') to handle faulty JDBC driver getTables implementation (e.g. Infor JDBC cannot display Views in MS Access)
NEW: JDBC Bridge Driver - Provide an option (LargeNumericHandling) to handle Large Numeric values (TreatAsString, Truncate, Throw) - Right now its treated as string and not convert to decimal
NEW: JDBC Bridge Driver - text datatype may not work in some apps (e.g. SSIS - Using DT_NTEXT and DT_TEXT )
NEW: JSON / XML / CSV Driver - Add an option to skip Authorization header if Custom Authorization Header name is selected
NEW: JSON / XML / CSV Driver - Allow to export metadata as lower_case format for API Connector (OutputColumns in XML Format)
NEW: JSON / XML / CSV Driver - Introduce a new option [CacheToken] on [OAuth2 Grant Options] tab to enable reusing token / reduce number of token renew calls / share same token with multiple processes using same API credentials
NEW: JSON / XML / CSV Driver - OAuth - Allow RedirectUrl for all Google Providers
NEW: JSON / XML / CSV Driver - OAuth - Allow to supply custom headers in token or data requests (New Properties ExtraHeaders) - e.g. x-accountid:AAA||x-apikey:BBB (See Advanced Tab)
NEW: JSON / XML / CSV Driver - OAuth - Space suffix has no effect in Custom Auth Scheme (its trimmed when request is sent)
NEW: JSON / XML / CSV Driver - Redirect 307 / 308 StatusCode along with 301 and 302
NEW: Salesforce / API / Excel Driver - Give new connection level property [OutputOption] for INSERT/UPDATE/DELETE same as WITH ( Output='0|1|*|comma-separated-column-list...' ) now you can define at connection level as default setting
NEW: Salesforce Driver - Add a new option OwnerChangeOptions (Useful for Insert/Update operations in Target)
NEW: Salesforce Driver - Add support for Bulk API in SELECT query (e.g. #bulkmode select * from MyTable)
NEW: Salesforce Driver - Add support for Bulk INSERT Operations (useful for ETL Write Scenario in tools like Informatica, SSIS, Talend Targets with Bulk option ON)
NEW: Salesforce Driver - Add support to update / insert / upsert Lookup field by External ID rather than Salesforce Id
NEW: Salesforce Driver - Allow to set custom InstanceURL on Advanced Tab (Set AccessToken dynamically from external system scenario)
NEW: Salesforce Driver - Enable PKCE Code Verifier for OAuth 2.0 by default (Advanced Tab) - Without this on generate token user may see error => missing required code challenge

Bug fixes

FIX: API Connector - Outlook Mail (Office 365) - Some fields have wrong datatypes
FIX: API Connector - Power BI - Some fields have wrong datatypes
FIX: API Connector - CosmosDB - Maximum 10000 rows are fetched because PagingByUrlMaxPages is set to 100 by default. It needs to be 0 for unlimited pages
FIX: API Connector - Google BigQuery - read_table_data endpoint throws Invalid dataset ID error
FIX: API Connector - JIRA - Clicking on [Show Advanced Parameters] checkbox throws error for Fields table / endpoint - Invalid ConnectionString format
FIX: API Connector - JIRA - Insert / Update for some Custom Field Types not working (i.e. Dropdown, Radio, List, Paragraph)
FIX: API Connector - Jira - Some fields (e.g. Summary) are too small for ETL tools like SSIS
FIX: API Connector - Zoho CRM - Lookup fields are NULL and Lookup_Field_Id is not in the output (e.g. select Account_Name from Deals)
FIX: API Connector Framework - Order attribute for Column / EndPoint / Table tags may not work correctly if you have Expand=True
FIX: API Connector Framework - Throw meaningful error if Lookup operation is not supported in UPDATE / DELETE and user tried to use Id in WHERE clause
FIX: API Driver - Add support ODBC Parameters in INSERT (e.g. "?" replacement)
FIX: API Driver - Bad Numeric Precision reported (e.g. 255) for some columns (it must be between 1 and 28)
FIX: API Driver - Cached RefreshToken causes "invalid_grant" error
FIX: API Driver - If Service URL has --regex suffix UI may add duplicate entries
FIX: Data Gateway - Datetime precision is lost for millisecond part (only 2 digits supported)
FIX: General - Add option to allow creation of DSN via command line
FIX: General - Allow decimal format timestamp as input for FUN_UNIX_TIMESTAMP_MS_TO_DATE (e.g. <<1.577941199123E9, FUN_UNIX_TIMESTAMP_MS_TO_DATE>> OR <<1577941199.123, FUN_UNIX_TIMESTAMP_MS_TO_DATE>> both must produce 2020-01-02T04:59:59.123)
FIX: General - DateTime Parameter Binding may ignore milliseconds part in value
FIX: General - FUN_IF does case-sensitive RegX match by default (unlike other operations) and ignores use if case-sensitive argument
FIX: General - FUN_IF returns input value if match part is set to Blank (e.g. {input}|~|Eq|~|{something}|~||~|not match,FUN_IF)
FIX: General - fun_unix_timestamp_to_date and fun_unix_timestamp_ms_to_date doesnt work in some cultures where dot not allowed in time part (e.g. Finland)
FIX: General - License UI saves settings.xml to custom data but reads from ProgramData causing mismatch
FIX: General - Multiple license validation entries logged in some cases
FIX: General - Sometimes when you click OK then parent window gets minimized (i.e. Visual Studio is minimized on close UI)
FIX: General - View Meta data - API Driver XML format may not show correct values for Name attributues for nested fields (e.g. nested_info.name it may show nested_info_name)
FIX: General - You may get error - Requested Clipboard operation did not succeed - on copy text to clipboard operation
FIX: HTTP Connection Manager - Dynamic Token Auth Preview shows {none} rather than blank
FIX: JDBC Bridge - string index out of range
FIX: JDBC Bridge Driver - DSN Less mode ConnectionString doesnt use ConnParams in some cases (e.g. in SSIS ConnParams params not set)
FIX: JDBC Bridge Driver - JBR error: java.lang.IllegalArgumentException: Cannot format given Object as a Number at java.text.DecimalFormat.format(....)
FIX: JDBC Bridge Driver - Max Rows setting is not working for Preview UI in some cases
FIX: JDBC Bridge Driver - Mixing DML batches throws (e.g. SELECT, UPDATE) - The method execute() cannot take arguments on a PreparedStatement or CallableStatement.
FIX: JDBC Bridge Driver - Some Apps (e.g. Informatica) may detect BigInt type as string due to wrong type mapping by driver
FIX: JDBC Bridge Driver - Some decimal types (e.g. NUMERIC(255, 2) ) can be reported as bad string value
FIX: JDBC Bridge Driver / API Driver - Some Apps (ODBC Version 2) may not detect date / time types correctly (e.g. Informatica PowerCenter fails to detect date type)
FIX: JDBC Bridge Driver + Salesforce: You may not see fields in generated query on Preview UI when you select table name from the dropdown
FIX: JSON / CSV / XML Drivers - Custom Replace function throw value cannot be null error when you keep ReplaceWith blank (if you like to replace something with Blank)
FIX: JSON / XML / CSV Driver - MultiPart with file upload fails due to longer than 70 chars auto generated boundary (Setting custom MultiPartBoundary Property works fine)
FIX: JSON / XML / CSV Driver - OAuth - All Google Providers (Youtube, Sheets, Drive, Calendar, BigQuery, Gmail) - Add access_type=offline&prompt=consent - You may not get refresh token back in some cases after authorize without this
FIX: JSON / XML / CSV Driver - OAuth - If Authorization URL has Query string it may fail to extract Token sometimes
FIX: JSON / XML / CSV Driver - OAuth - Manual loopback redirect URL (e.g. http://localhost:1234) does not work in Google API
FIX: JSON / XML / CSV Driver - OAuth - Sometimes after error Generate Token button is not enabled
FIX: JSON / XML / CSV Driver - OAuth / HTTP - Fix some misleading label for RetryMultiplyWaitTime setting fround on Error Retry Mode UI on HTTP / OAuth connections
FIX: Salesforce Driver - Add support for ODBC Parameters (e.g. "?" replacement)
FIX: Salesforce Driver - SQL Server - Linked OPENQUERY removes the decimal point for some cultures (e.g. German region)
FIX: Salesforce Driver - Throws Invalid URI: The URI is empty error when you choose Custom Service Type (Other)
FIX: Salesforce Driver - Use of astrisk (e.g. * ) in WHERE clause causes error or no rows
FIX: Salesforce Driver - When all columns requested (select * from) and it has bad SQL then rather than Syntax error you may get Object reference not set rather than actual error
FIX: Salesforce Source - Including nested object Id column in SELECT throws error - the item with the same key has been already added (e.g. SELECT Account.Owner.Id FROM Contact)

Version 1.8.3.10208 [Feb 27, 2024]

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

Version 1.8.2.11019 [Nov 22, 2023]

New Features/Improvements

NEW: All Drivers - Remember last query when you Open / Close UI
NEW: JDBC Bridge Driver - Hide objects like INDEX, SEQUENCE, SYSTEM INDEX, Blank Type
NEW: JSON / XML/ CSV Driver - Add support for AccessMode in WITH clause - Query builder generated SQL throws error - Execution error: Query execution error: Option 'accessmode' is not supported!
NEW: JSON / XML/ CSV Driver - When Direct Value set and you select from Table dropdown throwing an error for Direct String mode 'Data Path' parameter must be set
NEW: JSON, XML Drivers - Treat "$" as blank filter

Bug fixes

FIX: All JSON / XML / CSV Drivers - Casting and aggregate functions is not working for the string type data like 0000160209
FIX: API Driver - Query Example correction needed for generic_endpoint (should be changed to generic_request)
FIX: Data Gateway - Catalog / Schema Name with Dash, dot or space cause issue
FIX: Data Gateway - In a rare case you might get error loading Setting dialog box - Cannot load assembly - Path not found
FIX: Data Gateway - JDBC Bridge - Power BI Error - Communication Link failure - When underscore or dot found in object name
FIX: Data Gateway - No tables / schema listed for some drivers (e.g. PostgreSQL JDBC) - When JDBC Bridge accessed via SQL Native Client ODBC talking to Gateway
FIX: Data Gateway - Salesforce - Many catalogs listed when you connect gateway via SQLNcli driver
FIX: Data Gateway - Salesforce - You may get malformed query error in Apps like Power BI when you access in Table selection mode
FIX: Data Gateway - Some JDBC fails when catalog (3part query) not supported but App like Power BI sends 3 parts query
FIX: JDBC Bridge - Schema name is not used to fetch table fields
FIX: JDBC Bridge Driver - Encountered Unexpected token ";"
FIX: JDBC Bridge Driver - Give option [Quote names] to handle quoted names correctly (e.g. column-1 to "column-1" ) when you select table name on the Preview tab
FIX: JSON / XML / CSV Driver - Column names with # and ? characters needs proper quoting in auto generated query
FIX: JSON / XML / CSV Driver - Some columns with accent / unicode character in the name might not be quoted in auto generated query
FIX: Salesforce Driver - Quoted identifiers generated by apps like Power BI throws error

Version 1.8.1.10901 [Sep 21, 2023]

New Features/Improvements

NEW: All Amazon, Azure, Secure FTP Drivers- Allow ConvErrorHandlingMode option to continue on type conversion / truncation errors
NEW: All API Drivers - Add support for CASE Statement in WHERE / GROUP BY Clause
NEW: All Drivers - Add Advanced Option TempStorageMode (Memory=0, Disk=1) and TempStorageDirectory to handle OutOfMemory Exception for large dataset result
NEW: All Drivers - Allow to change max rows setting more than 20000 rows in the Preview Tab
NEW: API Driver - Add support for Multi Key Lookup in SELECT statement (e.g. select * from OrderDetails where OrderId=100 and ItemId=22)
NEW: API Driver - Add Support for true | false keywords in INSERT / UPDATE statements
NEW: Data Gateway - Prompt to restart like datasources tab when user edit Users and dont restart
NEW: Data Gateway - Salesforce - List Tables in SSMS for Linked Server
NEW: Excel Driver - Choose Tab automatically with matching string in any Tab - New Property SearchStringForTabSelect
NEW: Excel Driver - Provide a way to read all Tabs with matching regex
NEW: General - New connection level property ConnectionStringFile property to load long connection string from file - Specifically addressing the 1024+ character limit with ConnectionString for Ado.net / OdbcConnection classes in programming (e.g. C#)
NEW: JDBC Bridge Driver - Add Option to force output on or off ( Prefix #Output-On or #Output-Off)
NEW: JDBC Bridge Driver - Provide options to enable retry certain errors (e.g. RetryCount, RetryDelay,RetryDelayMultiplier,RetryMessageRegex)
NEW: Salesforce Driver - Add support for AssignmentRuleId, UseDefaultAssignmentRule options in UPDATE, INSERT, UPSERT
NEW: Salesforce Driver - Add Support for Odbc SQLPrepareW (Fetch Meta without invoking Data Fetch)
NEW: Salesforce Driver - Increase default BatchSize from 200 to 2000 rows per batch to increase the read speed
NEW: Salesforce Driver - Provide a connection UI option - IncludeDeleted (Includes deleted rows in SELECT query)
NEW: Salesforce Driver - Update examples to indicate how to use FieldsToSetNullIfInputNull, AssignmentRuleId, UseDefaultAssignmentRule, AllOrNone, AllowFieldTruncation, AllowSaveOnDuplicates options

Bug fixes

FIX: All API Drivers - EXEC WebRequest might fail sometimes with SSL/TLS Error
FIX: All API Drivers - Failure in EXEC WebRequest does not show full error sometimes - It shows just one line error - Target Invocation error instead
FIX: All API Drivers - Long Text (i.e. DT_NTEXT) is detected as DT_WSTR(50) when you choose XML Connector Format to view metadata
FIX: All API Drivers - When you use ConvErrorHandlingMode option in WITH clause it says not supported
FIX: All Drivers - ConvErrorHandlingMode option not working correctly
FIX: API Driver - Create Virtual table with re-ordered required columns only and on preview it is loading data based on column index instead of the particular column data
FIX: API Driver - Created Custom Virtual Table is not listed in the drop down
FIX: API Driver - Only last statement executed when multiple SQL executed in a batch separated by semicolon (e.g. your-sql-stmt; your-sql-stmt ; your-sql-stmt)
FIX: API Driver - Qualified Key (tablename.keyname) in WHERE is not parsed as Primary Key (e.g. SELECT * FROM MyTable WHERE MyTable.Id=123)
FIX: API Driver - Quote around for column names with special characters (e.g. - , $, . )
FIX: API Driver - When WHERE clause not supplied DELETE / UPDATE doesnt do anything
FIX: API Driver - You may get OutOfMemory Exception for large dataset (Cache Options in WITH clause not working either)
FIX: Data Gateway - Empty Query might hang
FIX: Data Gateway - Enforce Database name in connection setting / throw better error when DB name is not set - Currently you see misleading error: Object reference not set
FIX: Data Gateway - In certain situation you will see CAL needed error (even previous connection failed) - For example connection from Machine-1 caused SSL/TLS secure channel... and later connect fromMachine-2
FIX: Data Gateway - Some registry key entries not cleaned up (under HKEY_CURRENT_USER\.DEFAULT\SOFTWARE\Classes\CLSID) if Service account has no write access to HKEY_CLASSES_ROOT
FIX: Data Gateway - SqlNative Client DSN UI doesnt show any entry for Database dropdown
FIX: JDBC Bridge Driver - After caller app is crashed java.exe is not released from memory (orphaned)
FIX: JDBC Bridge Driver - Catalog name listed many times in Power BI / Excel or some other Apps or Sometimes tables not listed
FIX: JDBC Bridge Driver - Files sitting in same folder as driver jar not detected (e.g. Infor *.ionapi file not found error)
FIX: JDBC Bridge Driver - Hide unwanted objects from preview tab (e.g. SYSTEM VIEWS, INDEX)
FIX: JDBC Bridge Driver - High CPU usage issue
FIX: JDBC Bridge Driver - Stored Proc doesnt return output
FIX: Salesforce Driver - Column [__id] wasn't found - Error occurs if system columns used in the WITH Clause Output attribute for INSERT / UPDATE / DELETE / UPSERT
FIX: Salesforce Driver - ConcurrencyMode option in INSERT / UPDATE / UPSERT .... WITH clause throws error - Invalid cast from 'System.String' to 'ZappySys.Crm.Salesforce.ConcurrencyMode'.
FIX: Salesforce Driver - EnableBulkMode=1 causes duplicate data for INSERT / UPSERT Operation when called via OPENQUERY in SQL Linked Server but if you use EXEC .. AT works fine
FIX: Salesforce Driver - Inner Exception not displayed in some cases (e.g. Proxy Issue)
FIX: Salesforce Driver - UPDATE / INSERT Static Value doesnt output column if you use Output=[columns list]
FIX: Salesforce Driver - UPDATE Not showing columns in the output if its not matching exact case as defined in Salesforce
FIX: Salesforce Driver - UPDATE with OUTPUT=[column list] doesnt work (it skips columns you like to output)
FIX: Salesforce Driver - When Where clause in DELETE / UPDATE returns no record then you might get error - Index was out of range
FIX: Salesforce Driver - When you use SOURCE Clause with Output='Column1, Column2, ...' or Output='*' you always get lower case names in the output
FIX: Salesforce Driver - White space before DELETE / UPDATE causes error - Index and length must refer to a location within the string
FIX: Salesforce Driver - You may get OutOfMemory exception when many input rows supplied by SOURCE clause in UPDATE/DELETE/INSERT/UPSERT statement plus Output option supplied in WITH
FIX: Salesforce, API Driver - CRUD Operations with SOURCE clause may not fire operation if issued via ExecuteNonQuery Method

Version 1.8.0.10601 [Jul 11, 2023]

New Features/Improvements

NEW: API Driver - CosmosDB - New connector to Read / Write / Query documents and other objects (e.g. Database, Containers)
NEW: API Driver - Azure DevOps (TFS) - New connector to Read / Write / Query items (e.g. Tasks, Bugs, User Story)
NEW: API Driver - ServiceNow - New connector to Read / Write / Query tables (e.g. Incidents, Tasks, Users)
NEW: API Driver - MailChimp - New connector to Read / Write / Query MailChimp data (e.g. Campaigns, Lists, Subscribes, Reports)
NEW: All API Drivers - Allow bool as alias for boolean type in META clause (e.g. META='flag: bool')
NEW: All API Drivers - Allow just column names without datatype in Meta - use string(2000) as default if type missing (e.g. select * from tbl WITH(META='col1;col2;col4;col5:int;col6:string(100)') )
NEW: Amazon JSON / XML /CSV Driver - Update AWS SDK (Core Driver to v3.7)
NEW: API Connector Framework - Add Support for Multiple LookupEndPoints based on Parameter count (LookupEndPoint="ep_by_customerid, ep_by_orderid")
NEW: API Driver - HubSpot - Add Upload File endpoint
NEW: Data Gateway - Encrypt Setting File with user defined password
NEW: General - Update Client Side Query Engine to v3.40
NEW: JDBC Bridge Driver - Add logging
NEW: JSON / XML / CSV Driver - Add option to Create new API Connector File from UI settings on the Preview Tab
NEW: JSON / XML / CSV Driver - Add support for reading *.tar.gzip file (multiple files in one tar.gzip)
NEW: JSON / XML / CSV Driver - ClientCertificate not supported if you change SslVersion settings other than Default

Bug fixes

FIX: All API Drivers - Certain errors not bubbled up to the caller application
FIX: All API Drivers - When META is set to int, bool, date and you encounter blank data then it throws error about conversion (we should treat blank number, date, bool as null) - Error Input string was not in a correct format.
FIX: All Drivers - Misleading error is thrown (Value cannot be null) when you run Stored Proc which has syntax issue (i.e. not starting with CREATE PROC statement)
FIX: All Drivers - Duplicate column names in SELECT cause misleading error (Item Key already added)
FIX: All Drivers - More than 900 columns throws error - too many SQL variables
FIX: All Drivers - Preview Tab shows duplicate entries in Table dropdown if you click Dropdown multiple times too quick
FIX: All Drivers - View Metadata shows wrong code for API Connector XML option (Rather than DataType=xx , it shows Type=xx)
FIX: API Driver - Always Treat Blank Number, Date, Bool as Null is not working
FIX: API Driver - Delete / Update clause does not set Table Parameters from WITH clause
FIX: API Driver - Limit rows coming back from WHERE clause in Update / Delete in Preview (Honor Max Rows setting)
FIX: JDBC Bridge Driver - Cache Settings not saved
FIX: JDBC Bridge Driver - Stored Proc doesnt return output
FIX: JSON / XML / CSV Driver - Direct String option not saved and only works if you use WITH (DATA=xxxx) in SQL, UI option ignored
FIX: JSON / XML / CSV Drivers - Value for Direct Data and Keep Date As String Option not saved
FIX: JSON, XML , CSV Driver - Placeholder function doesnt work in URL / Body / Headers (When entered on UI) - Works ok if you override in WITH Clause SRC
FIX: JSON, XML Driver - Curly bracket in comment section cause error when URL JOIN (e.g. JOIN_1 in WITH ) feature is used - Error - Input string was not in a correct format

Version 1.7.0.10327 [Apr 15, 2023]

New Features/Improvements

NEW: API Driver - Outlook Mail (Office 365) - New connector to read / download mail and attachments from Office 365 Mail account
NEW: API Driver - Shopify - New Connector to Read / Write Shopify data (e.g. Customers, Products, Orders)
NEW: API Connector - Google BigQuery - Add Job Location Option for get_query and connection Level
NEW: API Connector Framework - Add Option TreatBodyAsDirectValue (Body parsed as input data rather than calling URL)
NEW: API Connector Framework - Allow to Read data From Local File - (Set <EndPoint Url="c:\data\file.json" or ".xml" or ".csv")
NEW: API Connector Framework - Generic Request - Make Content-Type and Request Method visible by default
NEW: General - Add API Connector format in View Metadata dialog box
NEW: JDBC Bridge Driver - Check Java found - If missing then Download JRE in single click
NEW: JDBC Bridge Driver - Replace Named Pipes to Socket to avoid orphan process / hang / access denied / timeout issues
NEW: JSON / CSV / XML Driver - Add an option to support high precision / scale decimal numbers (more than 15 digits numbers)
NEW: JSON, CSV, XML Driver - Add Support for high precision decimal numbers (New Option under Date/Number Handling)

Bug fixes

FIX: API Connector Framework - When Direct Placeholder Function used along with [$SomeParam$] in ValueTemplate of InputColumn then it doesnt evaluate for each row (Using Cached Value rather than Row By Row) - Example [$p1]<<{$value$},FUN_BASE64ENC>>
FIX: API Connector Framework - When Key column not declared in InputColumns - Delete / Update might fail - error near "from" ()
FIX: API Connector Framework - When nested column under Unbound node found in LayoutMap not supplied you may see bad JSON created
FIX: API Connector Framework - Zendesk - When you dont supply requestor / comment your create Ticket call might fail
FIX: API Driver - When WHERE clause not supplied DELETE / UPDATE doesnt do anything
FIX: Data Gateway - CAL is taken by unwanted callers even they are not logged in
FIX: Data Gateway - Existing connections created before v1.6.0 corrupted (Before Aug 10, 2022)
FIX: Data Gateway - IP Filter Rules not working for multiple conditions
FIX: General - Click on Activate License throws misleading error if activation fails - It says could not load file or assembly Rebex.Http
FIX: General - Preview window Trims error message to 1024 characters
FIX: JSON Driver, XML Driver - When nested filter used (e.g. $.customers[*].orders ) along with IncludeParentColumns option not working sometimes (Throws error or shows wrong value for parent column)

Version 1.6.3.10117 [Jan 17, 2023]

New Features/Improvements

NEW: All Drivers - Add support for Turkey (tr-TR) and Azerbaijani (az-Cyrl) environment
NEW: JDBC Bridge Driver - Change Driver name from "Jdbc Bridge" to "JDBC Bridge"

Bug fixes

FIX: All Drivers - Load Connection Settings can only accept string upto 32KB - Longer settings cannot be loaded (Truncated)
FIX: All Drivers - Load Settings might throw error if new line found - Error-Invalid ConnectionString format. Name value pair is missing for [ newline ]
FIX: All Drivers - Logging feature is not working as expected sometime (Some Log entries not found in File)
FIX: API Driver - BigQuery - Data Fetch Request Fired two times
FIX: API Driver - Query Builder generated SQL for Generic_Request endpoint does not work correctly when you pass Body / Headers (renaming RequestData, RequestMethod works)
FIX: API Driver, Excel Driver - LogPath, LoggingLevel is not applied correctly via Odbc ConnectionString
FIX: JDBC Bridge Driver - Copy ConnectionString (without Password) option copies password
FIX: JDBC Bridge Driver - For some JDBC Views not reported in the Dropdown (Preview Tab) - Problem in Infor JDBC
FIX: JDBC Bridge Driver - In some apps (like VS Solution Explorer) - Tables / Views / Procs not reported
FIX: JDBC Bridge Driver - java.exe process is not released from memory in some cases (e.g. Power BI Desktop)
FIX: JDBC Bridge Driver - Object reference not set error in log when JDBC driver throws error
FIX: JDBC Bridge Driver, API Driver - Wrong Catalog name is used
FIX: Salesforce Driver - When you call INSERT with EnableBulkMode you may get error - Could not load file or assembly ZappySys.Json
FIX: SFTP / Azure Blob Drivers (for CSV / JSON / XML) - You may get error - Could not load file or assembly ZappySys.Json on UI load or execution
FIX: SFTP CSV / XML / JSON Driver - Detailed Log is not produced

Version 1.6.2.11031 [Nov 01, 2022]

New Features/Improvements

NEW: API Driver - Allow placeholders in ValueTemplate property for Columns with Dynamic Expand option set to true
NEW: API Driver - Use example values from Input Columns to generate CRUD statements if Connector file supports it
NEW: API Driver - Zendesk - Show all custom fields when you query Tickets (Previous approach was limited to 5 fields only)
NEW: API Driver - Zendesk - Update Read Tickets (Incremental) endpoint to support functions in Start Time Parameter. Now you can use date time function (i.e. yesterday, monthstart etc) along with static date (i.e. 2021-01-01 or 2021-01-01 23:59:59) to set
NEW: Salesforce Driver - Provide an option to supply API Version for Bulk / SOAP API (Right now BULK API version is hardcoded and no way to change, SOAP also same way but work around is there to change Service Type=Other)
NEW: Salesforce Driver - Update API Version to 55.0 for SOAP and Bulk API to take advantage of new features

Bug fixes

FIX: API Driver - Some properties like Functions, ValueTemplate, Order, Label etc doesnt work in Param Template
FIX: API Driver - Stripe - Update endpoints to for date time as input / output rather than Unix timestamp

Version 1.6.1.11017 [Oct 18, 2022]

New Features/Improvements

NEW: API Driver - Youtube - New connector to read, search Videos / Playlists and other information (like, view, share, title, watch time etc)
NEW: API Driver - Stripe - New connector to read / write Customers, Orders, Invoices, Products, Subscriptions and more
NEW: API Driver - Zoom - New connector to read Meetings, Webinars, Attendees and other information from Zoom Service
NEW: API Driver - Amazon Ads - New connector to read reports for Amazon Ads Account
NEW: API Driver - ManageEngine ServiceDesk Plus- New Connector to read data from Requests, Tasks, Notes, Worklog and more
NEW: API Driver - HubSpot - Add support for PrivateApp Authentication (Using Static Access Token)
NEW: API Driver - SharePoint - Added support for Managed Metadata fields (Show Label, WssId and TermGuid)
NEW: General - Show user friendly license error when either valid license not found or its expired

Bug fixes

FIX: All API Drivers - Duplicate Custom Objects entries listed sometimes on Preview Table for Table dropdown
FIX: All API Drivers - WaitTimeMs conflicts with other property, RetryMode appears twice
FIX: All Drivers - After you preview 100 queries you start getting error - capacity was less than the current size
FIX: All Drivers - Generated query should quote around name if it contains @ char
FIX: All Drivers - Saving Metadata option not working
FIX: All Drivers - When you use parenthesis or some other invalid chars in DSN names it throws error
FIX: API Driver - OAuth Generate Token button remains disabled in some cases also not showing count down
FIX: General - WHERE clause not invoked when called from SELECT * INTO
FIX: JDBC Bridge Driver - BigInteger error
FIX: JDBC Bridge Driver - If you choose object with space in the name from non default schema - you might get error - Incorrect syntax near
FIX: JDBC Bridge Driver - Metadata for string columns not reported correctly (Length always zero)
FIX: JDBC Bridge Driver - Numeric values might fails to import in apps like SSIS
FIX: JDBC Bridge Driver - Some datatypes not handled correct way (e.g. variant in MSSQL)
FIX: ODBC SFTP JSON / XML / CSV Driver - You may get Object must be the same type as the enum error when you click on preview tab (It only happens if DSN not saved)

Version 1.6.0.10801 [Aug 10, 2022]

New Features/Improvements

NEW: All API Drivers - Add support for OAuth 1.0 with SHA256 (Usecase like NetSuite API)
NEW: All API Drivers - Add Support for Tls 1.3
NEW: All API Drivers - Allow Regular Expression Extract for Paginate using [Response Header Contains Continuation Toke] Mode (e.g. nextHeader=someResponseHeader(your-regular-expression) )
NEW: All API Drivers - Allow to use different header name for next request for Paginate using [Response Header Contains Continuation Toke] Mode (e.g. header::nextHeader=someResponseHeader )
NEW: All API Drivers - Generate Meta data in compact mode by default, also give option to generate legacy Json based format
NEW: All API Drivers - List custom PROC in Preview Dropdown
NEW: All API Drivers - Paginate using Pass Response Header to Next URL Mode throws error - Specified value has invalid HTTP Header characters
NEW: All API Drivers - Provide right click menu - for Create new Table (SQL Mode) or new table (ConnectionString Mode) - Faster (for New Virtual Table)
NEW: All API Drivers - When you add custom object (Table Type) user doesnt have option to choose Mode (i.e. SQL or Connection)
NEW: All SFTP Drivers - Add support for Ed25519 (EdDSA on edwards25519 curve)
NEW: API Driver - Add support for Zip format
NEW: API Driver - Show Virtual Tables on Preview Dropdown
NEW: Data Gateway - Add new Connector for Excel
NEW: Excel Driver - New ODBC Driver to read / write Excel
NEW: General - Remember last N query for specific Data Source
NEW: JDBC Bridge Driver - Clicking view Meta data throws error in some case - Requested value 'Int16' was not found.
NEW: JDBC Bridge Driver - Some cases you might get Key not found error
NEW: JSON, XML, CSV , Azure , Amazon , SFTP Drivers - Recursive Scan option doesnt work
NEW: OAuth Connection Manager, Google Data Connection Manager (Google Analytics) - Use Loopback Redirect URL for Custom App to comply with new Google Changes (Disallow - Redirect to urn:ietf:wg:oauth:2.0:oob for apps created after Feb 2022)

Bug fixes

FIX: All API Driver - Custom Object Save saves bad syntax without warning
FIX: All API Drivers - Add support for 3 parts in SELECT Column names to support apps like MSAccess which can issue query like this (i.e. select DATA.Customers.CustomerID from DATA.Customers )
FIX: All API Drivers - Add support for 3 parts in SELECT Column names to support apps like MSAccess which can issue query like this (i.e. select DATA.Customers.CustomerID from DATA.Customers )
FIX: All API Drivers - Compact Mode Metadata might cause odd error about invalid syntax - SQL logic error or missing database
FIX: All API Drivers - ContineOnErrorForStatusCode doesnt work (Due to MatchForEqual is always Set as False rather than True)
FIX: All API Drivers - More than 16 arguments in function or VALUES clause throws error
FIX: All API Drivers - OAuth Option [Do Not Send Credentials in Body] doesnt work (It sends secret in Body regardless)
FIX: All API Drivers - Preview doesnt generate columns for Virtual Tables if it has columns with space inside it
FIX: All API Drivers - Preview for Custom Object hangs
FIX: All API Drivers - Warn user if trying to load wrong driver connection string
FIX: All API Drivers - You may get object reference not set error on Connection Configure link click
FIX: API Driver - Changing Refresh token path not detected once you wipe out file path
FIX: API Driver - Column listing fails for some tables (specially table name contains space or special character like $ or dash, do)
FIX: API Driver - Comment WHERE Key=somevalue part in generated SQL when WITH clause is included to avoid bad SQL
FIX: API Driver - Get Tables Operation fails for some apps (i.e. Sage)
FIX: API Driver - Query Builder does not recognize column mapping to Param and shows same in WHERE clause (needs to comment WHERE clause)
FIX: API Driver - Query Builder doesnt produce correct query for SELECT (Column list + WHERE clause issue)
FIX: API Driver - When you choose Table from Preview Dropdown it may not show Builder UI to choose required parameters
FIX: Data Gateway - Save Operation throws error - NullReference when Service not found
FIX: Data Gateway - Some users might get error on connection - The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel
FIX: General - Log doesnt include timestamp
FIX: General - Show errors in red on Custom Object UI
FIX: JDBC Bridge Driver - Support some advanced datatypes
FIX: JDBC Bridge Driver - Table mode fails from some tool (like Power BI - Table mode) - Throws Invalid object (when object is stored in non default schema)
FIX: JDBC Bridge Driver - When object name contains space - Table mode fails from some tool (like Power BI)
FIX: JDBC Bridge Driver - When object name contains system reserved word (i.e. dbo.Case )- Table mode fails from some tools like Power BI
FIX: JSON Driver - Virtual Table query fails to get metadata - Hangs on Fetching metadata step
FIX: Salesforce Driver - In some cases syntax of External Query might be cause object reference not set error

Version 1.5.1.10301 [Mar 10, 2022]

New Features/Improvements

NEW: JDBC Bridge Driver - Prefix schema name to table when you select it from table dropdown and default query is generated (by default schema is not prefixed)

Bug fixes

FIX: All API Drivers - Add support for Page End Indicator / Value for other pagination modes (currently it shows only for Pagination By Response Attribute Mode)
FIX: All API Drivers - Some Pagination notes are trimmed and no way to scroll view to see details
FIX: All API Drivers - When Meta is used exceptions are not thrown
FIX: All Drivers - Table name is not refreshed
FIX: All Drivers - You might get error Object reference not set - when you change focus while you are on Preview Tab and Table list dropdown is open
FIX: JDBC Bridge Driver - Column name with special characters (dash, space, dot, $) not quoted
FIX: JDBC Bridge Driver - For some numeric types you might get error - Row read error: JBR error: java.lang.Exception: Unsupported numeric type
FIX: JDBC Bridge Driver - Treat unsupported types as string rather than throw error
FIX: JDBC Bridge Driver - You may receive error - JBR error: java.lang.IndexOutOfBoundsException: Index: 1, Size: 0
FIX: Salesforce Driver - After you make changes on UI changes not applied so Test Connection, Table Dropdown may not use latest connection settings causing error / misleading information
FIX: Salesforce Driver - Execution error: INVALID_LOGIN: Invalid username, password, security token; or user locked out. >> Reason: Password or SecurityToken was empty. ErrorCode: ERR_EMPTY_CREDS

Version 1.5.0.10201 [Feb 02, 2022]

New Features/Improvements

NEW: All API Drivers - Allow to use Custom SQL for Virtual Table
NEW: All API drivers - META with extended query syntax cause invalid syntax error
NEW: All Drivers - Add option to export preview result to CSV / TSV file or copy to clipboard
NEW: All Drivers - Allow to cancel query execution on the preview tab
NEW: All Drivers - Show Preview errors in non-blocking text area rather than Blocking Popup
NEW: API Connector Framework - Allow to map __RAWDOC__
NEW: API Driver - Enhance Query Builder to add column list / key in WHERE for SELECT, UPDATE , INSERT, DELETE
NEW: API Driver - Some changes on UI not saved in active connection causing failure on Preview / Test Connection
NEW: API Driver - Support WHERE Clause in DELETE / UPDATE Operations
NEW: API Driver - Support WHERE Clause in SELECT
NEW: API Driver - Support WHERE clause server side execution for UPDATE / DELETE / SELECT if API can handle it
NEW: API Driver, Salesforce Driver - SOURCE clause should invoke on the same connection if Driver Type and ConnectionString parameters are not supplied
NEW: CSV Driver - Provide an option to output blank value as null
NEW: Data Gateway - Log Additional System Info
NEW: Data Gateway - Show warning about service restart required in order to apply changes
NEW: Data Gateway - Update SSL support to accept Tls1.1 and Tls1.2
NEW: General - Place holder function FUN_IF_NULL ( Syntax: input_value { |~| template_for_null_input } { |~| template_for_non_null_input } {|~| value_encoding_style } ) , Example: <<some input |~| Input is null |~| Input is $1 |~| jsonenc , FUN_IF_NULL>>
NEW: General - Provide F5 shortcut for Preview Data button
NEW: General - Provide max Log File Size option
NEW: JDBC Bridge Driver - Add path browse option for jar file
NEW: Jdbc Bridge Driver - Add Support for DateTimeOffset Type
NEW: Jdbc Bridge Driver - Return BIGINT type as Int64 rather than decimal
NEW: JSON Driver, XML Driver - Add Support regular expression in Filter (i.e. select * From $ WITH (Filter='$.[?(@.Company =~ /^Micro(.*)$/)]' ) )
NEW: JSON Driver, XML Driver - JSONPath Filter support for root objects (e.g. $..[?(@country=='USA')] )
NEW: JSON, XML, CSV Driver - Add Option to parse output from command line Standard Output Stream (e.g. select * from $ WITH(Data='cmd:>curl -k http://httpbin.org/get') )
NEW: Salesforce Driver - Add support for OAuth Tokens security rather than Password (useful for 2FA / MFA handling)

Bug fixes

FIX: All Drivers - Add Support for ODBC Command Timeout
FIX: API Driver - Add Support for RefreshTokenFilePath (Changing Token Pattern)
FIX: API Driver - GUID type might cause error - Unknown SQL Type - 0
FIX: API Driver - Hide any Endpoint which needs {$row$} input at runtime
FIX: API Driver - LIMIT Clause is not honored when you execute query outside Preview Tab (i.e. Call from ODBC Apps)
FIX: API Driver - UPDATE / DELETE may throw error when you have space in object name and WHERE clause is used
FIX: Data Gateway - Code generator uses SQLNCLI rather than SQLNCLI11 for SQL Server Linked Server creation code - This cause issue with some query because wrong driver is being used
FIX: Data Gateway - Default Script cause issue for EXEC AT with INSERT - Error in TDS Stream - The operation could not be performed because OLE DB provider "SQLNCLI11" / "MSOLEDBSQL" for linked server "ls_Json" was unable to begin a distributed transaction
FIX: Data Gateway - In some cases long running HTTP requests might hang connection (This usually happens when HTTP exception happens after Caller Timeout or CommandTimeout set too low or exception happens after CommandTimeout)
FIX: Data Gateway - New version throws error about SSL/TLS negotiation in some cases
FIX: Data Gateway - Query hangs on certain exceptions and might crash gateway
FIX: Data Gateway - When you click Restart button on gateway UI - You may receive Time out has expired and the operation has not been completed
FIX: Data Gateway - When you open UI it may open multiple instances
FIX: Data Gateway - You might get random license error when too many connections made same time
FIX: General - Brackets around column name in UPDATE does not work or throw error (i.e. UPDATE tbl SET [my column] = 1 )
FIX: General - Preview Grid might throw error when you sort column by clicking on header - Error - Object must be of type string
FIX: INTERNAL- Log Mode Dropdown on Gateway shows blank
FIX: JDBC Bridge Driver - Add Support for TIMESTAMP_WITH_TIMEZONE JDBC Type
FIX: JDBC Bridge Driver - Do not invoke SQL Parser (because syntax like CTE or CAST (c as varchar) fails )
FIX: JDBC Bridge Driver - Exception in thread "main" java.lang.NoClassDefFoundError:
FIX: JDBC Bridge Driver - Set working directory same as JDBC Driver (This helps scenario like Infor-ION driver JDBC Driver)
FIX: JDBC Bridge Driver - Show meaningful error rather than Pipe is broken (Capture unhandled exception right way)
FIX: JDBC Bridge Driver - When Pipe is broken error occurs certain Client Apps connecting to Gateway might hang
FIX: Jdbc Bridge Driver - You might get misleading message if JRE missing - Failed to launch interop server host process

Version 1.4.2.11005 [Oct 06, 2021]

New Features/Improvements

NEW: All API Drivers - 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)
NEW: All API Drivers - Provide a setting to apply META in merge mode in simple, extended, URL join queries
NEW: All API Drivers - Provide an example of merge mode ( OverrideMode )
NEW: All Drivers - Mask Connectionstring by default in Import Settings dialogbox by default (and give option to unmask)
NEW: All Drivers - More than 655 columns throws error about FillWeight
NEW: API Driver - Add Support for META clause
NEW: API Driver - Reset Table dropdown only when you leave Tab not clicking any where outside tab (e.g. Generate SQL Button)
NEW: Data Gateway - Add support for SSL / TLS Encryption for Secure TDS Protocol
NEW: Data Gateway - Provide IP / Range Block / Allow Feature (with Last Successful / Failed Login Attempt Indication)
NEW: Data Gateway - Support Dynamic SQL using Exec AT with parameters
NEW: General - Add Online page for SQL UDF
NEW: Installer - Rename License Manager to ODBC License Manager
NEW: Salesforce Driver - Multi statement support

Bug fixes

FIX: All API Driver - Quote symbol issue in SQL generation
FIX: All API Drivers - ConvertFormat has no effect if you set via UI
FIX: All API Drivers - Enable Custom Replace is not working when you set options from UI (however setting options in WITH clause works fine)
FIX: All API Drivers - Extra unwanted columns produced in some extended queries when * is used (provide * + const\expr columns support)
FIX: All API Drivers - Function names with builtin operator cause issue
FIX: All API Drivers - Headers grid is not reset after loading new Connection String
FIX: All API Drivers - Looks like if you use more than 8 parameters then you get error
FIX: All API Drivers - Pagination from Custom Header throwing error if you use EnablePageTokenForBody (i.e. use of [$pagetoken$] in body)
FIX: All API Drivers - Placeholder functions not working in URL (fails only if column type is numeric)
FIX: All API Drivers - Quote Symbol issue in ConnectionString generation
FIX: All API Drivers - When Connection String contains RequestData='[$tag$]' it removes brackets when you load connection string
FIX: All API Drivers - When same attribute name supplied multiple times in WITH clause, you might get misleading error
FIX: API Driver - Changing settings on UI (e.g. Connector File) doesnt reload Table dropdown on Preview Tab
FIX: API Driver - do not detect string as Int32 / Int64 (i.e. { id: "123" } JSON should be treated as string if in double quotes)
FIX: API Driver - Floating numbers are failed to parse for non English environment (i.e. Finland) - e.g. Number "1.267662916E9" failed with error Cannot convert [1.267662916E9] to [Double]
FIX: API Driver - New values not updated - Table dropdown reset based on old connection
FIX: API Driver - Show user friendly message when value is too large o fit - e.g. Int32 field may throw - Value was either too large or too small for an Int32.
FIX: CSV Driver - User may get unclear error if different value type detected after 300 rows - Input String is not in correct format error
FIX: Data Gateway - Many parallel connection can cause License not found error
FIX: Data Gateway - Multiple connections from the local device sometimes throws CAL error (if 127.0.0.1 is reported as local IP along with 192.xxx)
FIX: Data Gateway - When column name is great than 128 chars you may see odd error - Deferred prepare could not be completed
FIX: General - Function search by name not working in example browser
FIX: General - Undo is not possible after using query from Query Builder in Preview
FIX: JDBC Bridge Driver - NULL schema name cause issue with Power BI
FIX: JDBC Bridge Driver - On some queries you get error - Pipe is broken
FIX: JDBC Bridge Driver - You may get error "Host Process Broken" if data contains certain datatype
FIX: JSON Driver - Regex is truncated when loading the connection
FIX: Salesforce Driver - Query with SOURCE and WITH using wrong order throws object reference not set error rather than Grammer error
FIX: XML Driver - Error in OpenQuery when Nested query is used with BASE64 decode function

Version 1.4.1.10520 [May 21, 2021]

New Features/Improvements

NEW: Salesforce Driver - Enable Parallel Processing by default (Adjust MaxParallelThreads = 6)
NEW: Salesforce Driver - Update examples to include Bulk API, Parallel Processing and more

Bug fixes

FIX: All API Drivers - OAuth for Google Provider throws error about Certificate Path

Version 1.4.0.10518 [May 19, 2021]

New Features/Improvements

NEW: API Driver - Easy to use Driver to Read / Write data from Popular Online Data Sources - Inbuilt support for Google Sheets, BigQuery, JIRA, SharePoint Online, Amazon MWS, Zoho, Zendesk, OData - Download more connector files from online library
NEW: All API Drivers - Add better validation message when URL JOIN doesnt have alias defined
NEW: All API Drivers - Add new option MetaScanMode to define how metadata should be detected (i.e. Guess1x, Guess10x, Max String, Blob String and few more Mode)
NEW: All API Drivers - Add Support for create / edit Virtual Table with UI (Similar to Query Builder to construct custom settings)
NEW: All API Drivers - Add support for META clause in URL JOIN
NEW: All API Drivers - Allow [$body$] placeholder in String to Sign in HMAC / HASH Authentication Type to allow HASH function like SHA256(body+timestamp+secret)
NEW: All API Drivers - Allow custom replace before document is parsed (useful to remove / replace some characters in source data)
NEW: All API Drivers - Allow to export full setting of DSN (including Virtual Table / Metadata / Stored Procs)
NEW: All API Drivers - Give an option (EnableMultiPathMode) to treat SRC attribute as List of URLs / File Paths (separated by :: or {newline} ) - This allows UNION style feature to aggregate results from multiple URLs which has mostly similar structure
NEW: All API Drivers - Google Service Account support (Use of Private Key - P12 Files)
NEW: All API Drivers - Implement simpler META syntax - e.g. col1=string(10); col2=int,col3=numeric(18, 5)
NEW: All API Drivers - In URL Join allow to pass Parent Column Value in Header (i.e. join1_Header='x-hdr1: [$a.some_parent_col$]'
NEW: All API Drivers - Meta data UI improvements
NEW: All API Drivers - Retry 301 redirect Unauthorized requests for same domain and if new url is secure (i.e. https://)
NEW: All API Drivers - Significant Performance improvement for advanced queries (i.e. using WHERE, GROUP BY, ORDER BY) which returns more than 100000 rows
NEW: All API Drivers - Use Guess4x mode for Metadata scan rather than Guess1x
NEW: All Drivers - Do not convert Long to String (This was done to support legacy apps like old excel but no more issue in latest excel)
NEW: Amazon S3 Drivers - Add new Properties ForcePathStyle and ServiceURL to support S3 Protocol based 3rd party API services (i.e. Mini IO, Veritas, Ceph ...)
NEW: Data Gateway - Add new data source should open Edit UI (right now you have to click Edit manually)
NEW: Data Gateway - Display Version Number on Gateway UI
NEW: Data Gateway - Provide a way to use length rather than VARCHAR(MAX) for String type
NEW: General - Add new SQL Functions FILE_READ_TEXT / FILE_READ_BINARY to read text data or binary data from disk file
NEW: General - Improve logging (in some case error message not sent back to caller and its not logged in Debug Log mode)
NEW: General - Modify installer to create license folder with correct permissions for all to prevent license related issue when running product under non-admin account
NEW: General - Redesign Examples UI - Add features like group by category, preview SQL and description, search, syntax highlighting and more
NEW: JSON, XML Driver - Add options (EnableRawOutputModeSingleRow and RawOutputDataRowTemplate) to wrap response under special template (i.e. { data: [ ] } ) - Useful for case when you have to filter root level using JSONPath (i.e. [?(@code=='1')] )
NEW: JSON, XML, CSV Driver - Add Support for Custom SSL/TLS (Allow modern encryption ciphers for Older OS such as Windows Server 2012R2)
NEW: Salesforce Driver - Add Support for Bulk API
NEW: Salesforce Driver - Add Support for Bulk input from File (Insert, Delete, Update, Upsert values from File rather than static values)
NEW: Salesforce Driver - Add support for Bulk Update / Delete / Insert using ConnectionString (ODBC, SQL, OLEDB)
NEW: Salesforce Driver - Add Support for ContinueOnError in Insert / Update / Delete / Upsert for BULK
NEW: Salesforce Driver - Add support for EnableBulkMode, EnableParallelThreads, MaxParallelThreads in WITH clause
NEW: Salesforce Driver - Add Support for HTTP Proxy (Web Proxy using URL)
NEW: Salesforce Driver, API Driver - Change behavior so Output = 1 (ON) by default for CRUD Operations (INSERT, UPDATE, DELETE)

Bug fixes

FIX: All API Driver - Virtual Table changes are not saved and Prompt should say "Do you like to save changes?" rather "would you like to discard changes?"
FIX: All API Drivers - CertificatePassword is not treated as secret when generating SQL
FIX: All API Drivers - Create Custom Proc writes duplicate "CREATE PROCEDURE [XXXXXXX] AS" in default code
FIX: All API Drivers - Deleing unsaved Virtual Table or Stored Proc throws object reference not set error
FIX: All API Drivers - Deleting unsaved Stored Proc calls Compile operation
FIX: All API Drivers - Extended mode queries (with WHERE / GROUP BY) might show Quoted Columns
FIX: All API Drivers - Extended mode SQL issue when you specify column which doesnt exists
FIX: All API Drivers - Extended query throws error if you use expression and you have META clause defined - You may see error like expr_1 not found
FIX: All API Drivers - For extended queries or META clause use you may get error on some culture (i.e. Finland) - Parser error: String was not recognized as a valid DateTime.
FIX: All API Drivers - Length from META clause is ignored for extended SQL queries
FIX: All API Drivers - Length reported incorrectly by .net GetSchemaTable function
FIX: All API Drivers - Loading Full Setting throws error for New Data source
FIX: All API Drivers - Loading Full Setting with Custom Objects on new data source does not refresh UI
FIX: All API Drivers - Metadata detection reports exact length for string when only one sample row found (It should detect 4 times bigger for string types to cover data coming after 300 rows)
FIX: All API Drivers - Metadata operation fails if column / expression contains Byte array
FIX: All API Drivers - Pagination Tab trimmed some label text
FIX: All API Drivers - Provide a better error message when extra columns detected in SELECT which is not found in META list
FIX: All API Drivers - Save Stored Proc Removes placeholders from Proc Body on refresh
FIX: All API Drivers - Some SQL UDF (User defined function) doesnt return null if one or more input arguments are null
FIX: All API Drivers - Stored Procs with Parameters used inside Placeholder function not replaced correctly (It should replace Inner Parameter first and then call replace Placeholder but its doing other way around)
FIX: All API Drivers - Unable to cast object of type 'System.String' to type 'System.Byte[]'
FIX: All API Drivers - URL JOIN allow child with zero rows (after META clause defined)
FIX: All API Drivers - URL JOIN doesnt throw error if SELECT clause reference column which is not found in META
FIX: All API Drivers - URL JOIN doesnt understand metadata from file path (Embedded meta works fine)
FIX: All API Drivers - When CachingMode=All is set and you try to preview query on UI you may get - Object reference not set error on 2nd execution
FIX: All API Drivers - When you use Cache feature with CacheMode=CacheAll setting then it hangs on extended queries
FIX: All CSV Drivers - Custom date format option is not working
FIX: All Drivers - App - SSIS: In 2019 you might get error at runtime - Add support for SQLFetchScroll Feature
FIX: All Drivers - String more than 2000 characters are corrupted (Data fetch via Data Gateway works fine)
FIX: All JSON, XML Drivers - If you upload Body from File then Select Filter Option throws error (Because file content not posted as body)
FIX: App - Informatica Developer (JAVA Based IDE with Model Repository) detects integer column with Precision 1 which causes validation errors
FIX: CSV Driver, API Driver - When first row is blank and next row has number it detects datatype as String rather than number
FIX: Data Gateway - Clicking Cancel on UI warns about unsaved data
FIX: Data Gateway - Configuration not reloaded (renamed data set keep old entry)
FIX: Data Gateway - Jdbc Bridge driver crash to load when you edit Data Source on Gateway UI
FIX: Data Gateway - Process gets terminated on unhandled error in driver
FIX: Data Gateway - Restart option causes Timeout error some times (Start / Stop works fine)
FIX: Data Gateway - SELECT INTO with META clause cause Object reference not set error
FIX: Data Gateway - Service crash on certain unhandled exception and no error is logged
FIX: Data Gateway - Service might crash if parallel commands detected (e.g. TOP clause used with OPENQUERY)
FIX: General - After selecting example you cannot do Undo (Ctrl + Z)
FIX: General - Allow to set 0 / 1 for Bool type Parameters (Right now it must be set with True / False keyword)
FIX: General - Fix C# Example on code generator Tab
FIX: General - Scaling Issue with UI with HTTP Request (Edit Body button hidden)
FIX: JDBC Bridge Driver - Apps - Power BI - Data import in Table mode fails due to Quoted identifiers issue when Column name contains space or special character (i.e. dash or dot)
FIX: JDBC Bridge Driver - Executing DDL / DML Statements (i.e. CREATE, DROP, INSERT, UPDATE) fails with error - No results were returned
FIX: JDBC Bridge Driver - Tables are reported as Views
FIX: JSON Driver - After changing value in Advanced Grid when you edit connection you might get error
FIX: JSON Driver - Cache causing Issues with Nested SQL Scenarios
FIX: JSON Driver - Long Integers are not Returning Correctly with URL JOIN Queries
FIX: JSON, CSV, XML Driver - Custom Stored proc fails when SELECT INTO temp table used along with URL JOIN feature
FIX: Salesforce Driver - App - Power BI fails to import data in Table mode
FIX: Salesforce Driver - App - SSIS - Throws metadata validation error at runtime (Due to Quoted SQL sent by SSIS engine - SQL_IDENTIFIER_QUOTE_CHAR setting of ODBC Driver is ignored in SSIS)
FIX: Salesforce Driver - Bad requests not failing (i.e. INSERT duplicate row is not failing)
FIX: Salesforce Driver - Connections are opened multiple times and not reused
FIX: Salesforce Driver - Error is not reported correctly by driver in some cases
FIX: Salesforce Driver - Preview window might crash without error in some cases (e.g. Bad Table name in INSERT / UPDATE / DELETE )
FIX: Salesforce Driver - Set String length to Max length if Length=0
FIX: Salesforce Driver - Table list not populated
FIX: Salesforce Driver - UPDATE doesnt set column to NULL if you use SET Column=null (Instead of NULL it set to string "null" )
FIX: Salesforce Driver - You might get error when you read Binary date (i.e. Body field in Attachment table) - Error : Requested value 'Byte[]' was not found.
FIX: XML Driver - 0000 string truncated to 0
FIX: XML Driver - If response is blank - You might get error - Root element is missing even though you set META
FIX: XML/JSON/CSV Driver - Page Start Number doesn't accept 0 and gets reset to 1

Version 1.3.0.10909 [Sep 16, 2020]

New Features/Improvements

NEW: JDBC Bridge Driver - New driver allows to read data using any JDBC driver in ODBC Apps or SQL Server via Gateway
NEW: All API Drivers - Add Advanced Pagination Options on UI
NEW: All API Drivers - Add optional Parameter (3rd Argument) in json_value function to Throw Error when no match found for supplied JSON Path Expression
NEW: All API Drivers - Add support for EnableBodyCompression
NEW: All API Drivers - Allow File Upload Request in AWS API Provider (IsMultiPart=True)
NEW: All API Drivers - Allow to use Placeholder functions in URL JOIN (e.g. [$alias.somecolumn,FUN_TRIM$] )
NEW: All API Drivers - HTTP Connection - For Dynamic Token option when Auth Scheme contains space do not suffix another space (e.g. MyAuthScheme sess-id=)
NEW: General - Add support to check for Product Update
NEW: General - Some unhandled exceptions on UI not caught
NEW: General - Enforce License manager to run as Admin to avoid license activation issues
NEW: General - Add new functions LOWER, UPPER, FUN_UNIX_TIMESTAMP_TO_DATE (When input is Seconds format) and FUN_UNIX_TIMESTAMP_MS_TO_DATE (When input is Milliseconds format)
NEW: All API Drivers - HTTP Connection - Allow option to set DynamicToken request as Form-Data (Multi-Part) request
NEW: XML Driver - Add Culture Option - Support for parsing Culture Specific Numbers (e.g. in Finland - 1000,50 should be treated as decimal)
NEW: All API Drivers - Allow to pass non standard date format for If-Modified-Since Header (Xero API Usecase) - suffix date value with -raw to allow custom format (i.e. If-Modified-Since : 2020-12-31-raw)
NEW: All API Drivers - OAuth Connection - AWS v4 Provider - Allow to Supply Custom Region

Bug fixes

FIX: All API Drivers - Various drivers using ISO date formats may use wrong date format for some cultures where Time Separator is dot (i.e. Finland Culture fi-FI)
FIX: All API Drivers - Add support for functions in ORDER BY Clause
FIX: All API Drivers - Always first parameter value is used in custom stored proc
FIX: All API Drivers - Column DataType is detected as String When first value in first row is NULL
FIX: All API Drivers - DROP PROCEDURE statement doesn't remove Stored Proc from Storage
FIX: All API Drivers - For certain Regional Settings (e.g. Finland) you might get error - Parser error: String was not recognized as a valid DateTime
FIX: All API Drivers - IncludeParentColumns , TreatBlankXXXXAsNull Options not saved when you close UI
FIX: All API Drivers - Milliseconds part is removed from extended query output
FIX: All API Drivers - On Preview Tab - You may get error when you click on Table dropdown - Value cannot be null - Parameter name: first
FIX: All API Drivers - Prompt for unsaved changes on Custom Objects UI
FIX: All API Drivers - SupportCompression setting not saved
FIX: All API Drivers - User running fragments of SQL assuming it runs full SQL and got error expected : EXEC, DROP, CREATE, SELECT, INSERT, UPSERT, UPDATE, DELETE, ;
FIX: All API Drivers - When input is NULL for Regex_Search then it should return NULL rather than Blank String
FIX: All CSV Drivers - Column Delimiter is not Saved if you enter custom value (other than found in dropdown)
FIX: All Drivers - OdbcConnection GetTables method doesnt work
FIX: All Drivers - When you use custom Meta String Type column it may return numeric data in Culture Specific Format rather than Invariant format (e.g. for Finland Region it may return 1234,50 rather than 1234.50)
FIX: CSV, XML Driver - In some cultures (e.g. Finland) Decimal type is detected as String
FIX: Data Gateway - You might get error "Protocol Error in TDS stream" with Large Files (More than 40MB)
FIX: General - SQL UDF not throwing error in some function when its desired (e.g. Invalid File Path should throw error)
FIX: JSON Driver - Order By is not working while reading local file
FIX: JSON Driver - Clicking on Table dropdown on Preview Tab might throw error - Value cannot be null. Parameter name: first
FIX: XML Driver - Parsing Decimal might throw error in Extended Queries - Input string was not in a correct format

Version 1.2.1.10511 [May 15, 2020]

New Features/Improvements

NEW: All API Drivers - Add new User Defined Functions bytes_to_base64, text_to_base64, base64_to_text and file_to_base64
NEW: All API Drivers - Add support for Virtual Table (So Apps like MS Access, Informatica can use table list from same DSN without creating new DSN for new URL EndPoint or other settings)
NEW: All JSON Drivers - Add Support for JSON Line Format (i.e. [1,"AAA"] [2,"BBB"] )

Bug fixes

FIX: All JSON Drivers - Column less array 2DArray Transform produces wrong number of columns
FIX: General - ODBC is missing SFTP CSV, Azure CSV and Salesforce Drivers from ODBC Administrator

Version 1.2.0.10428 [Apr 27, 2020]

New Features/Improvements

NEW: All API Drivers - Add Custom Stored Procedure support (With Compiled Metadata support for faster performance)
NEW: All API Drivers - Add support for count(*)
NEW: All API Drivers - Add support for multi statements
NEW: All API Drivers - Add Support for Placeholder functions in HTTP Dynamic Token Request (i.e . Headers/Body/URL)
NEW: All API Drivers - Add support for temp tables (Save result into temp table and use in different query or in JOIN Syntax)
NEW: All API Drivers - Add two default headers Accept, Cache-Control
NEW: All API Drivers - Change IncludeParentColumns default to True
NEW: All API Drivers - Give option to pass content-type for multi-part upload request (Right now its guessed from file extension) - Google Drive Upload API Usecase
NEW: All API Drivers - OAuth Connection - Detect changing refresh token pattern and prompt to define file path on generate token click
NEW: All API Drivers - OAuth Connection - Implement External Browser Token Extract (Need this feature for APIs like Google which stop supporting Embedded Browser in App)
NEW: All Drivers - Allow to use Placeholders any where in Query Text (e.g. select * from $ WITH(Src='http://httpbin.org/get?id=2020-04-27') )
NEW: All JSON Driver, All XML Driver - Support Custom column list in Complex 2D Transform
NEW: Data Gateway - Add correct message in TDS response when no license found (it sends "Client unable to establish connection due to prelogin failure".)
NEW: Data Gateway - Improve Gateway Log (Added IP, Query Time, UserID, DB Name, SessionID, CPU %, Memory and more )
NEW: Data Gateway - Provide a clear indication which IPs using Gateway connections when license error is thrown
NEW: Data Gateway - Use of invalid catalog name can throw confusing error in SQL Linked server
NEW: General - Provide confirm dialog box before overwrite DSN with same name on config save

Bug fixes

FIX: All API Driver - Extended Query report Int32 data as Int64
FIX: All API Drivers - After entering URL in the path if you browse path it will not show local files
FIX: All API Drivers - Alias doesn't work for nested sub query
FIX: All API Drivers - AWS v4 Signature Provider doesnt work when you have URL like https://something.execute-api.eu-central-1.amazonaws.com/part1/part2/somename
FIX: All API Drivers - Changing Headers in Grid mode doesnt save when you close UI
FIX: All API Drivers - Escape Sequence issue for single quote in WITH clause
FIX: All API Drivers - Invalid meta entry name cause path not found error
FIX: All API Drivers - OAuth Connection - Retry option cause issue with Amazon MWS API
FIX: All Drivers - Driver name attribute is treated as case-sensitive
FIX: Amazon S3 Drivers (CSV, XML, JSON), Azure Blob Xml Driver - You may get error for - Rebex.Zip dll is missing
FIX: Amazon S3, Azure Blob, SFTP Drivers - Source Path hint is wrong - Change http:// in path to /myfolder to avoid confusion
FIX: Apps - MS Access - Selecting Primary Key field for Linked table fails
FIX: Data Gateway - CAL Limit error from multiple connection from same IP
FIX: Data Gateway - When CacheAll is enabled you may get zero rows in some cases if META clause used
FIX: Data Gateway - When CacheAll setting is On you may get Object reference not set error
FIX: Distinct doesnt work if WHERE clause / GROUP BY / ORDER BY not used
FIX: General - Help file doesnt show all examples
FIX: General - Installer doesnt prompt UAC in some cases
FIX: Informatica - nvarchar columns are loaded with scale > 0 causing issue in informatica developer IDE
FIX: JSON Driver - You may get error - Value was either too large or too small for an Int64
FIX: JSON Driver, XML Driver - When you select sub document as filter (e.g. $docs[*].info ) rather than array node (e.g. $docs[*] ) it may output NULL values
FIX: REOPEN-Data Gateway - Error not thrown back correct way
FIX: Salesforce - WHERE clause filter on DateTime field is not supported (i..e LastModifiedDate field)
FIX: Salesforce Driver - You may get error on Bool datatype
FIX: You may get error when you use URL JOIN - Input string was not in a correct format.

Version 1.1.4.10904 [Sep 11, 2019]

New Features/Improvements

NEW: All Drivers - New DSN dialogbox should suggest unique DSN name if already exists (Prevent accidental overwrite)
NEW: All Drivers - Add support for named parameters for stored procs (e.g. exec webrequest @uri='https://abc.com' )
NEW: Data Gateway - Give Export / Import Settings option
NEW: Data Gateway - Provide list of database to caller App
NEW: General - Use default log file name if only folder name is supplied
NEW: Salesforce Driver - Add Placeholder Engine Support

Bug fixes

FIX: All API Drivers - Query builders shows Password and Default Attributes on first time launch
FIX: All API Drivers - RetryInfo not included in Connectionstring or generated SQL
FIX: All API Drivers - URL JOIN may cause error for decimal values - Query execution error: Input string was not in a correct format.
FIX: All API Drivers - URL on general tab is wiped out when you use save HTTP Connection
FIX: All API Drivers - Field names are wrong StatucFieldxxxxxxx and StatucCheckxxxxxx rather than StatusCheckxxxxxx and StatusFieldxxxxxxx
FIX: CSV Driver - JOIN query fails in CSV driver with invalid format detected
FIX: Data Gateway - MS SQL Server - Support more than 2000 characters for SQL in OPENROWSET and EXEC - In old version you may get error - Data is invalid if text is longer than 2000 characters
FIX: Data Gateway - Query with Caching Option hangs
FIX: Data Gateway - Use of META in WITH clause prevents error in some cases
FIX: Data Gateway - You may get "The data is invalid" error when the query is too long
FIX: Data Gateway - You may get Data is invalid error for OAuth Authorization failure
FIX: Salesforce Driver - When you execute INSERT via Linked Server Query it Inserts row but fails with error at the end
FIX: Salesforce Driver - Load ConnectionString action throws Object reference not set to an instance of an object.
FIX: Salesforce Driver - Click on Generate SQL throws Object reference not set to an instance of an object
FIX: Salesforce Driver - Data is not returned in Excel when you use [From Microsoft Query] option
FIX: Salesforce Driver - DELETE statement not working
FIX: Salesforce Driver - Escape sequence not supported (e.g. WHERE name ='Sam\'s' )
FIX: Salesforce Driver - OPENQUERY / EXEC AT doesn't work with DELETE / UPDATE / INSERT
FIX: Salesforce Driver - SSIS Failed to Generate Metadata due to character encoding issue
FIX: Salesforce Driver - Using * in SELECT with WHERE is not working

Version 1.1.3.10621 [Jun 24, 2019]

New Features/Improvements

NEW: Add option to replace placeholders in File content if you use IsMultiPart = True
NEW: All API Drivers - Add option EnableBodyPlaceholderForMultiPart to support replacing placeholders in file content in IsMultiPart mode (E.g. replace <%access_token%> or [$token$] or [$alias.MyJoinColumn$] )
NEW: All API Drivers - Add option OutputAsRawDocumentSingleRow (Returns __DOCUMENT__ field with entire File / Response string in one field)
NEW: All API Drivers - Add Options to parse from any unstructured data - RawOutputExtractMode, RawOutputDataRowTemplate, RawOutputFilterExpr
NEW: All API Drivers - Add Status Check feature for all API drivers (Keep sending request until desired value found) - Options added EnableStatusCheck, StatucCheckMaxWaitSeconds, StatucCheckIterationWaitSeconds, StatusSuccessValue, StatusFailureValue
NEW: All API Drivers - Add support for ConnectionType in URL Join
NEW: All API Drivers - Add Support for HMAC Authentication
NEW: All ODBC Drivers - Add support for Parameters
NEW: Data Gateway - Add Code Generator UI for SQL / Java
NEW: Data Gateway - Allow to add firewall rule via UI
NEW: Data Gateway - Better logging about connected devices
NEW: Salesforce Driver - Add support for Select * FROM

Bug fixes

FIX: All API Drivers - joinXX_DataConnectionType Option not supported in JOIN URL
FIX: All API Drivers- Show meaningful error when same option used twice in WITH clause (Right now you see odd error - An item with the same key has already been added)
FIX: Apps - Informatica - Driver may output many extra empty rows in some cases
FIX: Apps - MS Access - Linked table throwing call fail error (due to missing support for parameters in current driver)
FIX: Data Gateway - Certain errors not reported correctly back to caller
FIX: Data Gateway - Enabling caching options may hang query in some case
FIX: Data Gateway - Generic ODBC Connection Type fails with error Connection is Busy
FIX: Data Gateway - When you use Meta option in WITH clause you may see empty rowset rather error in some cases
FIX: Salesforce Driver - Can not load table list in Excel / Power BI
FIX: Salesforce Driver - Failed to preview data in Power BI
FIX: Salesforce Driver - Load ConnectionString doesnt set Username
FIX: Salesforce Driver - Nested queries not supported - You may get syntax error
FIX: Salesforce Driver - SSIS ODBC destination showing bad Table names in list

Version 1.1.0.10423 [Apr 26, 2019]

New Features/Improvements

NEW: All API drivers - Support Zip File when reading from URL (Right now only Gzip supported for URL)
NEW: Amazon S3 driver for CSV - New driver to query CSV / TSV files stored on AWS S3 Service (Zip / GZip supported)
NEW: Amazon S3 driver for JSON - New driver to query JSON files stored on AWS S3 Service (Zip / GZip supported)
NEW: Amazon S3 driver for XML - New driver to query XML files stored on AWS S3 Service (Zip / GZip supported)
NEW: Azure Blob driver for CSV - New driver to query CSV / TSV files stored on Azure Blob Storage Service (Zip / GZip supported)
NEW: Azure Blob driver for JSON - New driver to query JSON files stored on Azure Blob Storage Service (Zip / GZip supported)
NEW: Azure Blob driver for XML - New driver to query XML files stored on Azure Blob Storage Service (Zip / GZip supported)
NEW: General - Shorten default Datasource name if its more than 32 characters long
NEW: Salesforce driver - New driver to read / write data on Salesforce.com CRM (SOQL Query and Table Mode)
NEW: SFTP driver for CSV - New driver to query CSV / TSV files stored on FTP Server using SFTP, FTPS, Classic FTP Protocols (Zip / GZip Compression supported)
NEW: SFTP driver for JSON - New driver to query JSON files stored on FTP Server using SFTP, FTPS, Classic FTP Protocols (Zip / GZip Compression supported)
NEW: SFTP driver for XML - New driver to query XML files stored on FTP Server using SFTP, FTPS, Classic FTP Protocols (Zip / GZip Compression supported)

Bug fixes

FIX: All - API Drivers - Pagination doesn't work if page number starts other than 1 in URL Parameter Mode
FIX: All API Drivers - Case Statement not working
FIX: JSON Driver, XML Driver - You may get OutOfMemory Exception with --FAST option in filter

Version 1.0.18.10215 [Feb 14, 2019]

New Features/Improvements

NEW: All API Drivers - Add support for schema in the column list (SELECT Clause) - Tools like SSRS Query builder generates 3 parts column names
NEW: All API Drivers - Provide an option to retain Cookies in HTTP Connection for Dynamic Token Approach (e.g. SAP Usecase)
NEW: All API Drivers - Show NULL values in different colors in Preview Grid (Currently Blank and NULL both shows empty cell)

Bug fixes

FIX: All API Drivers - You may get error when first column in SQL is static value - Error expected: number, string, x, NULL,
FIX: All API Drivers - Long string values not displayed in preview grid
FIX: All API Drivers - Pagination may not work correctly for URL Path Mode if StartPage is other than 1
FIX: All API Drivers - Pagination with Custom Increment not working
FIX: All API Drivers - Start Page Number is not saved when you close UI
FIX: XML Driver - When you use 2D Transform - You may get Newtonsoft.Json.Linq.JObject' to type 'System.IConvertible if self closing nodes encountered

Version 1.0.17.10125 [Feb 14, 2019]

Bug fixes

FIX: All API Drivers - You may get do you want to save message on cancel when path is file
FIX: Informatica - You may see junk characters in the output when blank data is encountered

Version 1.0.16.10117 [Jan 17, 2019]

New Features/Improvements

NEW: All API Drivers - Add support for SQLExtendedFetch for some applications which support older ODBC version
NEW: All API Drivers - Logging enhancements

Bug fixes

FIX: All API Drivers - You may get error - Reading data timed out Timeout for large files or server takes longer to reply
FIX: Data Gateway - If you click OK / Cancel without save you may lose your dataset settings
FIX: Data Gateway - Is Admin checkbox is not saved on Users tab
FIX: Data Gateway - Provide a valid error message when user has insufficient privileges to access datasource

Version 1.0.15.11226 [Jan 14, 2019]

New Features/Improvements

NEW: All API Drivers - Add Sleep SQL function (e.g. select sleep(3000) wait3Sec From $ )
NEW: Apps - Talend - Data Gateway does not work with MS SQL JDBC in talend open studio
NEW: JSON, XML Driver - Move Array Flattening Feature to Advanced Filter Options to avoid confusion with filter property
NEW: JSON, XML, CSV Driver - Add Support for Multi-Part Content
NEW: JSON, XML, CSV Driver - Add support to pass dynamic content to JOIN_DATA property (Usecase - Query XML CData / JSON stored as string)

Bug fixes

FIX: All API Drivers - JOIN Query may hang when full data cache is enabled
FIX: All API Drivers - JOIN Query Performance Improvement (parse metadata for only first URL rather than every URL in the group)
FIX: All API Drivers - Nested JOIN queries always use Parent Filter even though you do not set child URL Filter
FIX: All API Drivers - Query preview may throw error - Table xxxxxx already exists
FIX: All API Drivers - Save Metadata to File should use SaveAs dialog rather than File Open
FIX: All API Drivers - TTL for DataCache is not working
FIX: Apps - Informatica - Cloud version reads extra row from ODBC driver
FIX: Apps - Informatica - In some cases you may get error - Index was outside the bounds of the array
FIX: Apps - Informatica - Sometimes you may see many NULL rows and invalid column order (ExtendedFetch Improvements for ODBC v2)
FIX: Apps - MS Access - Some times you may get error (-7766) importing data
FIX: Apps - SSRS - Clicking execute in Query Builder may crash Visual Studio
FIX: Data Gateway - Boolean value may throw - Protocol error in TDS Stream
FIX: Data Gateway - Show meaningful error when Wrong catalog / credentials supplied
FIX: Data Gateway - Throw useful syntax errors rather than generic error TCP Provider: An existing connection was forcibly closed by the remote host.
FIX: Data Gateway - You may get Protocol error in TDS stream if duplicate column names found (e.g. Id, ID)
FIX: General - Pressing Escape closes Driver UI without saving changes
FIX: General - Sometimes you may get wrong datatypes after changing data caching mode (specially DateTime type)
FIX: JSON, XML Driver - Enable Array Flattening option may return NULL values for nested properties

Version 1.0.14.11107 [Nov 07, 2018]

Bug fixes

FIX: CSV Driver - You may get error - Option 'hascolumnheaderrow' is not supported
FIX: Data Gateway - Show meaningful error when Wrong catalog specified
FIX: Data Gateway - Some data causes error in MS SQL
FIX: Data Gateway - SQLNCLI11" for linked server "ZS_GATEWAY_AZ" supplied inconsistent metadata for a column. The name was changed at execution time
FIX: Data Gateway - ZsXml option throws error in Gateway - ZappySys.Odbc.Xml.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format.
FIX: JSON, XML Driver - 2D Transform MultiColumnExpression Parser Error - Given Key was not present in dictionary
FIX: JSON, XML, CSV Driver - Enhance Regex function and examples (Add condition to search specific occurrence / group, ignore case)
FIX: JSON, XML, CSV Driver - HTTP Grid is disabled if HTTP Method is blank
FIX: JSON, XML, CSV Driver - HTTP Headers not saved (when more than one header entered in UI)
FIX: JSON, XML, CSV Driver - SQL Function with more than 4 parameters fails
FIX: JSON, XML, CSV Driver - Table list in not refresh in preview window after changes in grid

Version 1.0.0 [Dec 1, 2017] (Initial Release)

This is the first release of SSIS PowerPack which includes following tasks and components

NEW: JSON Driver - JSON driver can read data from local files or Web API (REST, OData). Using this driver you can write Query in familiar SQL language and query nested structure / output as flat table.
NEW: XML Driver - XML driver can read data from local files or Web API (REST, SOAP, OData). Using this driver you can write Query in familiar SQL language and query nested structure / output as flat table.
NEW: ZappySys Data Gateway - Using tight integration with Microsoft SQL Server you can easily query XML/JSON or API inside your T-SQL code.