We are getting an error when trying to connect to PROD DWH via ODATA connection.
Error reads Invalid User ID or password.
The ODATA service limit is 10,000 entities per page. if an implementation doesn't pass the $top parameter then will experience the error
Release : 16.0.1
Component :CLARITY
It is best to use pagination to remain within the 10,000-record limit. CA Support observed this issue with SSIS; however, the 10,000- entity pagination limit also applies when attempting to automate with other BI tools.
(Example)
https://cppmxxxx.ondemand.ca.com/api/odata4/xxxxxxpdatasourceV4/DWH_INV_TASK?$top=10000&$skip=10000