OData Connection Manager Editor

SQL Server 2016 and later
 

Use the OData Connection Manager Editor dialog box to add a connection or edit an existing connection to an OData source.

Connection manager name
Name of the connection manager.

Service document location
URL for the OData service. For example: http://services.odata.org/V3/Northwind/Northwind.svc/.

Authentication
Select either Windows Authentication or use this user name and password for Basic Authentication. If you select the second option, enter the user name and password.

There are now three more options. Select Microsoft Dynamics AX Online for Dynamics AX Online, select Microsoft Dynamics CRM Online for Dynamics CRM Online and select Microsoft Online Services for Microsoft Online Services. If you select one of these three options, enter the user name and password.

Test Connection
Click this button to test connection to the OData source.

OData Connection Manager

Community Additions

ADD
Show: