Today, we’ve released updated data source providers. See the changes below.
Azure Data Factory - Oracle
Version: 17.5.1.0 (TDI) / 10.4.5.0 (20.10 ODX)
- Switched to use v2 connector in ADF, since the previous one is being deprecated.
Azure Data Factory - PostgreSQL
Version: 17.2.0.0 (TDI) / 10.4.5.0 (20.10 ODX)
- Switched to use v2 connector in ADF, since the previous one is being deprecated.
CSV
Version: 23.15.4.0 (TDI) / 1.7.0 (20.10 BU) / 16.4.16.0 (20.10 ODX)
- Added support for handling multiple metadata URIs.
- Added trimming of long column names.
- Added culture settings when parsing numbers for metadata.
- Added support for FTPS location.
- Changed pattern matching for files to be case insensitive.
- Fixed issue with numbers parsed incorrectly with one decimal digit in some cases.
- Fixed issue with metadata URI handling for Sharepoint location.
Dynamics 365 Business Central - Online
Version: 23.1.0.0 (TDI)
- Fixed an issue where the subtract value was not applied during incremental load.
Exact Online
Version: 11.2.0.0 (TDI)
- Added support for incremental loading (TDI only).
- Added better handling of JSON edge cases.
- Added support for Azure App Registration with certificate.
- Added a fallback strategy to handle invalid characters in XML if it fails to read it.
- Added option to not URL encode query parameters.
- Added handling for non-standard Authorization header value.
- Fixed error message for timeout, it now shows text indicating that the request timed out.
- Fixed issue when data type is overridden in TDI.
- Fixed some scaling issues in the REST dialog for BU/ODX.
- Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.
Excel
Version: 23.16.1.0 (TDI) / 1.6.1 (20.10 BU) / 16.4.17.0 (20.10 ODX)
- Added support for handling multiple metadata URIs.
- Added trimming of long column names.
- Added support for FTPS location.
- Changed pattern matching for files to be case insensitive.
- Improved file aggregation logic.
- Fixed excel engine to allow for more files in metadata uri.
- Fixed issue with 'Treat Empty as Null' for table definitions.
- Fixed issue with metadata URI handling for Sharepoint location.
- Removed duplicate file aggregation pattern settings.
Hubspot
Version: 11.2.0.0 (TDI)
- Added support for incremental loading (TDI only).
- Added better handling of JSON edge cases.
- Added support for Azure App Registration with certificate.
- Added a fallback strategy to handle invalid characters in XML if it fails to read it.
- Added option to not URL encode query parameters.
- Added handling for non-standard Authorization header value.
- Fixed error message for timeout, it now shows text indicating that the request timed out.
- Fixed issue when data type is overridden in TDI.
- Fixed some scaling issues in the REST dialog for BU/ODX.
- Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.
Infor SunSystems
Version: 23.2.0.0 (TDI)
- Added support for the force Unicode option
ODATA
Version: 11.2.0.0 (TDI) / 1.3.0 (20.10 BU) / 16.4.7.0 (20.10 ODX)
- Added support for certificates in metadata discovery.
- Added support for incremental loading (TDI only).
- Added better handling of JSON edge cases.
- Added support for Azure App Registration with certificate.
- Added a fallback strategy to handle invalid characters in XML if it fails to read it.
- Added option to not URL encode query parameters.
- Added handling for non-standard Authorization header value.
- Fixed error message for timeout, it now shows text indicating that the request timed out.
- Fixed issue when data type is overridden in TDI.
- Fixed some scaling issues in the REST dialog for BU/ODX.
- Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.
OneLake Delta Parquet
Version: 23.4.0.0 (TDI)
- Fixed an error ingesting metadata when the Lakehouse doesn't support schemas.
OneLake Finance & Operations
Version: 23.5.0.0 (TDI)
- Fixed an error ingesting metadata when the Lakehouse doesn't support schemas.
Parquet
Version: 23.13.1.0 (TDI) / 1.5.0 (20.10 BU) / 16.4.12.0 (20.10 ODX)
- Added logging of file names.
- Added support for handling multiple metadata URIs.
- Added trimming of long column names.
- Added support for FTPS location.
- Changed pattern matching for files to be case insensitive.
- Fixed issue with metadata URI handling for Sharepoint location.
REST
Version: 11.2.0.0 (TDI) / 1.9.0 (20.10 BU) / 16.4.21.0 (20.10 ODX)
- Added support for incremental loading (TDI only).
- Added better handling of JSON edge cases.
- Added support for Azure App Registration with certificate.
- Added a fallback strategy to handle invalid characters in XML if it fails to read it.
- Added option to not URL encode query parameters.
- Added handling for non-standard Authorization header value.
- Fixed error message for timeout, it now shows text indicating that the request timed out.
- Fixed issue when data type is overridden in TDI.
- Fixed some scaling issues in the REST dialog for BU/ODX.
- Fixed issue with table builder when 'Only list flattened tables' is enabled where it would not return the correct schema.
SQL Server
Version: 23.1.0.0 (TDI) / 1.1.0 (20.10 BU) / 16.4.2.0 (20.10 ODX)
- Added support for the force Unicode option
XML/JSON
Version: 23.12.0.0 (TDI) / 1.6.0 (20.10 BU) / 16.4.13.0 (20.10 ODX)
- Added support for FTPS location.