JD Edwards Orchestrator: FTP File Access

In some integration situations, FTP File Access might be needed to complete a business process. Here is our consultant’s take on a solution to automating one of these specific instances using JD Edwards Orchestrator.

We, as consultants, often come across integrations where data comes in a CSV (TXT) file that is then put into a JD Edwards program. Then once the processing is complete, the file needs to be archived. I recently encountered a similar situation when we wanted to automate a JDE Human Capital Management process: “Update Future Employee Master Revision”. Users receive the information in text format and then upload this information to a JDE screen to process this data.

  • Create Connection to FTP locations using JDE Orchestrator Studio
  • Develop Connector SR in JDE Orchestrator Studio
  • Create Orchestration using JDE Orchestrator Studio
  • Test the Solution

1. Set Up FTP Locations

I set up an FTP Location called FTPPOC. I also created 2 folders, “Input” and “Archived”, and consider them two different locations. The idea is to read the file from “Input” and move it to “Archived” after processing. Please check with your system admins or network team to see if they can help you in setting up your FTP locations and provide your JDE ID access to these locations.

2. Create a Connection to the FTP(s)

Create a connection to the FTP location using JDE Orchestrator Studio. You can also configure the connection to different environments using P954000. (Refer to Create Connection in Orchestration Guide)

3. Develop Connector SRs

Source Connector Service

The Source Connector Service is used to read and process the file to JDE. Use the options shown below.

  1. Do not turn on the “Remove Source File” option.

Source to Temporary Location (AIS)

Orchestrator uses AIS temporary location for file movement. This service moves the file from source location to the AIS temporary location. Use the options shown below.

  1. Don’t forget to select “Use Temporary File Location”.
  2. Turn on the “Remove Source File” option.

Target Connector Service

This service moves the file from the AIS temporary location to the archive location. Use the options below.

  1. Don’t forget to select “Use Temporary File Location”.

4. Create an Orchestration

Develop an orchestration using the connector services that we created in the previous step then arrange the connector services as shown below. (Refer to Create Orchestration in Orchestrator Guide)

5. Test the Solution

Now that we have our solution ready, it’s time to test it. I’m using a file titled “test.csv”. Put the file in the FTPInput location.

Looking for more on JD Edwards?

Explore more insights and expertise at smartbridge.com/jdedwards

Keep Reading: Demystifying RPA and JD Edwards Orchestrator

Originally published at https://smartbridge.com on October 4, 2021.

We’re geeks for the enterprise systems and tech that sustains and strengthens business. Simplifying business transformation. Smartbridge.com

We’re geeks for the enterprise systems and tech that sustains and strengthens business. Simplifying business transformation. Smartbridge.com