JD Edwards EnterpriseOne Source Synchronization Task Example
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:
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:
ASK INFAPreview
