Hello! I am having a problem with Odata connector.
Odata connector is used to pull data from Dynamics Business Central 16.
We use both Odata 4 and Odata 3 versions(version 0.1.11).
Visual Studio 2019, SQL Server Integration Services Projects v 3.10 - running in Visual Studio works just fine. Tried before with Visual Studio 2017 - also works fine.
Deploying to the SQL Server 2014 - running in SSIDB returns error: Cannot acquire a managed connection from the run-time connection manager. [SSIS.Pipeline] Error: OData Source failed validation and returned error code 0xC020801F.
On SQL Server machine we have Microsft Odata Source for SQL Server 2014 component installed for 32 and 64bit, SSDT for VS 2017
We also have TLS settings changed according to https://learn.microsoft.com/en-us/archive/blogs/dataaccesstechnologies/tls-issue-with-ssis-package-while-accessing-odata-source-like-dynamics-ax-online
Also tried: running 32 bit and 64 bit mode.
Nothing helps.
Please advise, what could be the issue here?