When connecting to a database system using OData (Open Data Protocol) from the Syniti Knowledge Platform (SKP), provide the following connection properties to establish a secure and reliable connection. This article explains each property to understand what information is required and how it is used.
SKP allows you to connect to an OData endpoint using basic authentication for the following usage types:
Construct
Metadata Scanning
Replication
Property | Description | Notes |
|---|---|---|
Name | Name of the OData connection, unique in the SKP. | N/A |
Description | Enter a description that briefly states the purpose of this connection. | N/A |
Service Root URL | Enter the service root URL of the OData endpoint. | This is the base URL of the data service and represents the entry point. |
Username | Enter the User ID used to connect to the OData endpoint. | This login name should be an account that your administrator has created for database access. |
Password | Enter the password that is used with the User ID to connect to the OData endpoint. | Authenticates your connection to the database. |
Add Tables to a OData Datastore
In the newly created OData datastore, select the Tables tab and click Add Tables. In the Add Table dialog box, the Base URL of your OData connection is displayed.
In the Service URL field, enter the partial entity URL and click Discover Entity Sets. The SKP discovers and lists all the entity sets available under this service URL.
You can either select all or select the required entity sets.
Click Add Entity Sets.
The selected entity sets are now added as tables for your OData datastore connection. Repeat the steps above for different service URLs.
After adding entities (tables), a metadata scan is automatically triggered, importing all objects and their metadata into your datastore. The Service URL you entered is saved as the Description field for each table.