Skip to main content

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.
Be the first to reply!