Invantive(R) SQL
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: 08/04/2021 09:24:06 (UTC, deploy002)
Version: 20.0.148
State: Production
MSI Product ID: 24467287-923b-4dfa-a638-3992c9af298e
Manufacturer: Invantive Software B.V.
Brand: Invantive
Copyright: (C) Copyright 2004-2021 Invantive Software B.V., the Netherlands. All rights reserved.
Category: Business
Software Requirements:Included Components:
Bug fixes: - Fix itgenvsa006 on log on to Visma Severa. - Fix NullReferenceException on SOAP-based providers without partitions. Version 20.0.145, released 2021-03-01. Enhancements: - Allow specifying a file path as (temporary) location for the Swagger specification. - Allow specifying a file path as (temporary) location for the Swagger specification. Bug fixes: - Fix to_char on dates with format yyyy-mm-dd hh24:mi:ss. Version 20.0.143, released 2021-02-16. Enhancements: - Check off incoming messages when doing a full copy Version 20.0.142, released 2021-02-12. Enhancements: - Add messaging tables to Invantive Cloud. - Make maximum number of webhook management errors on Exact Online configurable from the default of 500 - 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. - Add alternative error format to ActiveCampaign Bug fixes: - Enable retrieval of account information even when the current Exact Online company is not listed in available companies - Fix Data Replicator event log on table in Query Tool. Version 20.0.141, 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. - Reduce to new minutely rate limits on Exact Online. - Differentiate translation cache file formats. Version 20.0.140, released 2021-02-01. Bug fixes: - Rename Loket.nl EmployersByUser to EmployersByUserId. Version 20.0.139, released 2021-01-20. Enhancements: - Improve message itgengpr012. Bug fixes: - Fix "value cannot be null" on Loket REST Version 20.0.136, released 2021-01-12. Bug fixes: - Fix itgenefn003: The field with name 'ASSET_CODE_ATTR' is unknown.. Version 20.0.135, released 2021-01-08. Enhancements: - Raise itgeneor234 instead of invalid_request when Exact Online API servers can not handle request for new refresh token. Bug fixes: - Backport defaulting of Contact ID in Exact Online goodsdeliveries. Version 20.0.134, released 2021-01-04. Bug fixes: - Correct incorrect SQL dates. - Fix ArgumentException on query object. Version 20.0.132, released 2020-12-28. Enhancements: - Default sorting on listagg. - Include Exact Online company in itgeneor228 error. - Handle SSL failures on OData as a non-connection signal Bug fixes: - Fix length overflow on FINGER_PRINT of SQL statement in SQL Area. - Fix Teamleader V1 API product_suppliers returning incorrect contents. - Disable server-side filtering on GLAccountsBulk.Code. Version 20.0.128, released 2020-12-04. Enhancements: - Translate 'Forbidden - The chosen User division is not within division scope.' to an error code. Version 20.0.127, released 2020-11-30. Bug fixes: - Give hint on unknown table. Version 20.0.124, released 2020-11-27. Enhancements: - Improve determination whether HTTP download through INTERNETTABLE is binary or text depending on MIME-type. - Use token instead of envid when envid is not available on AFAS. Bug fixes: - Make GetObjectMetadata more thread-safe - Add Period column to NMBRS table CompanyWorkCosts. Version 20.0.118, released 2020-11-18. Bug fixes: - Fix error on missing column and invalid column name when updating Knack. - Add missing catalog to Wikipedia. - Do not throw a confusing exception when a table was not found by its name. - Do not raise itgensql417 when no alias is used on the facts data source for Data Replicator. Version 20.0.117, released 2020-11-13. Enhancements: - Check privileges on AFAS environment. - Include classification level 9 and 10 in Exact Online XML API view glclassificationmemberclassifications. - Make SQL comments valid SQL statement - Simplify GUI action on event registration for Data Hub administrators. - Automatically ignore rule 20 (recursion) when the XML path is explicitly requested. - Add check itgensql417. Bug fixes: - Fix object name resolution when using an escaped object name. Version 20.0.114, 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. - Add default ordering on AFAS. - Avoid incorrect nullable check on partition name on SystemPartitionTags@DataDictionary. Version 20.0.113, released 2020-11-06. Enhancements: - Drop obsolete Loket table JobApplicantsByEmployerId. Version 20.0.112, released 2020-11-05. Enhancements: - Retry on several SQL Server errors such as deadlock. - Enable configuration of maximum number of FoxPro errors per table using max-table-memo-value-errors - Fine-tune determination of data container ID on SQL Server Version 20.0.111, released 2020-11-04. Enhancements: - Only default to encrypted connections for non-discovered SQL Server databases - Extend length of Teamleader forename. Bug fixes: - Assume the date format yyyy-MM-dd is local time when converting text to a date/datetime. - Fix HTTP download not returning contents as text when XML or JSON. Version 20.0.110, released 2020-11-02. Enhancements: - Enable configuration of maximum number of FoxPro errors per table using max-table-memo-value-errors - Allow ignore of IO exception on reading FoxPro memo value. Bug fixes: - Ignore exceptions on canceling SQL commands. - Fix OData providers not returning any data when filters exceed maximum allowed length. Version 20.0.108, released 2020-10-29. Enhancements: - Add column to view dc_table_partition_versions for analysis of itgendch808. Bug fixes: - Fix like optimization on fields with leading or trailing spaces. Version 20.0.107, released 2020-10-22. Enhancements: - Increase freemium limit from 20.000 to 100.000 Version 20.0.105, released 2020-10-21. Bug fixes: - Fix bug on KDBX errors raising null reference. Version 20.0.103, released 2020-10-19. Bug fixes: - Unpack CData sections correctly in XML table. - Fix passing parameters into Nmbrs Version 20.0.101, released 2020-10-15. Enhancements: - Add InvoiceLinesById and InvoiceGroupedLinesById to Teamleader Bug fixes: - Fix nullable fields. - 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. Version 20.0.100, released 2020-10-13. Enhancements: - Avoid integrity checks failing on Exact Online PlannedSalesReturnLines due to data corruption in some divisions. Bug fixes: - Avoid itgenodr007 when cleansing Exact Online field data - Fix wrong calculation of OData URL filters Version 20.0.99, released 2020-10-12. Enhancements: - Increase default of number of parallel Internet downloads to twice the logical CPU count. - Allow ignore of web retrieval errors on httpdownload@datadictionary - Allow cleansing of data on Exact Online broken APIs - Include context on line number of CSV file processed when an error occurs in csvtable executing. Bug fixes: - Fix data parse error on yyyy-mm-dd. - Remove unusable endpoint V1.contact_addresses. Use V1.contact instead. - Make obsoleted Exact Online columns nullable. Version 20.0.97, released 2020-10-06. Enhancements: - Raise more meaningful error than itgenclr075 when someone tries to select a partition on Oracle. - 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. Bug fixes: - Avoid error on Loket regarding boolean header. - Do not raise error when length is specified of byte array. Version 20.0.96, released 2020-10-01. Bug fixes: - Removed fields removed in Exact Online due to performance issues on GetMostRecentlyUsedDivisions. - Fix error on Loket view EmployerNotifications - Improve Oracle date format matching. Version 20.0.94, released 2020-09-25. Bug fixes: - Improve Windows 10 detection. - Correct billing name for Exact Online to avoid duplicate partition use reporting. Version 20.0.91, released 2020-09-15. Enhancements: - Add handling for Exact Online new data scopes. Bug fixes: - Fix database numbering on Bridge Online connector Version 20.0.89, released 2020-09-11. Enhancements: - Add quotations V2 table to Teamleader on 20.0. - Additional V2 quotation line information on Teamleader. - Move Yuki to Visma group. Bug fixes: - Fix NRE on Nmbrs when determining data container ID. Version 20.0.88, released 2020-09-10. Enhancements: - Add hint on NMBRS token. Bug fixes: - Enable use of Invantive SQL on Exact Online division 1 with missing Creator. Version 20.0.87, released 2020-09-07. 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. Bug fixes: - Make InternetTable table function more resilient when returning results partly [ITGEN-5194]. Version 20.0.86, released 2020-09-05. Enhancements: - Consider www.acme.com and acme.com same host for internettable table function. Bug fixes: - Avoid itgentln007 when switching from UI language. Version 20.0.84, released 2020-08-31. Enhancements: - Increase default command timeout for ANSI SQL-based connectors to 300 seconds. Bug fixes: - Fix broken paging on CustomerInvoices for Visma.net. Version 20.0.78, 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 - Differentiate data container ID for NMBRS depending on first debtor. - Add views for 18 en 54 weeks of Teamleader hours. - Add check itgengpr104 and itgengpr103 that partitions are provided with select specific partitions. - Add check itgenvnt008 on Visma.net that at least one company is available. Bug fixes: - Reduce memory allocations on Swagger cache. - Do not add natural key to error message when already present near end of error Version 20.0.76, released 2020-08-18. Bug fixes: - Return Exact Online currencies for Invantive Business currencies table. - Fix data issues in Invantive Business documents and transaction lines. Version 20.0.67, released 2020-08-17. Enhancements: - Relocate Roller API. - Improve purging of died sessions on Data Cache repository. Bug fixes: - Avoid StackOverflow on event log purge after more than 35 days of inactivity - Make color nullable in stages of ActiveCampaign. Version 20.0.64, released 2020-08-06. 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.0.52, released 2020-08-05. Enhancements: - Log reflection type loading exceptions. Version 20.0.50, released 2020-07-28. Enhancements: - Add new_time SQL function and support a wide variety of time zones Bug fixes: - Invantive Control formulas returning unexpected result 0 [ITGEN-5152]. Version 20.0.49, released 2020-07-25. Enhancements: - Add remaining migrate endpoints. - Teamleader: cache Migrate ID endpoint results indefinitely. - Teamleader: Add Migrate ID endpoint. 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 - 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. - Fix caching of ExactOnline document attachment files (non-bulk) - Confluence URL fixes. - Confluence URL fixes. Version 20.0.48, released 2020-07-08. Bug fixes: - Visma.NET rate limiting and paging - Fix parallelization bug where faulting producers would end up the consumer to wait forever. - Correct description of page-size-rows. Version 20.0.45, released 2020-07-06. Enhancements: - Make correction of invalid dates possible using invantive-sql-correct-invalid-date setting Bug fixes: - Implement rate limit checks on Freshdesk. - Fix NMBRS views. Version 20.0.44, released 2020-07-01. Enhancements: - Add basic authentication to Atlassian products - Include text of inner exceptions in SQLERRM. - Add values to OData error - Add missing fields on Robaws. Bug fixes: - Backport of fix for NullReferenceException. - Avoid NullReferenceException in edge cases on OData. - Correct metadata for ecom orders - Reduce number of columns in Exact Online XML API ItemPrices. - Do not include error code twice in ActiveCampaign connector messages. Version 20.0.43, released 2020-06-26. Enhancements: - Add Loket.nl view EmploymentCompanyCars. - Improve error handling on Loket. - Add support for ignorable OData API server errors. - Add facility to ignore access error on Loket.nl REST connector. - Add support for ignorable OData API server errors. - Simplicate filtering - Display correct message on wrong password for Yuki. - Allow use of license keys split across multiple lines. - Add 17 new Exact Online tables and 400 columns - Update Roller connector. Bug fixes: - Phone number in Teamleader V2 contact telephones is optional. - Exclude non-processed payroll runs. - Fix error in Loket REST Swagger. - Update Loket.nl SOAP connector. - Avoid itgenrst007 on Employee Absences on Loket.nl. - Correct Yuki project balances. Version 20.0.40, 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. - Improve error messages Exact Online on EOL down scenarios. - 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. - Make split_type on ActiveCampaign campaign optional. - Make some fields optional on ActiveCampaign. Version 20.0.36, released 2020-06-04. Bug fixes: - Fix optimized join on Exact Online divisions - Re-enable itgeneor137 - Show partition codes with itgeneor131. Version 20.0.35, released 2020-06-03. Enhancements: - Improve error message when GL accounts are not accessible at all. Bug fixes: - Revert OData logic for like / not like. Version 20.0.34, released 2020-06-02. Enhancements: - Extend length of street to 120 characters for Teamleader despite UI limitation. - 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: - End Twinfield delayed requests when the previous HTTP request is somehow not terminated automatically upon expiry - Reduce use of IN for Exact Online OData queries. Version 20.0.33, released 2020-05-25. Bug fixes: - Fix visma.net typo. - Reduce number of columns on Robaws - Fix missing and/or duplicate rows in ROBAWS. Version 20.0.29, released 2020-05-24. Enhancements: - Add 300+ Visma.net APIs. - Increase default join-set size from 5.000 to 10.000. - Reduce memory consumption for Twinfield - Extend filter support on Twinfield [ITGEN-4894]. - Enable custom I18N files using the environment variable INVANTIVE_I18N_FOLDER - Improve determination of environment variable values on ASP.Net CORE - Improve determination of environment variable values on ASP.Net CORE. Bug fixes: - Avoid ArgumentException caused by handling another Exact Online REST exception. - Fix path on Swagger. - Fix changed page number semantics for Visma.net - Fix logging - 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] - Fix partition selection on Twinfield [ITGEN-4633]. Version 20.0.28, released 2020-05-21. Enhancements: - Add Teamleader views ProjectUsers and ProjectRelatedParties. Bug fixes: - Also retry on HTTP 503 errors with OData. - Include all errors of aggregate exceptions for Data Hub. - Allow SQL Server 2014 till January 1, 2021 Version 20.0.27, released 2020-05-19. Bug fixes: - Fix problem with Business for Visma.net. - Updated paging mechanism [ITGEN-5078]. Version 20.0.26, released 2020-05-18. Enhancements: - Add more check on internal crashes of Exact Online. - Re-add project_code_attr to itemprices on ExactOnline XML. - 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 Bug fixes: - Detect English version of no access to XML Exact Online. - Cache and sanitize fields - Correctly pass long values with L suffix in OData filters [ITGEN-5065] - Retrieve more metadata, correct data types not provided with Swagger - De-duplicate service URLs found during OData discovery. - Make Param_GLAccount for MatchSets, MatchSetLines, and all related tables a GUID [ITGEN-5060] Version 20.0.25, released 2020-05-11. Enhancements: - Reduce length of disk cache file names. - Reduce length of disk cache file names. Bug fixes: - 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. Version 20.0.23, released 2020-05-07. Enhancements: - Add sys_context iiid and iuid. - Add views to NMBRS. - Improve error itgenisr004. Bug fixes: - Align version detection on Azure SQL Server with on-premsie SQL Server. - Fix moved Exact Online REST endpoints: GLAccountClassificationMappings, OfficialReturns, ReportingBalanceByClassification. Version 20.0.21, released 2020-05-03. Enhancements: - 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. Version 20.0.20, released 2020-05-03. Bug fixes: - Fix data type of physical memory on Data Replicator. Version 20.0.19, released 2020-05-03. Bug fixes: - Fix startup problem on 2.0.18. - Show which connector can not register. Version 20.0.18, released 2020-05-02. Enhancements: - Differentiate discovered database per version. - Add registration of license code used for Data Cache to ease analysis of finger print issues - Add NMBRS views. - Improve message itgendch655. - 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. - Added ActiveCampaign table functions. Bug fixes: - Only check on itgentln007 when translations have been loaded at least once. - Revert to english for errors during startup. - Automatically convert binary file to text for CSV tables. - Fix Robaws paging issue on MobilityTypes - Rename ActiveCampaign TrackEvent to TrackEvents. Version 20.0.14, 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. - ActiveCampaign: Select, insert and delete contact tags, select site tracking. - 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: - Improve name matching on MySQL. - Nullify nullable dates returned by NMBRS as 01-01-0001. - Nullify nullable dates returned by NMBRS as 01-01-0001 - Fix itgenpae011 on Data Hub connections. - Fix ITEM_CODE_ATTR error on TimeTransactionsExtended data object - Correct update on ActiveCampaign associations. - Improve measurement of rows retrieved. Version 20.0.13, released 2020-04-17. Bug fixes: - Improve handling of UInt64 on MySQL. - 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]. - Fix item field not correctly deserialized [ITGEN-5014]. Version 20.0.12, released 2020-04-14. Enhancements: - Raise clearer error when an ANSI SQL create table statement includes the Invantive SQL primary key column - Add event tracking to ActiveCampaign API (insert only) Bug fixes: - 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]. - Fix itgengpr082 on synchronize with nulled values - Handle itgenrst007 for required dates filled with 0000-00-00 on MySQL. Version 20.0.11, released 2020-04-08. Enhancements: - Add consistency checks on completeness of catalog, schema and table. - More accurate determination of data container ID for ODBC-based data containers. Bug fixes: - Fix itgenrst004 on FoxPro long data type. - Fix ignore memo values logic for offset problems - Fix itgenclr009 on MySQL metadata discovery - Enable query on SystemTableColumns@DataDictionary for SQL Server on ODBC. - Fix itgenclr009 on inner select with 20.0 - Fix itgenase118 error when no where clause is present on ANSI SQL. Version 20.0.9, released 2020-04-05. Enhancements: - 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. Bug fixes: - Improve JIRA paging for Service Desk. - Avoid itgendch796 error when a table partition is obsolete but does not yet have versions. Version 20.0.8, released 2020-04-04. Enhancements: - Allow use of aliases for connection string key values to fix PostgreSQL SSL mode configuration. - Add paging and structure table names on Robaws. - Add paging to Robaws. Bug fixes: - Do not display Swagger URL by default. - Pass full connector name instead of short name to logging. - Fix connection to Multivers ODBC driver. Version 20.0.7, released 2020-04-03. Bug fixes: - 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. Version 20.0.6, released 2020-04-02. Enhancements: - Add optimization for binary operators with one side null. Bug fixes: - 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. Version 20.0.5, released 2020-04-01. Enhancements: - Add ADO.NET metadata tables to all ANSI SQL connectors. - Paging, use test environment, table and field naming, type enumeration. - Add error handling for ROBAWS. - Robaws provider. - Add payrollPeriodDataId on PayrollPeriodDataByEmploymentID__embeddedPayrollComponents. - Add employment ID on PayrollPeriodDataByEmploymentID__embeddedPayrollComponents. - Include catalog used in event log to ease debugging data cache repository resolution issues Bug fixes: - 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]. Version 20.0.3, released 2020-03-30. 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. Bug fixes: - Fix update issue on ANSI providers. - Remove check itgenase132 which can be triggered from Oracle metadata discovery. - Handle dates returned as doubles from Excel. - Avoid errors. - Differentiate error itgendch676 depending on completed or incomplete. - Correct Roller metadata nullable property for GL code. - Make description on V2 time tracking optional. - Fix NullReferenceException when running query on ThumbnailByUrl on Exact Online. - Translate tooltip of databases. - Fix Visma.NET logon. - Better determine data type when using null value columns. - Remove Exact Online API BankAccountsBulk. - Improve error when Exact XML can not be accessed by an accountant. - Add handling for null data type in coerce. - Fix nullable property of name on Locations for Roller Leisure. - Reduce lifetime of AFAS Online metadata cache from 24 hours to 10 hours to reduce incident reports. - Allow never expiring gift cards in Roller. - Fix character set encoding for AccountView Euro. - Differentiate progress messages between SQL and PSQL. - Avoid "No database selected" error on MySQL due to order of closing data reader and command for better performance. - Change default SSL mode for MySQL from VerifyFull to Required. - Fix Teamleader issues with duplicate parameter. - Fix Teamleader V1 APIs not passing page number and size [ITGEN-4922]. - Full qualify the call safe name [SUP-3825]. - Increase size of phone numbers in Teamleader to 30 positions. - Fix duplicate Swagger table names [ITGEN-4909]. - Fix comparison bug with greater than or equals and less than or equals. - Move minimum-text-length backward when multiple connector attributes are present. - Add missing converter for char when auto-casting. - Rename Exact Online table SupplierItem to SupplierItems to reflect multi-row contents. - Fix itgenpae003 error on Exact Online for minimum-text-length. - Add check on number of numbered table function parameters. - Fix NRE on joins resulting in null [ITGEN-4817]. - Fix broken coalesce [ITGEN-4819]. - Provide list of languages in preferences when not logged on. - Avoid re-use of metadata structure. - Dynamically check which fields are available from ADO.NET metadata. - Add rowversion data type SQL Server support. - Capture 404 error on ItemExtraFields. - Include language on XAF. - Improve handling OData array responses. - Do not use $select on Item Extra Fields with Exact Online to avoid HTTP 404 error. - Count number of required table function parameter values instead of all to determine whether all required table function parameter values have been provided. - Add missing SystemSqlPrecompiledExpressions data dictionary table. - Add missing SystemSqlPrecompiledExpressions data dictionary table. - Allow use of decimal as input for int64 in combination with itgenrst004. - Fix connectretrycount [INTERVAL]. - Avoid loading OAuth background provider in slot reserved for Last Resort connector. - Display error message itgencmr004 and itgencmr089 with translation. - Small OR evaluation optimization. - Do not include settings.XML files with invalid elemtns in database list. - Fix grouping logic where one row too many was returned. - Exists does not forward server-side filters [ITGEN-4749]. - Include more context in message itgeneor137. - Clarify error message of OData HTTP servers. - Avoid connection leak when an error occurs on validation of the Data Replicator repository. - Fix retrieval of DNS records. - Make tinytext and mediumtext nullable by default on MySQL due to different semantics. - Enable Invantive maintained tables with int64 rows on MySQL. - Add missing 't' in mapping .net data type int64 and uint64 to an identifier. - Enable replication of tables with MySQL uint16, uint32 and uint64 data types. - Fix split of escaped fully qualified names such as on ODBC with some Microsoft Access drivers. - Fix parse error on ODBC connection string key value in the format {VAL;}. - Made several Roller fields optional. - Fix data corruption bug doubling the number of rows returned. - Add license and object property checks on synchronize statement. - Show correct error when table does not exist. - Fix ArgumentException on exists. - Fix discovery showing username and password login for OAuth client credentials providers when it shouldn't. - Use database casing instead of Invantive SQL casing when inserting into ANSI database. - Fix Twinfield itgensop034 error bridge v11: oap:Sender, Your logon credentials are not valid anymore. Try to log on again., code 103, source: SelectCompany. - Avoid logging on MySQL bogus_table not existing. - Include GUI module in request for user messages. - Avoid unnecessary spaces in version label in Data Hub. - Fix VatReturnStatus table date format error. - Remove support for OData batch insert on Exact Online since this is no longer supported by Exact. - Roller: update 'missing' endpoints. - Make Transaction Lines Type optional since some transactions in 2010 of one site have no value for it. - Remove superfluous spaces on Azure SQL Server reserved words. - Fix handling of tinyint on MySQL raising invalid cast. - Correct semantics of empty string to null for longtext columns on MySQL. - Handle reserved words on MySQL which are presented space separated instead of per row. - Correct AccountView data types. - Fix logging on to Bridge Online provider. - Reduce SQL Server default packet size back to 16.000 to increase compatibility with SSL-encrypted connections. - Allow specification of connection string properties which are optionally provided by Invantive SQL even when the casing is different. - Do not check that name is set when ID is missing for a database in settings*.xml. - Raise error when alias is not provided on a distribute database with DDL statements. - Avoid NullReference instead of a decent error when a describe is done on a non-existing table. - Fix itgendch676 error on obsolete table partition on the Data Replicator repository due to intermediate bug of 17.32.106. - Fix date representation for filters on AFAS Online when date has no fractions. - Enable use of synchronize statement in PSQL. - Avoid NullReference error upon unsupported use of SQL in PSQL. - Improve data type detection for Visual FoxPro. - Make work_type optional for time tracking in Teamleader. - Prevent retrying if authentication fails. - Make PlanningSourceUrl of Exact Onine ItemWarehousePlanningDetails nullable. - Use correct partition filter for non-partitioned tables in Data Replicator. - Fix itgendch672 on replicating SystemDivisions. - Allow disable of PostgreSQL logging using environment variable INVANTIVE_PG_LOGGING. - Fix incidental divide by zero on opening new connection. - Give cast(null as type) the intended type instead of 'NullableType'. - Fix partition handling of Firebird connector. - Ensure that durations in PooledConnections of ANSI SQL-based connectors have matching data type between metadata and actuals for better use with Invantive Bridge. - Fix itgendcr007 with Data Replicator upgrades. - Fix Loket.nl view PayrollAdministrationTaxReturns. - Start retrieval on page 1 instead of 0 for Loket.nl REST connector. - Rename Loket.nl AchmeInsuranceContracts to AchmeaInsuranceContracts. - Fix loading multi-page result sets on Loket.nl REST connector. - Fix NullReference when running Invantive SQL insert without column list specification. - Add version_last to Data Cache table partitions to improve restart capabilities. - Use correct length of IV hash for Data Replicator disk cache encryption. - Fix StackOverflow on ANSI exception. - Avoid itgenrst007 when a null value is inserted in a required column stored in in-memory database. - Download Exact Online text documents in original format instead of HTML-ized. - Correct type of exception when metadata is not available. - Reset billing ID and reference when opening a new database. - Fix successful action not displaying correctly. - Do not remove too many webhook registrations when changing seeding strategy. - Reduce time taken to establish statistics on an Exact Online company. - Group Data Replicator retrieval and save to database in batches of 5.000 rows to reduce memory footprint. - Fix filtering issue. - Fix TranslateResource when fed with expression. - Correct logic of field selection [ITGEN-4551] - Avoid null exception with new Visma.net Swagger API definitions on query with 'Events'. - Swagger: Exclude array and object parameters since they are not supported. - Fix OAuth token retrieval on Visma and other platforms using the "token" property. - Forward execution options along more paths to allow proper disk cache root settings. - Forward execution options along more paths to allow proper disk cache root settings. - Shorten disk cache file names. - Ignore disk cache files which have an incorrect version number. - Improve compatibility of RSA keys between .NET Standard and .NET Framework. - Fix table column change issues Data Cache. - Reduce throughput on Teamleader to avoid rate limiting issues. - Correctly insert a slash when necessary for SOAP URLs. - Rewrite NMBRS URL for Sweden to the Netherlands without an error. - Avoid NullReference on Business providers for XAF and Exact Online. - Avoid NullReference when using Dummy for Business directly from Query Tool. - Allow tag_creator and tag_updater to be optional. - Avoid double inclusion of partition code in itgengpr012 error message. - Show error with alternative names instead of choosing the first match on ambiguous identifiers. - Avoid NullReferenceException during query on Exact Online for Business. - Ensure that Data Replicator repository is opened before retrieving metadata on views. - Fix error on missing partition code when connecting to Oracle RDBMS. - Performance optimizations, don't encrypt insensitive data. - In-memory storage provider registered twice. - Fix application of migration rule for MySQL single character strings otherwise raising "Truncated incorrect DOUBLE value: 'N'Z". - Parameters not forwarded on OData CBS.nl [ITGEN-4478]. - DataCache: don't loop when raising an error when connecting. - DataCache: don't loop when raising an error when connecting. - Fix data type resolution bug in Round, Ceil and Floor SQL functions. - CBS: use ODataFeed API to allow retrieval of more that 1000 rows. - Force reevaluation of the execution plan of Exists statements every time we query, to avoid caching. - Fix wrong evaluation outcome when an 'IF NOT EXISTS' with SQL or expression evaluating to a constant. - Correctly register default partition database() on MySQL when used with Invantive Data Replicator to avoid itgenerr050 error. - Foxpro: Use hash of directories used as DataContainerId. - Fix table name resolution on Foxpro. - Improve table name resolution for FoxPro connector. - Improve call-safe naming of objects for Firebird and FoxPro. - Correctly determine full qualified name for FoxPro connector. - Avoid missing parameters exception when going through OAuth with no OAuth configured. - Fix Unauthorized error in OAuth dialog. - Do not perform check itgenrst004 when new value of column is another column. - Fix itgenprr002 error when comparing nullable and non-nullable data types. - itgenobr024: The OAuth response does not contain a valid OAuth token: failedLogin('', 'Username or password is invalid. bij ophalen contacts after teamleader query tool use of 1 hour [ITGEN-4450]. - Make sysdateutc a constant for duration of one SQL statement [ITGEN-4471]. - Fix ADO.NET version resolve issue. - Wrong conversion on ascii_to_blob and unicode_to_blob. - Fix discovery of Teamleader (now also generates an OAuth-connected database). - Ensure deletion of obsoleted table partition versions for non-default data containers in Data Replicator. - Merge obsolete messages of Data Replicator. - Remove not-null requirements and fix NRE. - Avoid null reference when accessing Excel table. - Improve thread-safety. - Fix Collection was modified; enumeration operation may not execute on Data Replicator. - Correct data type of key for Teamleader custom fields to number. - Add label to opening balance in audit files view TrialBalancePerPeriod. - Split adding columns across more methods to lower the stack size. - Change default date format for Excel exports from US to EU format. - Fix use of expression as Excel file name. - Ignore itgenoda330 when no access privileges on a division [ITGEN-4452]. - Fix itgenoda136 with filter on modifiedsince for contacts and products on Teamleader. - Include correct environment code in data container ID on AFAS Online. - Not in returns 0 rows instead of 1 [ITGEN-4446]. - Data container ID uniek maken per AFAS omgeving. - Correct label environment for AFAS to read subscription number. - Fix XML metadata retrieval bug. - Fix wrong length on dates in XAF connector. - Fix resetting provider attributes on creating a new connection. - Reduce number of private methods to avoid obfuscation issues with FTPS. - Fix OData not in bug. - Add default translations for use in failing startups. - Correct casing of HTTPDOWNLOAD table function. - Fix Exact Online 501 errors for various fields. - Fix Exact Online 501 errors for various fields. - Disable server-side filtering on NetPrice of PurchaseInvoiceLines. - Recognize insert on Smtp@Mail without fully qualifying with catalog and schema. - Recognize insert on AuditEvents and other data dictionary views without fully qualifying with catalog and schema. - Fix "relation "Native.NATIVEPLATFORMSCALARREQUESTS" does not exist" error on ANSI SQL providers not recognizing native requests. - Restrict active service providers to those opened, which excludes Data Cache when not used. - Add workaround for HTTP 500 errors when retrieving metadata of some entities reserved for AFAS internal use such as Pocket_Leave_Balance. - Fix performance optimalization not always translating complex resources. - Avoid NullReference when shortening disk cache file path and no user name provided [ITGEN-4417]. - Cannot create and populate list type Invantive.Data.SparseArray. Path 'Data[0]', line 859, position 5 [ITGEN-4413]. - Add missing checks on parameter values for exceltable. - Include UOM in quantity of Exact Online time transactions. - Fix itgenclr003 when exporting OData-based result set to XML format. - Avoid itgenrst009 too long content when querying systemdatacontainerproperties@datadictionary for large accountancy environments. - Print label of data container in error itgendch160 [ITGEN-4409]. - Include user information from middle tiers such as Producer or Estate in connection state. - Clearer display of data type of missing column in Data Replicator. - Clearer label on Budgeted Hours in project WBS. - Enable use of disk cache on AFAS [ITGEN-4373]. - Avoid itgengpr085 consistency check failing on Swagger-based connectors due to missing data container ID. - Fix NullReferenceException occurring on Visma.net with 2019-06 specification. - Fix 31-12-1969 being returned as date instead of null on Teamleader. - Process % sign in decimal custom fields of Teamleader [ITGEN-4379]. - Make compliant to SQL Server 7 [ITGEN-4355]. - Correct PostgreSQL column definitions upgrade failing with missing execute statement. - Fix missing scale or precision on AFAS numeric columns [ITGEN-4369]. - Add database support for nullable char. - Fix rounding differences for amounts with more than 7 digits in balance lines on Exact Online due to error in XSD [SUP-444]. - Password not set when not already there in the connection string on ODBC. - ANSI: Do not get precision and scale for columns that are not a number on the .NET and database side. - Avoid creating backups of discovered settings. - Fix NullReferenceException when a HTTP 403 Forbidden occurs with ignore-http-403-errors set to true [SUP-437]. - Fix itgengpr083 on TeamViewer support request. - Fix date_forwarded not found in column list of Data Replicator download feed. - Hide Data Cache objects from Available Objects when not connected to Data Cache. - Fix itgenrst007 when retrieving data from Data Replicator in development. - Fix race condition when SQL engine runs in multiple threads. - Fix superfluous incoming messages not getting purged automatically. - Fix old Data Cache facts only getting partially deleted. - Fix NullReferenceException in Data Replicator on GetObjectDefinitionFields. - Fix missing deal item information on Teamleader [ITGEN-4168]. - Fix itgengpr083 error on too long URL for subsequent pages on Exact Online in specific scenarios [ITGEN-4326]. - Fix Exact Online XML query error with group by "itgenemd007: An element with the key 'ssf_year' already exists in a dictionary of String and Object." [ITGEN-4327] - Fix bug in deviating application-code for Data Cache tables. - Improve thread safety of SQL statement memorization by MD5. - Allow ODBC to not provide partition names. - Fix Facebook Marketing Insights automatic throttle. - Correct data types in all demo tables. - Fix several data context issues with Data Replicator in multi-threaded environments. - Improve concurrency of Invantive Bridge Online. - Allow length specification of byte array on MySQL. - Fix tinyint on MySQL to be int16 alike instead of byte. - Log on without alias [ITGEN-4271]. - Fix duplicate filters on OData and too long URL (itgengpr083). - Invalid OData filter when using server-side fields. - Uitroep itgengpr083: URL too long. Length: 3,201, allowed length: 2,800. [ITGEN-4234]. - URL length check [ITGEN-4152]. - Don't write $filter in OData urls when no filters present [ITGEN-4152]. - Update server-side filters for bulk APIs. - Fix itgendcr011 in Data Replicator when trickle loading GoodsDeliveryLinesBulk. - Fix itgenclr009 on PSQL parse "Incorrect number of arguments supplied for call to method 'Invantive.Data.ResultSet PassthroughSqlActionTable(...)". - Improve .NET Core compliance. - itgensql156: The evaluation indicates a field is returned, but the data doesn't contain a field. Only on ANSI SQL connectors [ITGEN-4160]. - Enlarge maximum length of previous context descriptions of PooledConnections. - Fix column name resolution in select ... except statements [ITGEN-4140]. - Correct outcome of Exact Online cost center / cost unit view (60+ views broken) [ITGEN-4131]. - Set deviating load table Accounts for AccountsBulk [ITGEN-4126]. - Fix data type of default dates in XAF 3.0. - Ensure that a slash is inserted in the service URL for NMBRS. - Fix Exact Online UserHasRights table function. - Fix PSQL variable error with (not) exists. - Wrong order of table function parameters Exact Online [ITGEN-4113]. - Fix PSQL catch and divide errors. - Correct data type of listagg even after implicit conversion [ITGEN-4089]. - Fix PSQL execution bug. - Octopus Excel UDF returns two values when company code specified, but all companies selected [ITGEN-4077]. - Only raise itgenoda278 on bulk insert on OData sources when there is no partition selected, but there is data to insert [ITGEN-4075]. - Avoid dropping a table partition version which is still active. - Allow empty titles on Teamleader V2 API deals. - Fix Exact Online $select=* issues on bulk APIs. - Allow dynamic parameters on range@DataDictionary. - Improved performance pushing predicates when having nested filters with OR predicates [ITGEN-4049]. - Wrong URL in sessionios for SOAP connectors [ITGEN-4037]. - Accounts is empty [ITGEN-4040]. - Make use of $select=* flexible [ITGEN-4043]. - Fix filtering on UDFs [ITGEN-4036]. - Do not raise error when column without data is requested. [ITGEN-3994]. - Properly escape JSON path that contains dots. - Exact Online GoodsDeliveryLines broken [ITGEN-4010]. - SQL Server: Precision and scale wrongfully set on character-based types [ITGEN-4001]. - Don't show Teamleader V2 APIs when using a V1 API key. - Use default field names when not connected to Data Replicator. - No data retrieved when division_code is specified in where. [ITGEN-3992]. - Fix data types in Swagger based connectors and SQL Server. - Allow multiple specifications of same column with server side filter with identical value on XML Exact Online APIs. - No data retrieved when division_code is specified in where. [ITGEN-3992]. - Make GL account optional in Exact Online GL classification members. - Incorrect retrieval of non-default reporting scheme code Exact Online GL accounts [ITGEN-3987]. - Fix broken IN when using characters [ITGEN-3985]. - Enable filter on SupplierCode in Exact Online without padding with spaces [ITGEN-3948]. - Make derived Exact Online columns on systemdivisions null when not all fields are retrieved. - Fix wrong table function parameter default added [ITGEN-3970]. - Insert on a single partition per time. - Fix char casting issue. - Measure partition use per billing ID and reference to avoid loosing partition use on a billing ID or reference. - Fix data type of Loket's DienstverbandenPerPersoon emailaddress [INTGEN-3966]. - Re-enable use of disk and memory cache by Visma.net connector. - Avoid NOT NULL field is NULL error on SystemProviderAttributes@datadictionary. - Fix broken bulk insert on OData: missing close boundary on change set [ITGEN-3951]. - Avoid "Value was either too large or too small for an Int32" on column link_og_id on Facebook AdCreativesByAdAccount. - Avoid error 'itgenerr083 Too few partitions selected for insert on 'ExchangeRates'' when there are no rows to bulk load on OData. - Fix Facebook connector AdCreative field object_story_id to also include underscore characters. - Correctly recognize UploadXmlTopics table on Exact Online. - Fix "itgenube113: The cache with recent find results could not be loaded. The cache has been re-initialized." [ITGEN-3594]. - Assign value to number of characters in Data Replicator table partition version. - Avoid NullReference when logging a message on Mac Data Hub. - Enable escaped paramter names like :[reference]. - Allow use of keyword 'reference' as a parameter name. - Avoid itgenrst007 when right-hand side of union operator is nullable but left-hand side is not [ITGEN-3907]. - Return 0 instead of null when no warning and/or errors exist in Data Replicator environment. - Fix database data type representation of XML boolean to exclude maximum length. - Fix Data Replicator for use on platforms with default uppercase identifiers - Fix maximum length of IsLicensed column in Exact Online systemdivisions. - Fix use on Oracle of Data Replicator with upper casing - Correctly close ANSI SQL data readers in error situations. - Use upper case by default on Oracle managed and native connectors instead of lower case. - Fix itgenlic547 when accessing Dummy connector data [ITGEN-3882]. - Fix superfluous itgendch461 warnings reported. - Use trickle loading even when there are solely Delete events. - Fix refresh on non-partition specific tables on partitioned connectors. - Fix race condition on determining data type. - Fix race condition in routing data requests from Exact Online to REST and XML connectors. - Use active flag in Data Replicator where Ready was still used. - Consider database data type varbinary as a blob instead of a string. - Fix System.Runtime not found exception [ITGEN-3857]. - Avoid error 'Missing log on code.' when leaving log on code box empty on Salesforce. - Fix Salesforce login. - Clear in-memory cache of DataCache when dropping tables, partitions, table partitions and table partition versions [ITGEN-3847]. - Retry on HTTP 504 Gateway Timeout returned by the Exact Online servers on /Me and logging on at exactly 3:00 AM UTC. - Fix itgenoda025 when Exact Online user has no access to division or data elements. - Fix NullReference when determining number of rows of previous table partition version in Data Replicator. - Exclude superfluous space from PostgreSQL delete. - Don't use trickle loading in Data Replicator when having less than 100 rows in the previous version. - Fill pseudo-columns for endpoints not returning data. - Delete facts from all versions of a Data Replicator partition when the partition is dropped. - Fix 'itgenclr003 Collection was modified; enumeration operation may not execute.' on mass parallel initial replication [ITGEN-3823]. - Fix Visma errors. - Add support for Exact Online's AccountInfo view with Data Replicator on MySQL. - Fix 'Missing log on code' on MySQL. - Fix upgrade scenario for Data Replicator missing guid on insert of event log. - Log Data Replicator deviating returned fresh rows from web hook fetch [ITGEN-3816]. - Correct mapping from Exact Online transaction lines/transactions to webhook events for Data Replicator [ITGEN-3816] - Fix ArgumentNullException when retrieving Exact Online XML table GLAccountClassificationRelations [ITGEN-3803]. - Avoid Object reference not set exception when using 'set [ignore-http-403-errors] true' on Exact Online. - Fix itgenrst007 error on FirstMeasurementMoment of RateLimits for Exact Online. - Avoid itgeniuy003 error when not logged to Office 365 [ITGEN-3789]. - Fix derived tables on Teamleader returning no data [ITGEN-3769]. - Enable Excel export on Visma Severa. - Fix various data types issues in Teamleader objects not reflecting documentation. - Fix Severa APIs return no results for table functions [ITGEN-3775]. - Improve check on presence of required values [ITGEN-3769]. Version 17.30.0, released 2019-01-10. Enhancements: - 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 <