Invantive SQL is a netstandard 2.1 port of Invantive SQL that allows access to over 60 cloud and database platforms, all acting together as one global database.
Created: 07/04/2021 10:21:25 (UTC, deploy002)
MSI Product ID: 24467287-923b-4dfa-a638-3992c9af298e
Manufacturer: Invantive Software B.V.
Copyright: (C) Copyright 2004-2021 Invantive Software B.V., the Netherlands. All rights reserved.
Enhancements: - Improve statistics on Exact Online. - Improve caching and invalidation of active Exact Online divisions. Version 20.1.393-BETA, released 2021-04-05. Enhancements: - Add Twinfield metadata table TableColumnSpecifications. - Execution hints and limit on update and delete SQL statements. - ActiveCampaign: Improve performance of update/delete. Bug fixes: - Do not erase Twinfield year/period in cash transactions. - Fix itgenefd016 on FoxPro queries. - Fix insert/update on ActiveCampaign. - AFAS: Remove version endpoint. - Fix insert/update on ActiveCampaign. Version 20.1.392-BETA, released 2021-04-01. Enhancements: - Exclude AFAS ProfitVersion connector. - Add Active field to Yuki companies. Bug fixes: - Fix itgenboe022 error message when retrieving data from Bridge Online. - AFAS: Remove call to profit version endpoint. - AFAS: Remove call to profit version endpoint. - Refactoring to fix memory issues and invalid results on row_number, rank, and similar functions. Version 20.1.391-BETA, released 2021-03-29. Enhancements: - Add public query parameters to session I/O in data dictionary. - Add public query parameters to session I/O in data dictionary. - Improve naming of alternatives for non-existing data container aliases. - Allow selecting to use the REST and/or the XML API of Exact Online. Bug fixes: - Apply date format on text to date conversion on Twinfield. Version 20.1.390-BETA, released 2021-03-23. Enhancements: - Improve internal server errors on OData. Bug fixes: - Correctly alias escaped fields, allow order as alias. - Create a better Freshdesk URL, fix rate limiting issue. Version 20.1.386-BETA, released 2021-03-18. Enhancements: - Enable configuration PSQL logging by INVANTIVE_TRACE_PSQL. - Optimizations for incremental loading of data. Version 20.1.384-BETA, released 2021-03-16. Enhancements: - Raise clearer error when using an invalid client secret. - Add cloud_http.get_request_relative_path_to_module function. Version 20.1.378-BETA, released 2021-03-13. Enhancements: - Optimize performance by reducing global state allocations. - Optimize performanec by reducing global state allocations. - Optimize performanec by reducing global state allocations. - Optimize performanec by reducing global state allocations. - Optimize performanec by reducing global state allocations. - Tune metadata collection. - Improve hints when a non-existing partition is used. - Do not update derived column values on synchronize. - Differentiate ActiveCampaign fields that are derived and not for improved update efficiency. - Limit deals.description to at most 1.000 characters. - Optimize join performance and improve matching to data sources. Version 20.1.372-BETA, released 2021-03-09. Enhancements: - Add columns with number of API calls to SystemProvidersActive@DataDictionary and SystemPartitions@DataDictionary to ease analysis of API usage per instance. - Add split_part SQL function. - Add Loket.nl views for payroll components. - Make XML providers yield more, lowers memory usage. - Add first data container ID on data container. - Register date/time of occurrence of dbms_output. - Fine-tune handling on 503 error received through OData. - Add Teamleader V2 views QuotationLinesAll and InvoiceLinesAll. - Add exclude URLs on internetTable table function. Bug fixes: - Fix error accessing UserDefinedTypes on SQL Server through OData. - Correctly size target on synchronize. - Exclude sitemap URLs not in the stay on site list when applicable. - Fix retrieving non-partition-specific tables on Exact Online XML. - Fix retrieving internet table function receiving null sitemap URLs. - Fix retrieving non-partition-specific tables on Exact Online XML. - Make XML providers yield more, lowers memory usage, fix retrieving non-partition-specific tables on Exact Online XML. - Allow internet table on join. - Fix to_char on dates with format yyyy-mm-dd hh24:mi:ss. Version 20.1.371-BETA, released 2021-02-28. Enhancements: - Add Exact Online sync APIs QuotationLinesIncremental, SalesOrderLinesIncremental and SalesInvoiceLinesIncremental. - Add incremental sync API for quotation lines, sales invoice lines and sales order lines on Exact Online. - Swagger: include parent properties, also when they reside in another branch (allOf, etc) Bug fixes: - Loket.nl: Fix Swagger for missing property types on payslip. Version 20.1.369-BETA, released 2021-02-23. Enhancements: - Throw error when adding duplicate division in Exact Online. - Loket.nl: retrieve both JSON and PDF response from endpoints returning multiple content types. Bug fixes: - IsApiCall made optional on Exact Online. Version 20.1.368-BETA, released 2021-02-19. Enhancements: - Add Exact Online GLAccountsIncremental, AccountsIncremental, ContactsIncremental and AddressesIncremental. Version 20.1.366-BETA, released 2021-02-18. Bug fixes: - Make division move date nullable. Version 20.1.365-BETA, released 2021-02-17. Enhancements: - Add documentation on cloud_metadata package. - Allow specifying a file path as (temporary) location for the Swagger specification. Version 20.1.364-BETA, released 2021-02-16. Enhancements: - Add German Exact Online Query Tool. - Extend Exact Online incremental result by analysis information. Bug fixes: - Add missing Account field to SyncTransactionLines on Exact Online. Version 20.1.362-BETA, released 2021-02-12. Enhancements: - Add error codes to ActiveCampaign. - Add Exact Online tables DigitalOrderPickingLines and others. - Include kind request from aggregate exceptions. Bug fixes: - Enable retrieval of account information even when the current Exact Online company is not listed in available companies. - Correct mapping precision and scale for byte on SQL Server. - Correct SQL Server bit mapping to always boolean from previously sometimes number. Version 20.1.358-BETA, released 2021-02-11. Enhancements: - Add messaging tables to Invantive Cloud. Bug fixes: - Fix error on tinyint represented as sbyte with MySQL. Version 20.1.356-BETA, released 2021-02-10. Enhancements: - Add log file and trace file name path to Data Hub end-user failure reports. - Compact object tool tip. - Add cloud_http.append_to_response_body_text for better performance on generating large web content. - Make maximum number of webhook management errors on Exact Online configurable from the default of 500. - Add minor indexes on Data Replicator repository. - Add view ItemExtraFieldValues for Exact Online. - Retry on itgenoda314, itgenoda316, itgenoda466 and itgenoda039 on OData drivers such as Exact Online when the API server crashes. - Consider name resolution failure as a pre-connection error on OData instead of post-connection establishment. - Remove non-normalized columns from Exact Online APIs. Bug fixes: - Fix Open Arch comments table making archive parameter optional. - Fix Data Replicator event log on table in Query Tool. - Correct database determination of unqualified object on SQL Server for Data Replicator. - Correct required table function parameter check on ActiveCampaign. - Fix itgencsy203 on insert on auditevents@datadictionary. - Percent of deals in ActiveCampaign is optional. Version 20.1.355-BETA, released 2021-02-07. Enhancements: - Add new Exact Online tables. Bug fixes: - Ensure GUI module always set. Version 20.1.354-BETA, released 2021-02-06. Enhancements: - Add ActiveCampaign tables AccountWithCustomFieldValues, ContactWithCustomFieldValues, ContactWithTags, ContactWithBounceLogs. - Include natural key in error message when update fails on OData drivers. - Add channels to dbms_output. - Include response status in native call log. - Add alternative error format to ActiveCampaign. Version 20.1.352-BETA, released 2021-02-05. Enhancements: - Add new rate limiter of 5 calls per second for ActiveCampaign. - Rewrite chosen division when it is not granted to the app, avoiding use of AccountantInfo. - Reduce account information lookups. - Differentiate Exact Online HTTP 403 errors. - Enable override of default retry settings. - Reduce to new minutely rate limits on Exact Online. - Differentiate translation cache file formats. - Update documentation of Exact Online Sync APIs. Version 20.1.349-BETA, released 2021-02-02. Enhancements: - Create backup of downloaded swagger specifications. Bug fixes: - Revert to API version 50 for Salesforce since chatter/users/me fails on 51. Version 20.1.348-BETA, released 2021-02-01. Enhancements: - Improve error message itgendid219. Bug fixes: - Fix Salesforce database registration on Invantive Cloud. - Rename Loket.nl EmployersByUser to EmployersByUserId. Version 20.1.345-BETA, released 2021-01-29. Enhancements: - Add Teamleader view ProductPricesAll. - Extend length of Exact Online AddressLine123. - Add Teamleader view SubscriptionItemsAll. - Allow fields with special characters in AFAS Profit filters and ordering. - Allow sub-minute resolution on time tracking with V1 API of Teamleader. Version 20.1.340-BETA, released 2021-01-25. Enhancements: - Rename Open Data to Public Data. - Finetune behaviour on Oracle with double data type. Bug fixes: - Logius COR: kvkNummer as a text fields. Version 20.1.339-BETA, released 2021-01-21. Enhancements: - Raise SQL error when using an unsupported format on to_char. - Improve COR metadata. Bug fixes: - Make EntryMethod optional in Exact Online SalesPriceDetails. Version 20.1.338-BETA, released 2021-01-19. Enhancements: - Add Logius COR driver. - Make mdate optional on ActiveCampaigns. - DBMS output. - DBMS output. - Add ignore-http-503-errors driver attribute for OData-based drivers. - Extract more types of message from Teamleader logon failure. Bug fixes: - Fix "value cannot be null" on Loket REST. - Exact Online: Fix error when filtering on division on non-partition-specific tables. - Avoid NullReference when deserializing JSON. Version 20.1.328-BETA, released 2021-01-10. Enhancements: - Replace return value to exception. Version 20.1.327-BETA, released 2021-01-08. Enhancements: - Differentiate HTTP errors on OData with own message codes. - Raise itgeneor234 instead of invalid_request when Exact Online API servers can not handle request for new refresh token. - Improve Freshdesk API performance. - Add minutely rate limiting for Freshdesk, including endpoint-specific rate limits. - Add Freshdesk views. - Add Freshdesk ratelimiters view. - Make slot-based rate limiter also object dependent. - Make slot-based rate limiter also object dependent. - Add RFC3339 data format for table function parameters. Bug fixes: - Avoid duplicate forward slash in data container ID of Swagger-based drivers such as Loket. - Revert exclusion of Account/SalesPaymentCondition and SalesOrder/ShippingMethod on XML Exact Online. - Fix itgenefd015 for MySQL double/float. Version 20.1.326-BETA, released 2021-01-04. Bug fixes: - Simplicate: fix download document. - Join: don't fetch entire left side when not indexing. - Simplicate: fix download document. - Correct incorrect SQL dates. - Fix null value and JSON object resolution to JSON table function. - Fix jsonencode for dates. Version 20.1.325-BETA, released 2020-12-29. Enhancements: - Add package functions to providers. - Chargebee: Server side filtering to improve performance. - Chargebee: Server side filtering to improve performance. - Default sorting on listagg. Bug fixes: - Give error message when data is being truncated due to the wrong numeric data type (integers). - Better error message when using a array data type on an unsupported place. Version 20.1.317-BETA, released 2020-12-24. Enhancements: - Add view Isses to JIRA Cloud. Version 20.1.315-BETA, released 2020-12-21. Bug fixes: - OData: Do not calculate fields that are not requested. Version 20.1.313-BETA, released 2020-12-20. Enhancements: - Allow configuration of compression/sharing strings and bytes. - Improve performance when there are no filters. - Optimize calculation of AllFiltersAreAnd. Bug fixes: - Add date format "dd/mm/yyyy hh24:mi:ss". Version 20.1.308-BETA, released 2020-12-17. Enhancements: - Translate AFAS Profit generic Windows error to pre-defined error itgenaoe026/itgenaoe027. Bug fixes: - Change Swagger URL production Robaws. Version 20.1.306-BETA, released 2020-12-15. Enhancements: - Add download invoice PDF to Chargebee. - Handle SSL failures on OData as a non-connection signal. - Internet table function: Read sitemaps recursively. Bug fixes: - Fix Teamleader V1 API product_suppliers returning incorrect contents. - Show meaningful error message when Teamleader user has limited access. - Adapt API on production for breaking change on V1 API. Version 20.1.302-BETA, released 2020-12-13. Enhancements: - Add fields for Robaws error JSON. - Allow both start at URL and sitemaps on INTERNETTABLE. - Explicitly specific V1/V2 API on Robaws test environment. - Ignore Last-Modified of 1-1-0001 on Internet fetches. - Add sitemap option to internettable table function. - Chargebee: Add custom field configs table. - Add custom fields to main list tables. - Add custom fields to main list tables. Bug fixes: - Report Unauthorized correctly when Robaws returns invalid JSON together with HTTP 401. - Fix Simplicate hour fractions disappearing. Version 20.1.301-BETA, released 2020-12-09. Enhancements: - Enable use of Robaws when development environment of Robaws is down. - Add main category to providers. - Add main category to providers. - Avoid duplicate slash on Loket.nl data container ID name. - Add timestamp without time zone data type. - Translate 'Forbidden - The chosen User division is not within division scope.' to an error code. Bug fixes: - Correct determination whether parameters are required on ActiveCampaign. - Correct short name of Roller API driver. - Avoid missing precision problem on Exact Online. - Add deletion time warning as documentation. - Disable server-side filtering on GLAccountsBulk.Code. - Disable server-side filtering on GLAccountsBulk.Code. - Fix itgenefd016. Version 20.1.300-BETA, released 2020-12-03. Enhancements: - Knack: Add multiple choice view for views, as in tables. Bug fixes: - Fix updating/deleting too many rows on Knack. Version 20.1.297-BETA, released 2020-12-02. Bug fixes: - Fix data dictionary data model bug. Version 20.1.296-BETA, released 2020-12-02. Enhancements: - Add data cleansing on Exact Online. - Separately handle kind request and natural key in message windows. Bug fixes: - Fix itgenefd016 on GLAccountClassificationRelations. Version 20.1.286-BETA, released 2020-11-24. Bug fixes: - Make GetObjectMetadata more thread-safe. - Make GetObjectMetadata more thread-safe. Version 20.1.284-BETA, released 2020-11-20. Enhancements: - Add NMBRS APIs. - Use token instead of envid when envid is not available on AFAS. - Add views for Teamleader V2 custom fields. Bug fixes: - Extend list of applications that allow 1 or more joins. - Require either both precision and scale or neither when defining ANSI SQL fields. - Add Period column to NMBRS table CompanyWorkCosts. - Fix error on missing column and invalid column name when updating Knack. Version 20.1.282-BETA, released 2020-11-17. Enhancements: - Add parameter enum values to Swagger parameter documentation. Bug fixes: - Fix bug in Exact Online app store view. - Fix Data Replicator error: "Table 'dc_incoming_messages' already has a primary key defined on it." due to case sensitivity support added on SQL Server. - Add missing catalog to Wikipedia. - Fix required property of excerpt of Discourse. Version 20.1.279-BETA, released 2020-11-16. Enhancements: - Chargebee: add customers. Bug fixes: - Fix Robaws duplicate field error. - Do not raise itgensql417 when no alias is used on the facts data source for Data Replicator. Version 20.1.278-BETA, released 2020-11-13. Enhancements: - Include classification level 9 and 10 in Exact Online XML API view glclassificationmemberclassifications - Add retry on open ANSI connection. Bug fixes: - Fix for invalid empty result on Knack file/image fields. - Fix duplicate key error when inserting empty file values. - Set type of file/image on upload. - Set type of file/image on upload. - Set type of file/image on upload. - Discourse: fix lots of data model issues. Version 20.1.277-BETA, released 2020-11-10. Enhancements: - Add workaround for NRE bug in NpgSql 4.1.5 during connection open. - Simplify GUI action on event registration for Data Hub administrators. - Improve usability on case-sensitive SQL Server databases. - Add XML APIs for Finished assembly parts and serial numbers. - Automatically ignore rule 20 (recursion) when the XML path is explicitly requested. - Add check itgensql417. - Add Discourse provider. Bug fixes: - Fix object name resolution when using an escaped object name. Version 20.1.273-BETA, released 2020-11-07. Enhancements: - Return primary key, row count and native answer from insert. Version 20.1.271-BETA, released 2020-11-06. Enhancements: - Add AFAS Profit 15 setting 'analysis-add-default-sort-get-connectors'. - Memorize last action. Bug fixes: - Add default ordering on AFAS. - Avoid incorrect nullable check on partition name on SystemPartitionTags@DataDictionary. Version 20.1.270-BETA, released 2020-11-06. Enhancements: - Drop obsolete Loket table JobApplicantsByEmployerId. - Retry on several SQL Server errors such as deadlock. Version 20.1.267-BETA, released 2020-11-04. Enhancements: - Fine-tune determination of data container ID on SQL Server. - Knack: add rate limits table. - Only default to encrypted connections for non-discovered SQL Server databases. - Knack: Implement rate limits. - Single write on update and delete when using primary key in filter. - Extend length of Teamleader forename. - Enable configuration of maximum number of FoxPro errors per table using max-table-memo-value-errors. - Differentiate OData errors between system failures and platform failures. Bug fixes: - Fix itgenclr096 when determining collation on a SQL Server with case sensitive collation. - Knack: Fix itgenrst007 null value metadata issue. - Assume the date format yyyy-MM-dd is local time when converting text to a date/datetime. - Fix broken insert and update on date. - Ignore exceptions on canceling SQL commands. Version 20.1.266-BETA, released 2020-10-30. Enhancements: - Make metadata cache of Knack.com configurable. - Add column to view dc_table_partition_versions for analysis of itgendch808. Bug fixes: - Fix data corruption on Exact Online CustomerCooperations. - Fix like optimization on fields with leading or trailing spaces. Version 20.1.260-BETA, released 2020-10-27. Enhancements: - Extend HTTPDownload@DataDictionary to return 50 instead of 4 columns with metadata on the retrieved URL data. - Make SQL comments valid SQL statement. - Knack: Multiple choice views. - Knack: Add upload of files and images. - Support update and delete on Knack. Bug fixes: - Improve SQL Server support on case sensitive database. - Fix regression bug on SQL Server causing itgenase094 on create table. Version 20.1.257-BETA, released 2020-10-21. Bug fixes: - Fix bug on KDBX errors raising null reference. Version 20.1.256-BETA, released 2020-10-19. Enhancements: - Support for SQL Server with case-sensitive collations. - Add InvoiceLinesById and InvoiceGroupedLinesById to Teamleader. - Avoid integrity checks failing on Exact Online PlannedSalesReturnLines due to data corruption in some divisions. - Circumvent incorrect delivery of default GUID provided by Exact Online instead of null value. - Improve ignore documents on Exact Online with errors. - Make number of parallel Internet downloads configurable. - Allow ignore of web retrieval errors on httpdownload@datadictionary. Bug fixes: - Unpack CData sections correctly in XML table. - Fix passing parameters into Nmbrs. - Fix reading result set JSON files. - Workaround for Teamleader Invoices by Deal, plus better parsing of '.' as grouping separator in fields (without further words of putting formatting in raw payload). - Fix OData filtering. - Avoid itgenodr007 when cleansing Exact Online field data. - Fix wrong calculation of OData URL filters. - Fix date formatting. - Fix date formatting using to_char. Version 20.1.247-BETA, released 2020-10-09. Enhancements: - Add session IO pages. Version 20.1.243-BETA, released 2020-10-08. Enhancements: - Allow cleansing of data on Exact Online broken APIs. - Knack: handling multiple choice field. - Include context on line number of CSV file processed when an error occurs in csvtable executing. Bug fixes: - Make ReceivablesList and PayablesList ID column optional. - Update Teamleader V1 documentation location. - Make obsoleted Exact Online columns nullable. - Make obsoleted Exact Online columns nullable. Version 20.1.241-BETA, released 2020-10-06. Enhancements: - Add option to opt out of low_cost on selects. - Retry on MySQL not returning data reader. - Add data type conversions for numbers to avoid itgenrst004. - Add lookup of HSTS preload status to Internettable. - Extend output of internettable. - Knack show better error messages. - Knack show better error messages. - Enable overrule of UI language by environment variable INVANTIVE_ALLOWED_LANGUAGE_CODES. - Knack: support insert on objects and with most data types. Bug fixes: - Remove length type modifier on PostgreSQL bytea. - Do not raise error when length is specified of byte array. - Fix Knack connection data type, add expanded data tables. - Removed fields removed in Exact Online due to performance issues on GetMostRecentlyUsedDivisions. - Fix error on Loket view EmployerNotifications. Version 20.1.236-BETA, released 2020-09-29. Enhancements: - Fix paging Yuki documents. - Fix paging Yuki documents. Bug fixes: - Knack unique schema, table and field names. Version 20.1.233-BETA, released 2020-09-28. Enhancements: - Reduce number of columns in Robaws Offers. - Improve message clarity for MySQL problem with reading columns of an object. - Fix retrieval of single-row 'detail' entities, add record_id field. Version 20.1.230-BETA, released 2020-09-25. Enhancements: - Add Zoom connector license structure. - Knack: add views and scenes, add user authentication. - Update Knack metadata. - Add Zoom provider. - Differentiate error messages raised by Yuki. Version 20.1.226-BETA, released 2020-09-22. Enhancements: - Raise error when loading connector twice. - Add Knack. Bug fixes: - Retrieve times data typed columns correctly. Version 20.1.224-BETA, released 2020-09-19. Enhancements: - Move forward Robas time ticket on January 1, 1 to 1970. - Include source of provider attribute in SystemProviderAttributes@datadictionary. - Add application scope specific error codes for new Exact Online security checks. - Include connector information in systemproviderattributes@datadictionary. Bug fixes: - Fix missing fields on Swagger. - Fix NRE on creating an authentication exception. Version 20.1.215-BETA, released 2020-09-11. Enhancements: - Extend httpdownload by minimum duration (ms). - Extend support for quotations on Teamleader V2. - Additional V2 quotation line and header information on Teamleader. Bug fixes: - Fix database numbering on Bridge Online connector. - Fix NRE on Nmbrs when determining data container ID. Version 20.1.212-BETA, released 2020-09-10. Enhancements: - Check on Exact Online customer code 1. - Allow Creator/Modifier to be missing on Exact Online mailbox, such as with division 1. - Refine error messages on Exact Online for data scoping. - Add Teamleader quotations and fix currency exchange rate issues on milestones and projects. Bug fixes: - Fix IndexOutOfRangeException in some Exact Online companies. - Check Yuki domains for access on adminstrations. - Fix NRE in Yuki. - Better error message when accessing external fields in inline view. - Fix loading Teamleader views. Version 20.1.206-BETA, released 2020-09-07. Enhancements: - Add hint on NMBRS token. Bug fixes: - Make InternetTable table function more resilient when returning results partly [ITGEN-5194]. - Add checks for data types in Excel/JSON/XML etc. tables. Version 20.1.202-BETA, released 2020-09-06. Enhancements: - Extend system partitions by new owner of partition fields. - Extend system partitions by new owner of partition fields. - Add new fields to Exact Online Current/me. - Add new fields for Exact Online SystemDivisions. Version 20.1.201-BETA, released 2020-09-05. Enhancements: - Add binary HTTP output as cloud_http.set_response_body_binary. - Consider www.acme.com and acme.com same host for internettable table function. Version 20.1.200-BETA, released 2020-09-04. Enhancements: - Include request and response in cloud_http procedure names. - Update documentation cloud_http. - Add prefix differentiation for HTTP disk cache. - Add Teamleader tables for migration between V1 and V2. Bug fixes: - Correct incremental APIs on Exact Online merging new and old results. - Avoid itgentln007 when switching from UI language. Version 20.1.198-BETA, released 2020-09-02. Enhancements: - CSV encode and decode SQL functions. Version 20.1.189-BETA, released 2020-08-31. Enhancements: - Increase default command timeout for ANSI SQL-based connectors to 300 seconds. Bug fixes: - Fix itgenuse010 when connectors supported "no selected partitions" mode and 'use all' is executed. - Fix itgenuse010 when connectors supported "no selected partitions" mode and 'use all' is executed. - Fix broken paging on CustomerInvoices for Visma.net. Version 20.1.183-BETA, released 2020-08-28. Enhancements: - Add Bridge Online response cache maximum age seconds. Version 20.1.179-BETA, released 2020-08-26. Enhancements: - Add user information to Loket.nl and improve performance of payslips view. - Add Ignore 404 setting on OData. - Add loket.nl view for payment slip PDFs. - Auto-choose MIME type for Swagger-based connectors with multiple produces. - Add special::xpath, special::innerhtml, special::innertext and special::outerhtml to HTMLtable table function. - Update Exact Online sync APIs. - Include first employer in data container of Loket. - Differentiate data container ID for NMBRS depending on first debtor. - Relocate Yuki to Visma group. - Add views for 18 en 54 weeks of Teamleader hours. - Add check itgenvnt008 on Visma.net that at least one company is available. - Add check itgengpr105, itgenuse010 and itgenuse011 that partitions are provided with select specific partitions. - Add check itgengpr104 and itgengpr103 that partitions are provided with select specific partitions. - Add new deleted types for Exact Online sync APIs. - Add Yuki views for Contacts and Users. - Ignore Yuki error 'The domain is not licensed for this functionality' when running cross-domain queries. - Sort alternative names on itgendid201. - Relocate Roller API. - Improve purging of died sessions on Data Cache repository. Bug fixes: - Reduce memory allocations on Swagger cache. - Do not add natural key to error message when already present near end of error. - Correct label for token on Open Exchange Rates provider - Fix data issues in Invantive Business documents and transaction lines. - Return Exact Online currencies for Invantive Business currencies table. - Avoid StackOverflow on event log purge after more than 35 days of inactivity. Version 20.1.169-BETA, released 2020-08-10. Enhancements: - Extend cloud_http package by get_header_value, get_url and get_pool_identity. Bug fixes: - Make color nullable in stages of ActiveCampaign. Version 20.1.164-BETA, released 2020-08-06. Enhancements: - Add Quotation incremental table. - Remove check on role loading sync deleted table. Bug fixes: - Clear Account column on RevenueByDebtorList, RevenueByDebtorForYear and RevenueByDebtorForYearPeriod when an empty Guid has been provided. - Clear Account column on RevenueByDebtorList, RevenueByDebtorForYear and RevenueByDebtorForYearPeriod when an empty Guid has been provided. - Make Account null on Exact Revenue* table functions. Version 20.1.161-BETA, released 2020-08-05. Enhancements: - Teamleader V2 adding budget fields on projects and milestones. - Fix baseURL variable for canonical URL generation help&manual Version 20.1.156-BETA, released 2020-07-27. Enhancements: - Add new_time SQL function and support a wide variety of time zones. Bug fixes: - Fix error "itgenefn003: The field with name 'ITEM_CODE_ATTR' is unknown." on TimeTransactions using I_EOL_TIMESHEETS_AMOUNT. - Fix error "itgendcr007: Can't find the column 'DIVISION_CODE' in the current list of columns." on TimeTransactionsExtended. - Loket: fix NullReferenceException. Version 20.1.154-BETA, released 2020-07-22. Enhancements: - Yuki: support changing domains [ITGEN-5137]. Bug fixes: - Fix determining number of rows affected when one of the results is an empty result set. - Nmbrs: default date to null. - Fix OData filtering issue. Version 20.1.142-BETA, released 2020-07-09. Enhancements: - Teamleader: cache Migrate ID endpoint results indefinitely. - Teamleader: Add Migrate ID endpoint. Bug fixes: - Fix caching of ExactOnline document attachment files (non-bulk). - Confluence URL fixes. - Confluence URL fixes. Version 20.1.141-BETA, released 2020-07-08. Bug fixes: - Fix Producer repository log on using managed Oracle driver. - Correct description of page-size-rows. Version 20.1.133-BETA, released 2020-07-06. Bug fixes: - Implement rate limit checks on Freshdesk. Version 20.1.118-BETA, released 2020-07-05. Enhancements: - Switch object size resolution from KB to bytes. Bug fixes: - Avoid cast to decimal giving error. Version 20.1.115-BETA, released 2020-07-03. Enhancements: - Include parameters as natural key on SOAP errors. - Include text of inner exceptions in SQLERRM. - Added all documented incremental tables. Bug fixes: - Fix NMBRS views. - Avoid NullReferenceException in edge cases on OData. - Fix synchronizing excluding columns on insert. - Correct metadata for ecom orders - Reduce number of columns in Exact Online XML API ItemPrices. Version 20.1.109-BETA, released 2020-06-29. Enhancements: - Added all documented incremental tables. - Add division columns to incremental transaction lines table. - Add logic to handle 422 errors on OData connectors. - Add values to OData error. - Add missing fields on Robaws. - Make correction of invalid dates possible using invantive-sql-correct-invalid-date setting. - Make unknown path and maximum discovered column count configurable on Swagger-based connectors. Bug fixes: - Do not include error code twice in ActiveCampaign connector messages. Version 20.1.100-BETA, released 2020-06-26. Bug fixes: - Phone number in Teamleader V2 contact telephones is optional. Version 20.1.99-BETA, released 2020-06-25. Enhancements: - Remap greater equal combined with less equal filters on Data Dictionary queries into between for improved performance on date range queries. - Added incremental table on EOL transaction lines. - Add Loket.nl view EmploymentCompanyCars. - Improve error handling on Loket. - Add support for ignorable OData API server errors. - Simplicate filtering. - Allow use of license keys split across multiple lines. - Add 17 new Exact Online tables and 400 columns. - Reduce memory footprint of select Count(*). - Update Roller. Bug fixes: - Exclude non-processed payroll runs. - Avoid itgenrst007 on Employee Absences on Loket.nl. - Correct Yuki project balances. - Interprete 0001-01-01 on Yuki as null. Version 20.1.95-BETA, released 2020-06-19. Enhancements: - Improved error message when an OData API server returns HTML instead of JSON. - Add option to ignore checks on JSON path values with Swagger. - Add Simplicate data model. Version 20.1.89-BETA, released 2020-06-17. Enhancements: - Inherit JSON serialization of default and null values from serializer for JSON custom serializer for Data Access Point. - Reduce length of trace file names. - Retry event registration on ActiveCampaign when it fails. Bug fixes: - Default user information to avoid itgendar042 error on ECB. - Correct need for user/password on non-authorized connectors. - Reduce lifetime of Swagger definition cache from 7 to 1 day. Version 20.1.51-BETA, released 2020-06-08. Enhancements: - Improve error message itgendid151. - Add simulator for OData 401 errors. Bug fixes: - Make split_type on ActiveCampaign campaign optional. Version 20.1.50-BETA, released 2020-06-05. Enhancements: - Update Roller metadata. - Improve error message when GL accounts are not accessible at all. - Extend length of street to 120 characters for Teamleader despite UI limitation. Bug fixes: - Make some fields optional on ActiveCampaign. - Fix optimized join on Exact Online divisions. - Re-enable itgeneor137. - Show partition codes with itgeneor131. - Revert OData logic for like / not like. - Rename Twinfield SubItems to SubItemsByArticle. Version 20.1.48-BETA, released 2020-05-29. Enhancements: - Enable filter on year/period in all transaction tables on Twinfield. - Display errors returned as HTML from Twinfield. - Raise error when a single/all column expressions have a label, alias or prefix intended for all/single column expressions use. - Make join set available in more scenarios for better performance. - Optimize large company volume queries on Exact Online and others. - Include message codes in some errors. - Improve filtering performance in OData. Bug fixes: - Avoid duplicate inclusion of message code in errors. - End Twinfield delayed requests when the previous HTTP request is somehow not terminated automatically upon expiry. - Fix intermediate file name duplication on complex OData URLs. - Reduce use of IN for Exact Online OData queries. Version 20.1.47-BETA, released 2020-05-26. Enhancements: - Add client-side check on date/time range values for Exact Online. Version 20.1.46-BETA, released 2020-05-26. Bug fixes: - Forward correct pool identity. - Fix visma.net typo. - Reduce number of columns on Robaws. Version 20.1.44-BETA, released 2020-05-24. Enhancements: - Add 300+ Visma.net APIs. - Log native calls also to disk. Bug fixes: - Fix missing and/or duplicate rows in ROBAWS. - Avoid ArgumentException caused by handling another Exact Online REST exception. - Fix path on Swagger. - Fix changed page number semantics for Visma.net. - Fix logging. Version 20.1.43-BETA, released 2020-05-22. Enhancements: - Increase default join-set size from 5.000 to 10.000. - Reduce memory consumption for Twinfield. - Enable custom I18N files using the environment variable INVANTIVE_I18N_FOLDER. Bug fixes: - company_id missing on table functions for Twinfield [ITGEN-4634]. - Fix compatibility with SQL Server 2014. - Fix partition selection on Twinfield [ITGEN-4633]. - Fix request successful flag on SOAP providers [ITGEN-4895]. - Fix request successful flag on SOAP providers [ITGEN-4895]. - Fix Twinfield retrieving data from wrong partitions [ITGEN-5084]. - Also retry on HTTP 503 errors with OData. Version 20.1.42-BETA, released 2020-05-20. Enhancements: - Usage dashboard card. - Add Teamleader views ProjectUsers and ProjectRelatedParties. Bug fixes: - Include all errors of aggregate exceptions for Data Hub. - Fix problem with Business for Visma.net. - Updated paging mechanism [ITGEN-5078]. Version 20.1.41-BETA, released 2020-05-18. Enhancements: - Add more check on internal crashes of Exact Online. - Materialize bind variables in large IN value lists. - Re-add project_code_attr to itemprices on ExactOnline XML. - Raise clear error when a column is listed multiple times with '* except ...'. Bug fixes: - Detect English version of no access to XML Exact Online. Version 20.1.39-BETA, released 2020-05-15. Enhancements: - Use finger print for SQL area instead of SQL statement. - Improved performance of queries on Data Dictionary. Bug fixes: - Correct filter performance on Data Dictionary for performance. - Correct upgrade customer service. Version 20.1.36-BETA, released 2020-05-14. Bug fixes: - Correctly pass long values with L suffix in OData filters [ITGEN-5065]. - Retrieve more metadata, correct data types not provided with Swagger. Version 20.1.34-BETA, released 2020-05-13. Enhancements: - Improve performance of data dictionary queries with a filter on systemtablecolumns. - Add 900 additional fields and 18 tables to Exact Online metadata. - Exact Online columns becoming required. - Relocate Nmbrs to Visma. - Solely drop views for facts when running Data Replicator on PostgreSQL. - Reduce length of disk cache file names. - Reduce length of disk cache file names. - Add sys_context iiid and iuid. Bug fixes: - De-duplicate service URLs found during OData discovery. - Make Param_GLAccount for MatchSets, MatchSetLines, and all related tables a GUID [ITGEN-5060]. - Fix field position error when setting use-metadata-memory-cache to false. - Add missing fields on ItemPrices and Items. - Allow negative duration of I/O due to Windows clock going backward sometimes. - Ensure message text fits even with long list of changes. - Align version detection on Azure SQL Server with on-premsie SQL Server. Version 20.1.27-BETA, released 2020-05-07. Bug fixes: - Fix moved Exact Online REST endpoints: GLAccountClassificationMappings, OfficialReturns, ReportingBalanceByClassification. Version 20.1.23-BETA, released 2020-05-06. Enhancements: - Add views to NMBRS. Version 20.1.21-BETA, released 2020-05-04. Enhancements: - Allow custom Bridge Online URL segments. - Improve error itgenisr004. - Dynamically switch Data Replicator between full loading and trickle loading depending on percentage. - Reduce memory pressure when replicating to disk. - Reduce memory pressure checking rows. Bug fixes: - Improve capability with SQL Server 2014. - Fix data type of physical memory on Data Replicator. - Show which connector can not register. Version 20.1.20-BETA, released 2020-05-02. Enhancements: - Differentiate discovered database per version. Version 20.1.18-BETA, released 2020-05-01. Enhancements: - Add registration of license code used for Data Cache to ease analysis of finger print issues. - Add NMBRS views. Version 20.1.16-BETA, released 2020-04-29. Enhancements: - Improve message itgendch655. Bug fixes: - Correct type of itgenase098. Version 20.1.15-BETA, released 2020-04-28. Enhancements: - Do not disable lock escalation on external tables on SQL Server with Data Replicator. - Require minimum level of SQL Server 2016 for Data Replicator instead of 2012. - Add date formats. Bug fixes: - Only check on itgentln007 when translations have been loaded at least once. - Revert to english for errors during startup. - Correct type of exception itgenisr034. - Automatically convert binary file to text for CSV tables. - Fix Robaws paging issue on MobilityTypes. - Rename ActiveCampaign TrackEvent to TrackEvents. Version 20.1.11-BETA, released 2020-04-21. Enhancements: - Allow specifying data container on SQL transactions. - Improve error message itgensql201. - Improve clarity of error message when user is disabled in Twinfield. - ActiveCampaign: select site tracking white listed domains. Bug fixes: - Improve name matching on MySQL. - Nullify nullable dates returned by NMBRS as 01-01-0001. Version 20.1.10-BETA, released 2020-04-20. Enhancements: - Include non-primary key field value of 'field' in update on ActiveCampaign contact custom field. - Add value checks on TrackEvent insert on ActiveCampaign. Bug fixes: - Fix ITEM_CODE_ATTR error on TimeTransactionsExtended data object. - Correct update on ActiveCampaign associations. - Improve measurement of rows retrieved. Version 20.1.9-BETA, released 2020-04-17. Enhancements: - Add "continue on first ... errors" to synchronize statement. Bug fixes: - Improve handling of UInt64 on MySQL. - Fix item field not correctly deserialized [ITGEN-5014]. - Change parsing of full qualified name in the case of schema.table. - Implement rebuild dropped ANSI SQL connection (server down or so). Also retry automatically [ITGEN-5008]. - Instruct users updating custom fields to provide a value for field, even though it is already set. There is no technical solution to solve this yet [SUP-5725]. Version 20.1.5-BETA, released 2020-04-10. Enhancements: - Raise clearer error when an ANSI SQL create table statement includes the Invantive SQL primary key column. - Upgrade to Teamleader 2019-10 API version. - Add event tracking to ActiveCampaign API (insert only). Bug fixes: - Fix itgengpr082 on synchronize with nulled values. Version 20.1.1-BETA, released 2020-04-08. Enhancements: - Add three SalesForecasts XML APIs of Exact Online [ITGEN-5014]. - Add consistency checks on completeness of catalog, schema and table. - More accurate determination of data container ID for ODBC-based data containers. - Add documentation to Swagger. - Allow for I18N messages indicating no access to Exact Online company. - Change default to return no rows instead of an error when the user is not autorized on Exact Online XML API. - Add paging and structure table names on Robaws. - Add paging to Robaws. - Add optimization for binary operators with one side null. - Add ADO.NET metadata tables to all ANSI SQL connectors. - Add error handling for ROBAWS. - Include catalog used in event log to ease debugging data cache repository resolution issues - Add payrollPeriodDataId on PayrollPeriodDataByEmploymentID__embeddedPayrollComponents. Bug fixes: - Fix itgenrst004 on FoxPro long data type. - Fix ignore memo values logic for offset problems. - Fix itgenclr009 on MySQL metadata discovery. - Fix Loket metadata retrieval [ITGEN-5012]. - Apply soft-limit throttle on Exact Online when configured lower than expected. - Retry on 429 HTTP exceptions on OData. - Enable query on SystemTableColumns@DataDictionary for SQL Server on ODBC. - Fix itgenclr009 on inner select with 20.0 - Avoid itgendch796 error when a table partition is obsolete but does not yet have versions. - Improve JIRA paging for Service Desk. - Do not display Swagger URL by default. - Lower-case email address. - Pass full connector name instead of short name to logging. - Fix connection to Multivers ODBC driver. - Fix use of Data Replicator stored on same platform as an active data container. - Revert synchronize from using batch to singleton inserts on ActiveCampaign. - Fix itgenrst007 on custom field options of ActiveCampaign account. - Fix itgenrst007 on custom field options of ActiveCampaign account. - Consider databases invalid when multiple data containers and at least one without an alias. - Evaluate true or null to true instead of null. - Fix Teamleader language name column name with superfluous space. - Avoid unnecessary itgenrst004 data integrity check error when the database data type is raw/object. - Fix wrong mapping of byte dotnet data type in some scenarios. - Fix SQL Server table lock escalation disablement for Data Replicator when used on table names with a space. - Show error when a database user has access to multiple repositories instead of recreating repository. - Fix synchronize not changing not null in target to null from source [ITGEN-5003]. - Remove check itgenase132 which can be triggered from Oracle metadata discovery. Version 17.33.341-BETA, released 2020-03-27. Enhancements: - Update and delete support on ActiveCampaign. - Insert support on ActiveCampaign. - Limit maximum runtime of purge old incoming messages per execution to avoid excessive runtimes after a calamity. - Add default URL to Bridge Online connector. - Improved detection of invalid databases. - Exclude existing databases from the discovery databases file. - Prioritize database definitions when multiple are found. - Improve clarity of itgenoda221 message. - Fine-tune PostgreSQL datamodel upgrades to enable solely column nullable change when column is used in view. - Earlier checks on data quality. - Allow deviating row delimiter on CSV. - New RFC 4180 compliant CSV reader. Breaking change: column delimeter is now ',' instead of ';'. - Improve clarity of error message on CSV incorrect value data types. - Enforce rate limit of 1 call per 1100 ms for Roller. - Allow setting text encoding on FoxPro and AccountView. - Display 32-bit mode in version label. - Reduce garbage collection frequency. - Add hint to insert error when insert values and field names count differ. - Raise comprehensible error when current/Me on Exact Online returns a negative current division. - Improve search speed of table names. - Assign logging level to HTTP request exception. - Allow specification of 20 dimensions and values on AuditEvents, even when not used for monitoring. - Update to .NET Core 3.1. - Allow incorrectly sized text in XAF files. - Extend maximum length of XML audit file tax registration identification for misbehaving applications. - More extended implementation for PIVOT. - Basic implementation for PIVOT. - Allow batchsize specification for bulk inserts from Invantive SQL. - Make message itgendch159 non-fatal. - Add investigation methods on ADO.NET metadata for ODBC v3. - Improve output queue handling of internettable. - Improve file access to FoxPro files when file is still open for by another program. - Improve file access to FoxPro files when file is still open for by another program. - Improve clarity of error message itgenpsr061. - Show source file for databases in tooltip. - Differentiate error itgenfrt003 for easier diagnosis. - Make pre-compiled expressions available through data dictionary to easier assess performance issues. - Additional auto-repair on Data Cache repository. - Drop Invantive maintained views on upgrade to ease upgrades with platforms such as PostgreSQL. - Optimize away IS NOT NULL and required field. - Include data type in itgenrst004 error message. - Add view dc_sessions to datacache service connector. - Add client sessions table for improved check on non-concurrent use. - Include auto-repair on itgendch682 and itgendch683. - Fine-tune SqlException with incorrect certificate setup. - Include data type in string representation of parameter list to aid analysis. - On SQL Server allow Data Replicator to use a deviating retry interval and count upon failed connections. - Increase default number of retries for connection loss. - Add connector attribute minimum-connection-timeout-sec on ANSI SQL and backing-minimum-connection-timeout-sec on Data Replicator. - Force SSL data tansport on MySQL, PostgreSQL and SQL Server and increase connection timeout from 15 to 60 seconds. - Register error code for Oracle exceptions. - OData/EDM: retrieve better metadata, added SharePoint custom table functions. - Add retry on BadGateway HTTP error on OData sources such as Visma.net. - Allow scheme in Jira server name. - Merge two Jira providers so use on desktop is possible now too. - Add parallel download to internettable. - Reduce memory footprint for large internettable queries. - Add parent URL to output of internettable. - Extend unsigned int16/32/64 support. - Improve handling of closing connection problems with MySQL in edge cases. - Differentiate error message itgenoda046 on OAuth failure depending whether on log on or later on during the session. - Allow option to ignore write errors to HTTP disk cache - Add hint when PostgreSQL user is not properly authorized. - Add more fields to internettable. - Add bytes received and depth to internettable. - Explicitly cancel ANSI SQL database commands that remain running due to ADO.NET driver bugs. - Ignore Timeout when disposing ANSI SQL connection on a partially fetched result set; might occur on MySQL. - Add internettable table function. - Give hint for possible alternatives data containers on itgendch070. - Auto-create data container ID on downloading replicator messages. - Always return error code from Roller. - Add Jira provider. - Raise error when fetch single retrieves no data. - Reduce maximum memory footprint of Data Replicator on disk caches. - Return Exact Online errors as user type errors. - Retrieval difference in date/time notation between platform and Invantive SQL engine using sys_context('USERENV', 'SESSION_TIME_OFFSET_SEC', 'alias'). - Allow multiple concurrent languages to be loaded and translated. - Integrate Microsoft Graph, Salesforce and PayPal in Invantive Cloud. - Make number of obsolete table partition versions to purge configurable as a ratio with actual work done on Data Replicator. - Add AccountView.net [ITGEN-4652]. - Reduce number of columns in DocumentAttachment on Exact Online XML. - Option to exclude Twinfield companies which are templates. - Aggregate exceptions on XML-based providers across partitions before returning. - Re-authenticate on Twinfield when parallel session is running. - Allow multiple SQL batches in Startup SQL on Cloud [ITGEN-4641]. - Make execute script available to all license forms, including free - Use error code for soap:Sender. - Yield return on Twinfield Process XML endpoints to improve performance and minimize memory pressure. - Improve clarity of error when a field can not be found in an ANSI SQL-based platform. - Improve hint of itgenefn003 to include more alternative column names. - Improve error message itgendid044 when the source by accident uses the wrong culture. - Provide hint on alternative database names when an invalid one is specified. - Add variant on check on row contents against metadata. - Improve performance of parsing RFC3339 dates. - Add Roller in Invantive Cloud. - Rename Yuki tables. - Yuki: all accounting APIs. - Roller provider. - Support SOAP v1.1 error messages such as on Twinfield. - Twinfield: BudgetByCostCenter, BudgetByProject. - Improve error message on missing user/password. - Include date/time (UTC) in error message window. - Ignore invalid connector names in discovery instead of raising itgenscg001. - Ignore 'alter persistent cache refresh' when no table partitions have been registered instead of raising itgendch637. - Make skip of client-side cacheable tables with Data Replicator configurable. - Make default use of ODS in Data Replicator configurable. - Alter connection label for Invantive Query Tool and others. - Improve performance of Invantive Control tables. - Improve performance by caching parsed SQL statements. - Improve performance of GenericDataComparer. - Improve performance of camel casing. - Improve date/time and currency support on FoxPro. - Improve OData4 connector for Bridge Online. - Differentiate between OData 3 and OData 4 error responses. - Bridge Online connector. - Increase default packet size on SQL Server from 8.000 to 32.767. - Reduce runtime of queries yielded the data partial from their result set on SQL Server. - Foxpro: Add support for reading long, binary double and auto increment field values. - Fine-tune whether to retry on HTTP 500 errors from AFAS Online. - Allow ignoring milliseconds of absolute time when considering file replacement. - Accept some timestamp difference when replacing timestamps on files. - Disable Data Replicator on synchronize statement. - Ensure lock escalation is disabled on Data Replicator with SQL Server starting repository version 24. - Disable lock escalation when creating a table on SQL Server. - Do not cache failures of DNS resolution and try multiple times. - Fine-tune messages for locations where Invantive services are not available. - Add consistency checks on Data Replicator. - Make minimum number of remaining API calls till hard limit configurable. - Make PostgreSQL logging configurable, improved DDL generation. - Allow database group names to be empty. - Specify which Exact Online table function parameters are required. - Differentiate between Invantive SQL and MySQL semantics of non-nullable strings when handling the empty string ''. - Improve performance of bulk loading by skip when the result set is empty. - Add support for HH24:MI time format. - Output PDF wage slips on Loket.nl connector. - Measure HTTP disk and memory cache use in terms of size in bytes. - Yield results in Teamleader. - Enable configuration of page size for Loket.nl payrolling REST connector. - Improve naming of connectors. - Clarify license encryption error message itgenale013. - Add environment_id to Data Replicator, while removing active version last from the repository. - Improve error message when a named parameter is specified twice in a table function. - Enable production use of Loket.nl REST connector. - Enable replication of table functions with required but defaulted parameter values. - Excel date time formatting. - Make maximum metadata cache age configurable. - Improve boot-strap installation. - Add unreliable connection simulator for OData and REST connectors. - Retry on timeout and other hard connection loss with Swagger-based connectors such as Visma.net. - Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure. - Show different error code itgenexl109 when Exact Online returns an Object Reference not Set itself. - Print directories scanned by FoxPro in error on object not found. - Print better hint than NullReference when the custom exception function returns no exception. - Provide more fine grained replication progress than table and partition [ITGEN-4507]. - Include table name in message itgendch380 - Include agreement code in message itgendch380 - Add partition ID to message itgendch384 when trickle loading is skipped on Data Replicator. - Ignore more disk cache encryption problems. - AFAS: server side filtering: support BETWEEN. - Allow specifying columns to ignore on checking if a row should be updated. - Allow specifying columns to ignore on checking if a row should be updated. - Check that a unique AccountView data dictionary file DCT_FILE can be found. - Enable specification of the Bridge Online client IP address list. - Allow specification of Bridge access clients. - Measure duration of encrypt/decrypt operations for HTTP disk cache. - Merge provided execution options with pre-defined cache settings to increase proliferation of disk cache root directory. - Reduce length of disk cache file names. - Compose name from family name when not explicitly available. - Raise clear error when the number of columns changes for trickle loading is different between old and new data set. - Make recursing into FoxPro database directories optional. - On FoxPro allow use of non-available database directories as long as one exists. - Enable use of acceptance and test environment on AFAS Online. - Add duplicate handling order registration detection for connectors. - Add TeamLeader view DealNotesAll. - Allow disk cache root folder to be specified as execution option. - Rename Exact Online hour status code domains. - Add Teamleader V1 APIs invoice_reminder_templates_by_invoice and invoice_reminder_template_content_by_invoice. - Add new API V2 Teamleader fields and tables such as withholdingTaxRates, Products, Quotations, LevelTwoAreasByCountry, EventAttendees and EventLinks - Enable use of tagged parameters. - Add retry support to OData POST requests when retry is on to cover 429 recovery for Teamleader. - Add domain ProjectTimeTransactionStatuses to Exact Online. - Consider Invantive code parse errors of encrypted disk cache also as a signal for retry. - Register date of last freshness check in Data Replicator repository to ease analysis of trickle loading. - Add repository checks that version numbers are handed out in increasing order. - Add SalesOrderLinesBulk to webhook tables. - Improve TOTP to allow generation of shared keys. - Add Loket.nl views for leaves, wages and working hours. - Provide clear error when the AFAS token does not have the expected format. - CBS: Enable paging and retrieval of more than 10000 rows. - Optimize retrieval performance of metadata from Exact Online providers - Added readme.md - Improve performance by larger percentage of ConstantExpressions by avoiding conversion to object. - Extend httpdownload table function by output of content-type header. - Display a default label for partition when connector has none. - Add Foxpro data types. - Allow Loket.nl REST connector to clean data when Loket.nl swagger is invalid. - Improve name resolution of Foxpro tables. - Invantive Cloud SQL Editor. - Improve performance by more scenarios in which a coalesce forwards to the use of a server-side filter. - Make RLS ACL roles unique and upper case. - Function based authentication. - Include global state in event arguments to improve window ownership. - Clarify error message when Data Replicator is not licensed [SUP-805]. - Show user icon. - Retrieve connection info, access token, etc through API. - Sort OData filters on selectivity. - Allow specification of data container alias in SYS_CONTEXT for improved logging and analysis features. - Add, edit and delete databases. - Add analysis script for Teamleader incorrect custom field values. - Add ascii_to_blob / unicode_to_blob to enable Twinfield office/password encoding. - Display clearer context of SQL parse error. - Add flatten views to Teamleader for easier deployment on replication. - Enable forcing of custom field values to strings to aid analysis of number of wrongly typed values in Teamleader. - Improve message on import XML when loading fails. - Add provider attribute to specify whether to use Implict or Explicit encryption on FTPS. - Add row level security. - Make setting Oracle client information optional. - Allow specification of SQL statement to execute upon open and close of pooled connection. - Do not retry OData request when a HTTP 501 is returned, such as on 'select * from CommunicationNotes where statusdescription is null'. - Accept that a configurable number of CBS tables raise an error when loading metadata. - Increase granularity of deletes when purging orphaned facts using attribute orphaned-facts-delete-page-size-rows. - Allow check on connection pooling active on ANSI SQL connectors using SystemDataContainerProperties view. - Add picture for Exact Online user to be displayed in SystemDataContainers. - Avoid fallback to OAuth headless log on when Exact Online incorrectly reports a 401 Unauthorized during Code Grant Flow. - Add picture of user to SystemDataContainers as workaround for missing picture in SystemUsers. - Add 25 extra columns to SystemTables. - Add many fields to SystemProviders view. - Add display_order and category to SystemProviderAttributes view. - Allow specification of backing database bulk insert page size in rows and bytes for Data Replicator. - Add Mac OSX support. - Improve clarity of exceltable error messages - Allow collection of Data Replicator repository contents for support purposes. - Change redirect URL to https://exactonlineclientredirect.invantive.com for all Exact Online apps except Netherlands. - Include error code from nested exceptions in message. - Add analysis features for HTTP disk cache usage per connector in data dictionary. - Allow specification whether to compress and/or encrypt facts stored in Data Replicator disk cache. - Reduce length of HTTP disk cache files to more easily fit on length-constrained platforms. - Check on maximum length of file name and path combined. - Restrict number of times a user message is displayed in client editions. - Add Loket.nl REST views. - Reduce lookups on views for better performance. - Enable analysis of connection manager statistics in data dictionary. - Increase maximum number of rows to retrieve with free license from 1.000 to 20.000. - Include origin in obfuscated columns to be shown on error reporting. - Add FTPS support. - Add gzip and ungzip SQL function. - Add timeout options to FTP. - Retry on invalid JSON received through OData [SUP-431]. - Add custom fields on product, call and subscription for Teamleader V1. - Improve nameing of HTTP disk cache files to reduce length. - Allow use of disk cache with Data Replicator. - Split cache files for HTTP disk cache and Data Cache. - Allow specification of minimum needed freshness interval for partition versions to be selected in refresh. - Raise error when user tries to explicitly refresh a table or partition that isn't replicated yet [ITGEN-4345]. - Allow purge of orphaned facts on upgrades of Data Cache repository. - Log additional information fields to the audit trail dc_event_log of Data Cache. [ITGEN-4344] - Add refresh origin to table partition versions of Data Cache to allow prediction of whether pre-loading data is necessary. - Add api-url parameter to Mendix. - Make default primary key field name configurable per ANSI SQL connector. - Avoid long hang on log on to AFAS with invalid credentials [ITGEN-4314]. - Allow table function parameters without placeholders on Facebook API for better selection. - Reduce file I/O conflicts in massive parallel environments for backups of discovery database. - Performance: Rewrite of retrieval from database cache so we can stream the results. - Enable multi-tenant use of Data Cache objects within one database. - Improve resilience against Facebook rate limit errors. - Allow inclusion of retry mechanisms signaled through OData errors. - Memorize content type of HTTP requests. - Forward more filters on join sets for better performance on OData queries. - When Data Replicator version loading database fails on first version, purge that version too automatically. - Differentiate between maximum accepted and maximum desired URL length for HTTP-based platforms. - Add extra column to display documents of Exact Online. - Add Exact Online functions ThumbnailByUrl, ThumbnailByRow, AttachmentByUrl and AttachmentByRow. - Enable retrieval of BLOB content from native scalar requests. - Add view dc_fact_size_statistics_r for Data Replicator. - Rename Owner Company to Subscription Owner in Exact Online. - Give hint when on SQL Server the date tried to insert is outside of allowed value for SQL Server. - Retry on itgenoda039 for Exact Online [ITGEN-4173]. - Update Exact Online bulk APIs fields that support server-side filters. - Improve messages when Exact Online only returns partial data. - Improve XML Exact Online error messages. - Add views on Exact Online payroll APIs to ease replication. - Add new Payroll APIs to Exact Online connector. - Reduce minutely rate limit from 600 to 300 for Exact Online. - Upgrade components. - Improve performance by reduced use of DateTime.Now. - Improve performance of determining balance type of GL account on Exact Online. - Allow presence of not yet available connector names in database configuration files. - Check URL for maximum lengths. - Update Exact Online domain code values. - Update Exact Online XML data model. - Add table functions for Exact Online XML APIs for more fine-grained access. - Support retrieving child rows on Swagger operations: naming resolution. - Return number of transactions changed by Exact Online Upload XML instead of 0. - Support retrieving child rows on Swagger operations. - Default maximum length of partition code and name. - Add 'exists(...)' SQL-condition. - Display clearer message when Invantive Keychain file is empty. - Exact Online: add App Center APIs. - Improve retry mechanism on Exact Online when Exact Online crashes during retrieval of XML data. - Add sql%rowcount, sqlerrm and sqlcode pseudo variables [ITGEN-3366]. - Add SQL functions sqlcode, sqlerrm and sqlrowcount. - Add Visma eAccounting connector [ITGEN-1645]. - to_date and to_char functions updated to support RFC3339 dates. - Add SQL function excel_day. - Add SQL function months_between [ITGEN-4068]. - Add Data Replicator attribute 'facts-delete-page-size-characters' to limit number of bytes deleted per facts delete batch. - Add SQL Server bulk insert option 'bulk-insert-page-size-bytes' to limit size in bytes on top of existing limit in number of rows. - Enable use of connector-specific views in distributed databases. - Improve recognition of CSV date/time export by Google Sheets [ITGEN-4071]. - Add CaseWare and AccountView databases. - Set schema name to folder and correctly convert memo field values to long string on Foxpro. - Add support on to_date for date mask 'MM'. - Add hint to error message on unknown filter column on XML-based connectors. - Add Loket.nl REST connector [ITGEN-3870]. - Default user name and password of credentials container to the defaults of the data container when no other are available. - Improve handling of Data Replicator when the backend database fails. - Update Octopus connector. - Allow connector attribute specification of in-memory cache for event logs of Data Replicator - Create Octopus InvoiceLines, DeliveryNoteLines and BuySellBookingLines tables [ITGEN-4045]. - Octopus: Add BookYearPeriods table [ITGEN-4044]. - Provide company code table function parameter when running queries [ITGEN-4051]. - Add columns for company code and name [ITGEN-4050]. - More clearly log externally triggered errors such as SQL Server crashes in dc_event_log of Data Replicator. - Allow SQL syntax with 'except' as in "select t.* except col1, ..., coln" [ITGEN-3979]. - Add pre-defined views to Facebook connector. - Add Foxpro connector. - Add Firebird connector. - Allow specification of alias using @xxx for table and partition refresh. [ITGEN-4017]. - Add new bulk Exact Online APIs to trickle loading. - Add 18 new Exact Online bulk API tables. - Update Mendix connector. - Add Octopus connector [ITGEN-3613]. - Implement controltype, decimals and length for fields on AFAS [ITGEN-4008]. - Display partition code in error message [ITGEN-3990]. - AFAS Online connector: Subject, File and Version connector [ITGEN-2935]. - Include failing table name in itgenrst004 error. - Do not fail on invalid column name when dropping it. - Add AFAS Online connector [ITGEN-2935]. - Add connector attribute 'ignore-http-500-errors' for OData connector [ITGEN-3991]. - Simply null checks when one or both the operands are constants. - Allow use of PSQL variable as value on billing id, billing reference and set value. - Add partitioning on table functions on Swagger-based connectors [ITGEN-3963]. - Optimize SQL function execution. - Reduce registration time of connectors by 150 ms. - Reduce load time of Exact Online data model. - Reduce start-up time of Dummy connector by 50%. - Reduce time to initially load Data Replicator repository by 50%. - Add check on maximum length on databasecolumn constructions, as on ColumnSpecification. - Enable registration of billing ID using expressions. - Include SQL fragment causing error in error message. - Extend HTTP download in Dummy connector to enable more flexible online downloads such as JSON from secured web sites. - Allow specification of glschemeid on Exact Online XML General Ledger tables. - Allow configuration of maximum allowable age in seconds of Swagger specification disk cache. - Improve performance of XPath element splitting. - Unwrap XML OData errors. - Improve Data Replicator special repository upgrades. - Add Data Replicator attributes upgrade-force-execute, upgrade-force-repository-version-start and upgrade-force-specials. - Add connector attribute 'page-size-rows' to Visma.net. - Reduce number of rows per page from 5.000 to announced 500 rows. - Require use of Azure SQL Server S1 or better with Data Replicator. - Restrict number of audit events not only to a specific age, but also to number of entries. - Use default translations where available when a lock exception occurs during translating. - Add check that last used SQL engine version should at least be matched for Data Replicator. - Restrict maximum length of various Exact Online columns. - Add ensure view dropped and column dropped methods to ANSI SQL-based connectors. - Add data dictionary view SystemDataContainerReservedWords. - Allow installation of comment on PostgreSQL and Oracle. - Limit lengths of various Exact Online text fields. - Rename Data Cache repository columns to enable use on Oracle 11g: seconds_before_obsolete -> sec_before_obsolete seconds_before_droppable -> sec_before_droppable seconds_retention_forwarded_ime -> sec_retention_fwd_ime seconds_metadata_is_droppable -> sec_metadata_is_droppable date_trickle_approach_activated -> date_trickle_activated date_copy_approach_activated -> date_copy_activated date_smart_approach_activated -> date_smart_activated - Migrate boolean to char data types to ease portability of Data Replicator to less advanced backing database platforms. - Check values for insert and update before actual transport in Invantive SQL for adherence to metadata. - Validate rows before insert to match metadata. - Add data dictionary view SystemMessages. - Include automatic conversion between Char and string(1) dotnet data types. - Enable out-of-band messages for PRINT on SQL Server. - Register notifications from PostgreSQL. - Add generic handler for connector notifications. - Show clearer error message when implicit data type conversion for joins fails [ITGEN-3881]. - Limit number of table partitions obsoleted when partially refreshing. - Add checks to Data Replicator on not (yet) installed database objects. - Reduce time slot in which crash leads to inconsistent last active version registration and version creation. - Reduce memory allocations when checking row integrity. - Increase throughput of GLAccountClassifications XML API of Exact Online in scenarios with over 200 companies. - Aggregate errors found during consistency check into 1 error. - Increase maximum degree of parallelism for file operations. - Add connector attributes to ignore Exact Online XML no access errors. - Force regeneration of fact and history tables and logical views upon upgrade. - Check consistency of installed table columns with table specification after executing DDL statements. - Include name, type, nullable and origin of column in generated SQL DDL. - Add consistency checks between table partition and versions. - Add global support by basing times of Data Replicator on UTC instead of local time. - Show clear error when data downloaded for Data Replicator does not match specifications [ITGEN-3860]. - Extend logging field names of result set rows by their origin. - Retry HTTP timeout without payload as a Internet connection down with same retry mechanism. - Upgrade Salesforce connector API from 37 to 39. - Set partition for non-partition specific tables to 'DEFAULT'. - Add consistency check on Data Replicator when purging data. - Automatically have Data Replicator recreate facts and history tables when database object was removed by user [ITGEN-3836]. - Allow drop of Data Replicator partition without access to original partition [ITGEN-3821]. - Add paging on Visma .NET and all other Swagger-based connectors, preparing for 2019Q2 release of Visma.net. - Add application controls on minimum/maximum number of rows in a table partition [ITGEN-3835]. - Add Exact Online APIs PayrollComponents, ProcessWarehouseTransfer, WarehouseTransferLines and WarehouTransfers. - Structure table names for Visma.NET. - Add various statistics to Data Cache table partitions and versions. - Add Data Replicator sourcing_date column to store when a row was loaded from the original source. - Throttle Exact Online API calls according to rumoured new limits for short-time rate limits. - Add checks itgendch454 and itgendch455 to dc_warnings_r. - Add data dictionary view SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS. - Add manual purge of unneeded Data Cache incoming messages. - Add partition based rate limits [ITGEN-3810]. - Add to_boolean SQL function. - Allow specification of billing reference. - Clarify error message when object definition could not be found when switching to trickle loading. - Maintain statistics over time per table partition in Data Replicator repository. - Add check on trickle loading not being activated within 30 days for Data Replicator. - Add Facebook Marketing, Graph and Insights rate limits view. - Add COMPlus_DebugWriteToStdErr environment variable documentation for .NET Core. - Include more partition statistics on Exact Online for better performance of SQL engine - Add Data Dictionary view SystemTableFunctionParameters. - Add Facebook paging. - Add Facebook Marketing tables: AdCreativesByAd, TargetingSentenceLinesByAd, AdRulesByAd, CopiesByAd, LeadsByAd and AdPreviewsByAd. - Allow floats and doubles in to_number. - Add Facebook Marketing API tables AdInsightsByAd, AdKeywordStatsByAd, AdCampaignsByAdAccount, OwnedPagesByBusiness, OwnedAdAccountsByBusiness, OwnedAppsByBusiness, OwnedProductCatalogsByBusiness and SystemUsersByBusiness. - Show front-end and repository version numbers in Data Replicator error message when different. - Add new Exact Online APIs such as BankSubscriptions. - Display warning pop-up when a Data Replicator environment has tables not being maintained for too long time. - Include name of source table when an error occurs in Data Cache upgrading a facts or history table. - Add Facebook tables: ImpactingAdStudiesByAdAccount, AdInsightsByAdAccount and 8 others. - Add Facebook rate limit statistics table. - Support for table function parameters in Facebook. - Clarify error message when partition is not found. - Add Facebook tables AdPixelsByAdAccount and AdvertisableApplicationsByAdAccount. - Add IsLicensed to SystemDivisions for Exact Online. - Add support for retrieval of sub nodes in Facebook metadata. [ITGEN-3710]. - Add Facebook tables: AdCreativesByAdAccount, AdSetsByAdAccount, MyPublishedPosts, MyTaggedPosts, MyFriends, MyGroups and MySessionKeys. - Add photos, likes and businesses to Facebook connector. - Add Facebook table adStudies. - Include 2nd order dependencies only once on Facebook columns. - Add columns to Me on Facebook connector. - Add profile picture on Facebook connector user. - Simplify overall view maintenance for cross-country use of Exact Online with Data Replicator [ITGEN-3708] - Disable retries by default on SOAP-based connectors. - Only retrieve page number requested on Company.info. - Implement re-raise statement, only valid from within exception block [ITGEN-3690]. - Support MySQL and Teradata connector on non-Windows platforms. - Add automatic time correction based upon Internet time of Invantive servers. - Include fetch parameters in session I/O logging. - Add memory and disk cache to Swagger-based connectors [ITGEN-3674]. - Optimize SQL coalesce operator [ITGEN-3671]. - Load connectors from settings file. - Synchronize on identifying columns having all nulls [ITGEN-3681]. - Rename company columns to COMPANY_CODE and COMPANY_NAME for Visma.net. - Add synchronize support for Swagger-based sources such as Visma.net. - Allow generic provider-specific definition of partition name column. - Add trace native calls to Swagger-based providers. - Extend RateLimits view on Exact Online by several additional columns. - Add trace-native-calls setting to all SOAP-based providers such as NMBRS, Loket.nl and Company.info. - Added Exact Online DocumentAttachments and DocumentAttachmentsBulk tables. - Add EXPLANATION column to SystemProviderAttributes. - Add Exact Online tables EmploymentConditionGroups, PayrollTransactions and PayrollTransactionsByPayrollYear. - Avoid log on to customer 1 for Teamleader. - Add overdue warnings as events on Data Cache to make it easier to manage for users. - Display details of progress in Query Tool spinner. - Auto-adapt on Exact Online API gateway which seems to use two types of UNIX epoch times. - Increase resolution for refresh periods from days to seconds. - Add view to query currently known Exact Online rate limits per partition. - Add warning statistics on number of missed purges and obsoletions. - Add Swagger grouping tables. - Add day of week to_char format. - Improve message code on raise_application_error in PSQL. - Add Visma .NET provider. - Require metric value when using custom monitoring events. - Allow case-insensitive matching on service URL when retrieving OData service metadata. - Add tables ItemBarCode and EmploymentInternalRates to Exact Online. - Enable uploading across divisions of Exact Online document attachment files. - Display context where an error occurs in exceltable data. - Exclude settings.xml from session initiation procedure. - Add ISO week number date mask YYYY-IW. - Check Exact Online responses for inline error messages outside of standard. - Handle changed parameter value correctly; do not keep using the default value [ITGEN-3562]. - Add clone methods for partitions. - Reduce duplicate retrievals of partition information for better performance on ANSI SQL. - Improve performance of SQL Server data model discovery by factor 5. - Add data models. - Extend Data Replicator statistics. - Two-way synchronize SQL statement. - Sync table statement uni-directional way. - Require data container alias when using distributed databases. - Reduce startup time of connection manager by 50 ms. - Improve clarity of error messages when parsing Excel tables. - Extend userenv by various folders such as for Templates. - Display correct user name on Company.info [ITGEN-3477]. - Display results from CompanyInfo.nl consecutive pages and cache results [ITGEN-3478] [ITGEN-3476]. - Updated scopes for Teamleader API v2. Removed deprecated scopes. - Add CompanyInfo data model. - Restructure reading the WSDL SOAP definitions. - Add AdAccounts to Facebook provider. - Exclude short description from label in Log On Window when not present. - Add table partition columns to view dc_table_partition_version_r. - Store all discovery connections in settings-discovery.xml. - Differentiate error messages on Exact Online for easier recognition of rotating refresh tokens. - Add named table function parameters to Invantive SQL. - Default casing of Invantive SQL identifiers is upper case. - Add userenv sys_context variables: database_comment and database_short_description. - Add short one-line description to database groups and databases for better human recognition of groups and databases with codes as names. - Differentiate in logging between two types of view creation for Data Replicator. - Add documentation on how to use free fields on Items with Exact Online. - Register origin of database column for more meaningful error messages when using Data Cache. - Better naming of view columns in Data Replicator mode for PostgrSQL. - Show clear error when the backing database data model doesn't reflect the intended data model and can't be upgraded easily [ITGEN-3385]. - Memorize origin of Data Cache columns and show them in error message. - Add SYNC and COMPARE syntax to Invantive SQL. - Add explicit configuration of casing and length of logical view names and view column names. - Add default rule for GUIDs in Data Replicator when upgrading to new backing database model version with required GUIDs. - Update translations. - Add TransactionLineVATs and SubledgerTransactionLineVATS to XML Audit File Financial 3.0, 3.1 and 3.2. - Clarify error message on itgenttn159. - Simplify event monitoring on duration tasks. - Add columns to auditevents table in Data Dictionary for monitoring metrics. - Introduce string_split table function. - Improve performance of updating and deleting on the in-memory storage provider [ITGEN-2919]. - Enable insert ... values with multiple rows. - Add group function ZIP (blob expression, file name) [ITGEN-3251]. - Data Cache: allow providing partition mode when setting the seeding approach, so you can set all, the currently selected or a specific partition. - Add SQL statement 'alter session set billing id'. - Update translations. - Enable log on for Data Hub using a refresh token specified as command line argument. - Restrict maximum length of itgenrst009 error message. - Include additional license information in SystemLicenses view. - Reduce size of individual delete statements on obsolete table partition versions to improve reliability on platforms such as PostgreSQL which don't support paged deletes [ITGEN-3321]. - Update Exact Online data model for REST APIs: creditedsalesinvoices, OAuthScopes and extensions to SystemDivisions and Accounts for GDPR. - Add Exact Online domain view ReturnStatuses. - Pivot Open Exchange rate tables. - Include possible values for enumerable types in Invantive SQL error message. - Update translations. - Prepare encryption of HTTP disk cache. - Improve formatting of errors with nested errors by adding line feed. - Include label of division for which you might not have access on Exact Online in error message. - Include label of division in errors when you specify an unregistered Exact Online division. - Allow logical overall views with names exceeding 30 characters. - Parallellize disable and enable on webhooks [ITGEN-3233]. - Enable web hooks from set options approach statement. Keep loading completely when receiving no messages [ITGEN-2985]. - Finetune warning views of Data Replicator. - Add metadata to Open Exchange Rates provider. - Aggregate exceptions occurring during disable/enable webhooks. - Allow differentiation between generating JSON for trusted or untrusted readers. - Increase maximum size of result set to above 4 billion rows. - Add support for maintenance of webhooks when a data container other than Exact Online is also connected. - Remove remaining support for apiclientid, apiclientsecret and apiclienturl without dashes. - Add label to rows_affected column. - Implement manage webhooks statement [ITGEN-2985]. - Allow specification for Data Replicator of index facts and/or history tables. - Add cast SQL-function to cast values to another data type [ITGEN-3193]. - Check consistency of index names early on when creating tables on ANSI databases through Invantive SQL. - Limit index name length based upon underlying platform restrictions for Data Replicator. - Add set operator: 'union distinct on', allowing to match a union on specific fields. - Optimize the registration of web hook statistics when downloading the feed on clients [ITGEN-3063]. - Add Exact Online subscription owner data to Me view. - Add suggested filename for download an Exact Online backup - Fill ActionInProgress field in Exact Online backups table. - Avoid trailing underscore in custom field views of Teamleader. - Add provider attribute 'backing-maximum-length-identifiers' to Data Replicator to specify non-default maximum length of identifiers for a platform. - Add provider attribute 'maximum-length-identifiers' to specify non-default maximum length of identifiers for a platform. - Extend data dictionary model to allow differentiation between read-only partitions and read/write partitions. - Add support for JSON flattened output. Traditional format renamed to jsondataset. - Introduce new table function exceltable, allowing to read Excel files [ITGEN-3065]. - Remove leading and trailing '_' for custom field names in Teamleader introduced due to non-alphabet characters being used. - Combine consecutive set operators like 'union', 'union all' and 'minus' to improve performance with 100+ consecutive set operators. - Upgrade components. - Add optional specification of initial database on PostgreSQL log on window to simplify with AWS environments with no access to postgres and template1 database leading to PostgreSQL 3D00 error. - Allow synchronous and asynchronous backups. - Fix 'alter persistent cache purge obsolete table partition versions' not actually deleting rows when connected to multiple data containers [ITGEN-3145]. - Include event description in Data Cache's dc_event_log in addition to event code. - Allow using expressions as input for the JSONTABLE and XMLTABLE table functions. - Allow using expressions as input for the CSVTABLE table function. - Simplify aggregated exceptions for clearer error messages. - Include column name for which data type is missing in error message itgenfir003/4. - Retrieve cookies from logon dialog. - Clarify error message itgensql104 when no partition is selected for USE. - Switch to production release. - Update translations. - Add group functions First() and Last() [ITGEN-2754]. - Add more context to error messages on Teamleader invalid data in custom fields. - Add linefeed between attributes in settings.xml for easier manual maintenance. - Add row context when Teamleader or other OData sources return corrupt data, not matching the agreed upon metadata. - Add support for JValue in DataUtility conversion methods for better error messages on Teamleader corrupt data. - Include row data in streaming result set checks on individual column values for easier resolution. - Add serialization to string of a named array or spare array row. - Improve uniqueness of HTTP disk cache file when a Windows user uses multiple cloud accounts to the same platform. - Add Sample Dummy data source to Invantive Business. - Clarify error message itgendid170 about missing alias. - Register Data Container ID and Log On Code in HTTP response cache object to improve correct matching for re-use of disk caches. - Extend Invantive Business metadata and Invantive SQL integration. - Allow non-default casing column names on ANSI SQL providers. - Reduce number of alternative provider attribute names to avoid confusion with users. - Add number of HTTP disk and memory cache incorrect version and content counters to providers. - Improve CPU performance of SQL LIKE. - Reduce memory pressure when massively calculating API URLs. - Improve performance of file name determination by factor 10. - Improve performance of parallel MD5 calculation for HTTP disk cache. - Cache Teamleader custom field definitions for 1 hour on disk for better performance under repeating connects. - Add SQL_VARIANT SQL function. - Add auto-maintained indexes on in-memory storage provider. - Determine result set statistics on demand. - Improve performance by streaming row checks. - Streamed reading for ANSI SQL providers, like SQL Server and Oracle. - Reduce CPU load due to compression of result sets. - Use default user name and password when mode is read only. - Check on presence of user and password/secret for Loket, NMBRS and Visma Severa. - Clarify error message on Teamleader API group authentication. - [ITGEN-3052] Add drop table support on MySQL. - Add SQL function 'sign'. - Change database data type of flags in dc_settings from char to varchar for better MySQL. - Improve error message when repository view can not be installed of Data Cache. - Add data dictionary views 'systemcatalogs' and 'systemschemas'. - Add SQL function 'basename'. - Update EDIFACT drivers. - Add Outlook data model documentation. - Add PSQL "alter data dictionary set ..." statements. - Support encrypted connection strings when connecting to Data Replicator/Data Cache from a DDL statement. - Include attributes as fields on XSD simple type extensions. - Add ItemTranslations and GLAccountTranslations to Exact Online XML API. - Add data dictionary provider connection string and encrypted to database definition [ITGEN-2832]. - Allow explicit column specifications with 'create or replace table'. - Add execute native to PSQL [ITGEN-2963]. - Add dbms_lock.sleep PSQL procedure [ITGEN-2964]. - Add execute immediate INTO clause to PSQL. - Add PSQL go to label and support <