Microsoft SSIS client is not able to load collection end points using Clarity Odata Service
searchcancel
Microsoft SSIS client is not able to load collection end points using Clarity Odata Service
book
Article ID: 393009
calendar_today
Updated On: 04-15-2025
Products
Clarity PPM SaaS
Issue/Introduction
Following the upgrade to version 16.3.1 of Broadcom SaaS along with the change of the ODATA service, Microsoft SSIS client is not able to load collection end points
Steps to Reproduce:
Install VS Studio 2022
Install Extension SQL Server Integration Services Project 2022
Create a package in VS Studio 2022
Create a data source by providing the Data Warehouse OData Service URL details
Now under Dataflow Task create a ODATA source
Expected Results: The collections should be loading in order to fetch data via ODATA
Actual Results: Error "Connection Manager cannot be empty"
Environment
Clarity 16.3.1
Cause
DE168722
Resolution
Fixed in Clarity Data Warehouse OData Service 2.0.2.1