Currently, when using the TimeXtender Dynamics 365 Business Central – SQL Server connector, it is not possible to leverage Azure Data Factory (ADF) and Integration Runtime (IR) for connecting to this data source.
This limitation means the connector can only be used when there is direct access to the Business Central SQL Server database. However, in some customer environments, direct access is not available/allowed. In such cases, the only option is to use the Azure Data Factory – SQL Server connector. Unfortunately, this alternative lacks key features provided by the Business Central connector, such as option fields, translations, and SIFT tables.
It would be highly beneficial if both connectors could be combined to enable ADF/IR support while retaining the Business Central-specific features.
