JD Edwards EnterpriseOne Sources in Synchronization Tasks
When you configure a synchronization task to use a JD Edwards EnterpriseOne source, you can configure the source properties.
When you specify a JD Edwards EnterpriseOne connection, the source properties appear on the Source page of the Synchronization Task wizard. The sort and filter options for the source appear on the Data Filters page of the synchronization Task wizard.
The following table describes the JD Edwards EnterpriseOne source properties:
Source Property
Description
Connection
Name of the source connection.
Source Type
Type of the source object. Select Single as the source type.
Source Object
Name of the source object. Select the source object for the task.
JD Edwards EnterpriseOne Source Synchronization Task Example
You are a data administrator in a product organization and you create sales orders in JD Edwards EnterpriseOne. You want to migrate unique sales order details from JD Edwards EnterpriseOne to Tableau. You use Tableau for an interactive data visualization to understand the key sales metrics and make decisions based on that information.
You perform the following synchronization tasks:
Define the synchronization task
Configure a synchronization task to use the insert operation.
Create a JD Edwards EnterpriseOne source object
The source object for the synchronization task is a JD Edwards EnterpriseOne table F42119 that contains the sales order history. The source object contains information for the sales order details, such as the Order Key Company (KCOO), Order Number (DOCO), Order Type (DCTO), Document Line Number (LNID), Order Suffix (SFXO), and Business Unit (MCU). Use the JD Edwards EnterpriseOne connection to connect to the JD Edwards EnterpriseOne server and read data. The JD Edwards EnterpriseOne object F42119 is a single source in the synchronization task.
Create a Tableau target
The target for the synchronization task is Tableau. To write data to Tableau, create a target object tab_sales_order with fields KCOO, DOCO, DCTO, LNID, SFXO, and MCU. Use the Tableau connection to connect to Tableau.
Configure a field mapping
Map the fields of the JD Edwards EnterpriseOne table F42119 source object to the Tableau target object.
The following image shows the mapping of the F42119 source with the Tableau target:
Note: You cannot edit the data types for a JD Edwards EnterpriseOne source in field mapping
Configure the advanced target properties
In the advanced target properties, you choose properties that are specific to Tableau. Specify the operation type as create and provide the Tableau extract file name. To publish the Tableau data extract file, specify the project name and data source name where you want to publish the data in Tableau.
Save and run the task. The Secure Agent retrieves the data from the JD Edwards EnterpriseOne table and writes to Tableau based on the fields you mapped in the synchronization task.
You can then graphically visualize the following imported sales data in Tableau and make decisions:
