Today, we’ve released updated data source providers. See the changes below.
Dynamics 365 Business Central (SQL / Navision Option Values)
Version: 24.2.0.0 (TDI) / 24.6.1.0 (TDI SQL) / 24.4.1.0 (TDI Navision)
- Time-type column conversion now produces the correct data type.
- Account filtering: trim whitespace, drop empty entries, case-insensitive comparison, and accounts can now be matched by ID or Name.
- Bumped Jet NavMetadataPlugin DLLs to v1.25.10.2792
Dynamics 365 Business Central (Online / Option Values)
Version: 24.4.1.0 (TDI Online) / 24.2.0.0 (TDI Option Values)
- Fixed issue with 'Selection rule' warning being emitted too often, it is now only logged when there is actually a selection rule defined on an option table.
- Account filtering: trim whitespace, drop empty entries, case-insensitive comparison, and accounts can now be matched by ID or Name.
- Bumped Jet NavMetadataPlugin DLLs to v1.25.10.2792
Dynamics 365 Finance & Operations (SQL)
Version: 24.3.0.0 (TDI)
- Changed account filtering, it now trims whitespace and removes empty entries; is case-insensitive; FNO SQL also matches accounts by ID in addition to Name.
CSV
Version: 24.5.5.0 (TDI) / 1.10.2 (20.10 BU) / 16.4.25.0 (20.10 ODX)
- Added streaming support for large CSV files.
- Fixed an issue when 'Ignore incomplete rows' is false, rows with missing columns now ingest with NULL for missing fields and emit a warning, instead of throwing an error.
- Fixed issue with static columns Preview Table so that the data shows correctly.
- Fixed issue in BU so that scheduling no longer gets stuck on SFTP/FTPS source.
Excel
Version: 24.4.2.0 (TDI) / 1.10.2 (20.10 BU) / 16.4.23.0 (20.10 ODX)
- Fixed issue with static columns Preview Table so that the data shows correctly.
- Fixed issue in BU so that scheduling no longer gets stuck on SFTP/FTPS source.
MongoDB
Version: 1.2.6 (20.10 BU)
- Removed LDAP authentication (deprecated). Password field is now consistently available for SCRAM-based authentication.
- Fixed issue with static columns Preview Table so that the data shows correctly.
MySQL
Version: 1.3.2 (20.10 BU)
- Fixed issue with static columns Preview Table so that the data shows correctly.
SQL
Version: 24.2.3.0 (TDI) / 18.1.1.0 (TDI ADF) / 16.4.3.0 (20.10 ODX) / 10.4.4.0 (ODX ADF)
- Changed ‘float’ data type to map to .NET double instead of float in order to avoid loss of information.
Sun Systems
Version: 24.1.0.0 (TDI)
- Changed ‘float’ data type to map to .NET double instead of float in order to avoid loss of information.
ODATA
Version: 1.4.2 (20.10 BU)
- Fixed issue with static columns Preview Table so that the data shows correctly.
Oracle
Version: 1.2.0 (20.10 BU) /10.4.7.0 (ODX ADF)
- Added filtering to meta tables in the Oracle ADF (Azure Data Factory).
- Improved oracle meta data extraction query.
Parquet
Version: 24.4.1.0 (TDI) / 1.8.1 (20.10 BU) / 16.4.16.0 (20.10 ODX)
- Added support for incremental load (TDI only).
- Added support for streaming large files.
- Fixed issue with special float values (NaN, +Inf, -Inf), they now map to NULL.
- Fixed issue with static columns Preview Table so that the data shows correctly.
- Fixed issue in BU so that scheduling no longer gets stuck on SFTP/FTPS source.
Delta Parquet (OneLake)
Version: 24.1.0.0 (TDI)
- Fixed issue with test connection.
REST
Version: 1.10.2 (20.10 BU)
- Fixed issue with static columns Preview Table so that the data shows correctly.
Salesforce
Version: 1.0.1 (20.10 BU)
- Fixed issue with static columns Preview Table so that the data shows correctly.
XML/JSON
Version: 24.4.1.0 (TDI) / 1.9.3 (20.10 BU) / 16.4.19.0 (20.10 ODX)
- Added support for incremental load (TDI only).
- Fixed issue with table flattening where it used incorrect name when no name was specified (BU and ODX).
- Fixed issue with table flattening being skipped when there was more than one flattening for some cloud based locations.
- Fixed issue with static columns Preview Table so that the data shows correctly.
- Fixed issue in BU so that scheduling no longer gets stuck on SFTP/FTPS source.
