Data source providers r. 2025-10-06¶

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.