Need help with Odata connection in SSIS - cannot acquire a managed connection

Ddr 1 Reputation point
2021-03-02T21:21:41.717+00:00

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?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,493 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-03-03T08:37:05.04+00:00

    Hi @Ddr ,

    Please check if the user has full permissions to access to the Odata source.

    Please refer to OData Source and Tutorial: Using the OData Source.

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.