Issue:- We are getting an error while connecting to an Odata connection. When we use the same properties in Excel, it works fine.
Connection could not be established. Either database connection properties are
incorrect or database is down. Try again with correct properties.
URL = jdbc:odata:user=UserName;password=*******;URL=ODATAURL;
User ID =Error while establishing connection to "OData" application through Rss Connector.
Reason: XcoreXodataX160X6121.tnd: HTTP protocol error. 401 Unauthorized.
Solution:- The URL format to connect with ODATA is shown below:-
We have added "Auth Scheme=BASIC" parameter to JDBC URL.
Article is closed for comments.