OData Connector > OData connections > OData connection properties

OData connection properties

When you set up an OData connection, you must configure the connection properties.
The following table describes the OData connection properties:
Connection property
Runtime Environment
The name of the runtime environment where you want to run the tasks.
User Name
User name to connect to the OData service.
Password associated with the user name.
Service Root URI
Root URI for the data source offered through the OData protocol.
The resource identified by the service root URI must be an AtomPub Service Document as specified in RFC 5023. The resource must follow the OData conventions for AtomPub Service Documents or an alternate representation of an AtomPub Service Document if a different format is requested.
You can view all the resource collections available for the data service based on the service document that is returned from the root of the ODate service.
Note: For information about the service root URI conventions, see http://www.odata.org/documentation/odata-version-2-0/uri-conventions
OData Parameter File Path
Absolute path to a file that you append to the URL. The file contains key value pairs separated by a new line. You can use this file to check additional parameter values required in the URL.
Note: Ensure that you use percent encoding to encode the key value pairs in the file.
Data Serialization Format
The format of data you want to transfer. You can choose one of the following options:
  • - ATOM/XML
  • - JSON
Default is ATOM/XML.
Object Filter
Specific object that you want to access in an OData service. You can specify a list of comma separated object names.
Primary Key Override
Column names that you want to use as the primary key. Use commas to separate multiple column names.