How to Configure OData Endpoint

To configure an OData endpoint for your data in Skyvia Connect, perform the following steps:

1.If you don't have a connection to the data source you want to expose data from, create one (learn how).
2.Navigate to the Endpoints page by clicking Connect in the menu on the left side of the page.
3.Click the New button.
4.Click the necessary connection.
5.An endpoint editor page is opened. The left pane of the page lists all the objects from the selected connection. Drag the objects you want to expose data from from the left pane to the right pane to add them on the diagram. The relations between objects added to the diagram are automatically displayed on it.
6.Optionally double-click a dragged object on the diagram. The Edit Entity dialog box is displayed. Here you can select the fields to expose data from and rename the entity type and corresponding entity set. The fields, hidden here, won't be available via the OData protocol. Repeat this step for all the entities if necessary.
7.Optionally you can also manage the relationships between entities. You can edit or delete automatically generated relationships and add new, custom ones. See more details in the Managing Relationships topic.
8.Optionally click the Users button and specify user names and passwords. Users will need to authenticate themselves in order to access the exposed data using one of these user names and the corresponding password. See more details in the Security Settings topic.

note Note

If you don't specify any users, the endpoint data will be publicly available without authentication.

9.Optionally limit the IP addresses, from which the exposed data can be accessed. For this click the IP Address button and specify one or more allowed IP ranges. Otherwise, the data can be accessed from any IP. See more details in the Security Settings topic.
10. Optionally select the OData protocol version, with which the endpoint will be compatible in the corresponding drop-down list on the endpoint editor toolbar. By default, Skyvia creates endpoints, compatible with the latest available version of the OData protocol.
11. Optionally, if you want to forbid editing data source data via the OData endpoint, select the Read Only check box on the toolbar.
12. Optionally point to the upper part of the page, click the displayed btn-edit-name icon, and specify a name for the OData endpoint. This name will be used in Skyvia interface to identify and find this endpoint.
13. Click Save.
14. Click the left arrow to the left of the endpoint name to leave the endpoint editor. This opens the endpoint details page. Endpoint details page displays the generated endpoint base URL, the number of user accounts for access to this endpoint, the number of IP address ranges, from which the access is allowed, and activity log. You can copy the endpoint URL to link its data to other applications. For example, see the tutorial on how to create an OData endpoint to Salesforce data and use its data in Excel.

You can find a detailed description of the endpoint editor page in the Endpoint Editor Page topic.