JD Edwards EnterpriseOne Targets in Synchronization Tasks

When you configure a synchronization task to write to a JD Edwards EnterpriseOne target, you can configure the target properties.

When you specify a JD Edwards EnterpriseOne connection, the target properties appear on the Target page of the Synchronization Task wizard. The advanced target properties appear on the Schedule page of the Synchronization Task wizard.

The following table describes the JD Edwards EnterpriseOne target properties:

Target Property	Description
Connection	Name of the target connection.
Target Object	The target object for the task. Select the target object.

JD Edwards EnterpriseOne Target Properties in Synchronization Tasks

Configure the advanced target properties on the Schedule page of the Synchronization Task wizard.

The following table describes the JD Edwards EnterpriseOne advanced target properties:

Advanced Target Property	Description
Operation Type	The operation type to write data to JD Edwards EnterpriseOne. You can choose one of the following operation types to write data to JD Edwards EnterpriseOne: - Write. Writes data to the JD Edwards EnterpriseOne table or view. - InterfaceTableWrite. Writes data in bulk to the JD Edwards EnterpriseOne interface table.
Table Prefix	The database and the schema name of the interface table in JD Edwards EnterpriseOne where you want to write the data. You can use a parameter for this attribute. Specify the table name prefix in the following format: database_name.owner
Truncate Table	Truncates the target interface table before loading the data. Default is disabled. You must select Truncate Table so that the Secure Agent truncates the interface table before loading data into the interface table.
Invoke Business Function	Runs the business function that invokes the batch process. The batch process extracts data from interface tables and writes the data to base tables. Select this option if you want to write the data from the interface tables to the base tables.
Input Parameter File Path	The path of the input parameter file on the machine where the Secure Agent runs. The Secure Agent reads the contents of the input parameter file to determine which base table to write the data to.
Job Status File Path	The file path on the Secure Agent machine where the status code of the invoked business function is logged.
Success File Directory	Directory for the success file. Specify a directory path that is available on each Secure Agent machine in the run-time environment. By default, Data Integration writes the success file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/success
Error File Directory	Directory for the error rows file. Specify a directory path that is available on each Secure Agent machine in the run-time environment. By default, Data Integration writes the error rows file to the following directory: <Secure Agent installation directory>/apps/Data_Integration_Server/data/error

JD Edwards EnterpriseOne Target Synchronization Task Example

Your organization has an inventory management team that manages inventory data in an enterprise resource system such as JD Edward EnterpriseOne. You want to migrate all the inventory information from LDAP to JD Edwards EnterpriseOne so that you can store, track, and manage the inventory information.

Configure a synchronization task to synchronize the inventory information from LDAP to JD Edwards EnterpriseOne.

You perform the following synchronization tasks:

Define the synchronization task.

Configure a synchronization task to use the insert operation.

Create an LDAP source object.

The source is an LDAP computer object that contains computer specifications, such as the object_category, operating_system, operating_system_servicepack, operating_system_hotfix, and operating_system_version. The computer object is a single source in the synchronization task. Select the LDAP connection to connect to LDAP and read the data.

Create an LDAP target object.

The target in the task is a JD Edwards EnterpriseOne table. Include the fields object_category, operating_system, operating_system_servicepack, operating_system_hotfix, and operating_system_version from the source object that you want to insert into the target object. Specify the connection type as JD Edwards EnterpriseOne.

Configure a field mapping.

Map the required fields under the computer source fields to the target JD Edwards EnterpriseOne fields. When you run the task, the Secure Agent writes the mapped source data to the target JD Edwards EnterpriseOne table.

The following image shows the mapping of the LDAP source with the JD Edwards EnterpriseOne target:

Configure the advanced source and target properties.

In the advanced source properties, specify the parent DN from where you want to fetch data. Specify the search level as Subtree to retrieve the base object and all objects subordinate to the base object. In the advanced target properties, specify the operation type as InterfaceTableWrite to write data in batches to the JD Edwards EnterpriseOne interface table. Specify the table prefix for the interface table in JD Edwards EnterpriseOne where you want to write the data.

Save and run the task.

The following image shows the data in JD Edwards EnterpriseOne: