OData
OData
Setup Guide
Follow these steps to connect OData to your CData Connect account:
-
Open the Connections page of the CData Connect dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type OData into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Select an Auth Scheme and follow the relevant instructions below.
Authentication Methods
None
None is when no authentication is required.
-
Enter the following information:
- URL—the root URL of the OData service (for example,
http://MySite/*MyOrganization*
).
- URL—the root URL of the OData service (for example,
-
At the top of the CData Connect Add OData Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzureAD
AzureAD is a form of OAuth that goes through Azure.
-
Enter the following information:
-
Azure Tenant—the Microsoft Online tenant that you use to access data. If you leave this field blank, the account’s default tenant is used.
-
OAuth Client Id—assigned when you registered your OData account for OAuth.
-
OAuth Client Secret—for your OData account for OAuth.
-
URL—the root URL of the OData service (for example,
http://MySite/*MyOrganization*
).
-
-
At the top of the CData Connect Add OData Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
Basic
Basic is basic user name and password authentication.
-
Enter the following information:
-
User—the user name for the OData service.
-
Password—the password for the OData service.
-
URL—the root URL of the OData service (for example,
http://MySite/*MyOrganization*
).
-
-
At the top of the CData Connect Add OData Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
OAuth
-
Enter the following information:
-
OAuth Client Id—assigned when you registered your OData account for OAuth.
-
OAuthClient Secret—for your OData account for OAuth.
-
OAuth Authorization URL—(optional) the URL where the user logs into the service.
-
OAuth Access Token URL—(optional) the URL where the request for the access token is made.
-
OAuth Refresh Token URL—(optional) the URL where refresh tokens can be exchanged for access tokens when old access tokens expire.
-
URL—the root URL of the OData service (for example,
http://MySite/*MyOrganization*
).
-
-
At the top of the CData Connect Add OData Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
SharePointOnline
-
Enter the following information:
-
User—your SharePoint Online user account.
-
Password—your SharePoint password.
-
URL—the root URL of the OData service (for example,
http://MySite/*MyOrganization*
).
-
-
At the top of the CData Connect Add OData Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect and OData, see this information page.