When you configure a synchronization task to read from an OData Consumer service, you can configure the source properties.
The source properties appear on the Source page of the Synchronization Task wizard when you specify an OData Consumer connection.
The following table describes the OData Consumer source properties:
Source Property
Description
Connection
Name of the OData Consumer source connection.
Source Type
Source Type. Select Single for a single OData Consumer source object.
Source Object
OData Consumer Source object for the task.
The following table describes the advanced OData Consumer source properties:
Advanced Source Property
Description
Data Serialization Format
The format of data that is transferred over the network.
Specify the property to override the Data Serialization Format value you specified in the OData Consumer connection.
Select one of the following options:
- Connection Default
- ATOM/XML
- JSON
When you specify Connection Default, the Secure Agent uses the Data Serialization Format value you specified in the OData Consumer connection.
Default is Connection Default.
Maximum Number of Rows
Determines the maximum number of records you can read from the source.
For example, when you specify a value of 100, the agent reads 100 records from the source.
Default is 0, which specifies that the agent reads all records from the source.
Number of Rows to Skip
Sets the number of rows you can skip.
For example, you can set this property to n to skip the first n rows in a source and read from the (n+1) row.
Default is 0.
Page Size
Determines the number of rows to read from each page from the source.
Default is 100 rows.
Tracing Level
Sets the amount of detail that appears in the log file. You can choose terse, normal, verbose initialization, or verbose data.
Default is normal.
Synchronization Example
You want to read a table from NorthWind OData V4 services that stores payroll information of employees.
Configure a synchronization task to read from OData Consumer.
You perform the following synchronization tasks:
Define the synchronization task.
Configure a synchronization task to use the insert operation to read from a NorthWind OData V4 services and write to a flat file.
Use an OData V4 source object.
The source for the mapping is an OData V4 source object Employee that contains payroll details of employees. The Employee OData V4 source is a single source in the synchronization task. You can include fields, for example, employee ID, first name, last name, and title.
Create a flat file target object.
Select fields, for example, employee ID, first name, last name, and title fields from the source object that you want to insert into the target object. Provide a name Employees.csv for the target object and specify the connection type as flat file. The synchronization task writes the data to the flat file.
Configure a field mapping.
Map all the fields under Employee source data to all the fields in the target Employees.csv. The synchronization task writes the mapped source data to the flat file.
Configure the advanced source properties.
In the advanced source properties, you choose properties that are specific to OData Consumer. Specify the default value for the data serialization format and specify 100 as the page size. Save and run the task. Open the flat file to visualize the exported data.