To read data from JD Edwards EnterpriseOne directory server, configure a JD Edwards EnterpriseOne object as the Source transformation in a mapping. You can configure a Source transformation to represent a single JD Edwards EnterpriseOne source.
Specify the name and description of the JD Edwards EnterpriseOne source. Configure the source and advanced properties for the source object.
The following table describes the JD Edwards EnterpriseOne source properties that you can configure in a Source transformation:
Source Property
Description
Connection
Name of the source connection or create a connection parameter.
Source Type
Type of source object. Select Single or Parameter as the source type.
Object
Name of the source object. Select the source object for the task.
Parameter
The parameter for the source object. Create or select the parameter for the source object.
Note: The parameter property appears only if you select parameter as the source type.
The following table describes the JD Edwards EnterpriseOne query properties that you can configure in a Source transformation:
Source Property
Description
Query Options
Filters or sorts the source data based on the conditions you specify. Click Configure to configure a filter or sort option:
- Filter. Filters records and reduces the number of rows that the Secure Agent reads from the source. Add conditions in a read operation to filter records from the source. You can specify the following filter conditions:
- Not parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records.
- Completely parameterized. Use a parameter to specify the filter query.
- Advanced. Use an advanced filter to define a more complex filter condition that uses the JD Edwards EnterpriseOne query format.
- Sort. Sorts records based on the conditions you specify. You can specify the following sort conditions:
- Not parameterized. Select the fields and type of sorting to use.
- Parameterized. Use a parameter to specify the sort option.