Invantive.SQL.Windows
17.28.0
dotnet add package Invantive.SQL.Windows --version 17.28.0
NuGet\Install-Package Invantive.SQL.Windows -Version 17.28.0
<PackageReference Include="Invantive.SQL.Windows" Version="17.28.0" />
<PackageVersion Include="Invantive.SQL.Windows" Version="17.28.0" />
<PackageReference Include="Invantive.SQL.Windows" />
paket add Invantive.SQL.Windows --version 17.28.0
#r "nuget: Invantive.SQL.Windows, 17.28.0"
#addin nuget:?package=Invantive.SQL.Windows&version=17.28.0
#tool nuget:?package=Invantive.SQL.Windows&version=17.28.0
Invantive SQL for Windows is the Windows version of Invantive SQL that allows access to over 50 platforms, all acting together as one global database. Compared to the platform-independent version it adds supports for MySQL, Oracle, IBM DB/2, LDAP, Teradata, Windows ODBC, Invantive Web Service, LDAP, Windows WMI and Windows OS
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net47 is compatible. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
- CryptoLicensing (>= 17.1.6)
- Invantive.SQL (>= 17.28.0)
- Microsoft.IdentityModel.Clients.ActiveDirectory (>= 3.19.8)
- Microsoft.SqlServer.Types (>= 14.0.1016.290)
- Newtonsoft.Json.Bson (>= 1.0.1)
- Oracle.ManagedDataAccess (>= 18.3.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|
Enhancements:
- Make standardization with SQL identifier escape optional.
Version 17.27.27-BETA, released 2018-09-30.
Enhancements:
- Standardize Oracle sequence and primary key naming.
- 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.
- Exclude data from external companies depending on subscription for accountants.
Bug fixes:
- Add proper escaping of reserved words across all SQL platforms.
Version 17.26.8, released 2018-09-07.
Enhancements:
- Allow non-default casing column names on ANSI SQL providers.
- Reduce number of alternative provider attribute names to avoid confusion with users.
- Performance improvements SQL engine: faster returning data, cache some system table functions.
- Performance improvements SQL engine: faster returning data, less memory pressure.
- Improve performance by streaming row checks.
- Streamed reading for ANSI SQL providers, like SQL Server and Oracle.
- Add 'drop table' on MySQL [ITGEN-3052].
- Add create or replace table support for MySQL and support for MySQL on Data Cache/Data Replicator [ITGEN-2083].
- Allow ignore errors from File Access Information determination to avoid itgenube078 errors in Query Tool on restricted Windows environments.
Bug fixes:
- Incremental evaluation of file access privileges to reduce false negatives when checking file permissions.
- Handle column data model upgrade from limited length to unlimited length.
- Fix get object metadata not working for SQL Server and PostgreSQL [ITGEN-2276].
Version 17.24.20, released 2018-07-01.
Enhancements:
- Add group function 'product'.
- Invantive Business for XAF files.
- Only try once to write to event log when not privileged.
- SQL: Allow specifying the timeout on a specific action.
- Improve upgrade scenarios for Data Replicator new not-null columns.
- Add Data Replicator support for Oracle.
- Add support for table or view synonyms in available objects [ITGEN-2604].
- Default user log on code to database value when not specified on connectionstring.
- Add more context when license key can not be decrypted.
- Move providers.xml to settings.xml.
- Add display names to all providers for use in new login screen.
Bug fixes:
- Filter failure itgendid048 "The value %123123% is not a valid integer".
- Improve double data type mapping for Oracle.
- Fix database version query DB2.
- Better support for specifying password on IBM DB2 UDB [ITGEN-2498].
- Password DB2 UDB is incorrectly handed over and not obfuscated [ITGEN-2498].
Version 17.23.1, released 2018-04-10.
Enhancements:
- Enable configuration of internal consistency checks.
- Updated partitioning in Control and Composition to allow selection of the partition when having multiple data containers opened, like two Exact Online accounts.
- Include documentation column on providers in Data Dictionary.
- Add support for file copy actions to OS-provider.
- Add file insert/delete/move tables with audit file_actions to OS-provider.
- Make use of connection pooling configurable per data container in settings.xml.
- Determine version number of database platforms for certification checks.
Bug fixes:
- Update web service exception conversion.
- Fix concurrency issue in webhook receiver causes itgenwrr005 [ITGEN-2108].
- Not found table 'FileSystem..file_actions' [ITGEN-2407].
- Set nullable property on Oracle-based columns correctly, were always false.
- Joining with read_file_text yields invalid results [ITGEN-2246].
- Improve performance by reducing number of lookups on processes.
- Fix NRE and other bugs in Os provider.