Blog

How To Integrate Back-End Systems with EFT

The ability to integrate your data exchange solution with your back-end systems is extremely important when it comes to managing your data and business-critical workflows. If you have business critical SLAs with partners, complicated data transfer workflows, or move a high volume of data, then you’ll find that the integration between those systems will be crucial to the success of your business.  

Moving data securely, managing complex workflows, and meeting business requirements without interruption requires a secure managed file transfer platform like Enhanced File Transfer (EFT). 

EFT can integrate with an organization’s back-end system to not only consolidate disparate applications and systems into one centralized location, but to also provide a reliable and secure workflow—no matter the volume of data, nor the workflow complexity.

In short, EFT can unify your entire system so that you can begin to see your infrastructure working FOR YOU and not against you.  

Energy Company Serves 1.9 Million Customers with EFT

We see a number of our customers who need to integrate SAP systems. One such customer operating in the energy industry serves more than 1.9 million customers. This customer uses SAP to create batch files detailing their customer’s gas usage. The volume of content managed is high, and the process is complex, requiring them to have the ability to move that data to outsourced business partners for invoicing and payment processing. Their automated process includes gathering the files and then sending those files to various business partners.

Every month, they must process this data on time, in order to ensure that their customers can be billed.

EFT’s Event Rules and Actions

EFT can automate this process this using what is called an “Event Rule” with multiple “Actions” associated with the workflow. Consider that they are repeating this process numerous times for their customers. This means that they are collecting, organizing, and moving the gas usage data for 1.9 million customers. If their data management isn’t  

Event Rules enables you to configure EFT to perform an action automatically, when you want a specific event to occur. The “Action” refers to the action you want to occur during your scheduled and automated event. In this case, the action you are automating is moving the files from the backend server and copying them to location on the remote server that you are designating.

How to Automate SAP Transfers with EFT

To create such a Rule, start by creating a Scheduler (Timer) Event Rule. In the Rule Builder, click the Event to define when to run the Event Rule.

For example, let's say you want to run the Rule every day at noon.

Add a "Download (pull) file from host" Action to grab the files from the backend server, and then add a "Copy/Move (push) file to host" Action to copy all of the files from the download location to a specific location to a remote server.

EFT can also send an email notification to let someone know that the files are being copied over to the remote server.

Automate SAP Transfers with EFT

 

There are many other ways to define the Rule. For example, if you're already using a SQL Query to grab data from the system, you can create a workflow in the Advanced Workflow Engine that uses that query.

The One Box to Replace Them All

Organizations with multiple host systems don't have to trash their whole network and start over.

EFT integrates with most other systems, saves the cost of replacing all of your heterogeneous systems, and allows central management of users and connections. You can replace most of those legacy systems with EFT, but you don't have to until you're ready.

Meanwhile, you can integrate EFT with those legacy systems, and your end users can continue doing things the way they always have. Efficiency, security, and cost savings in one workhorse that does it all—EFT.

For more information about using EFT to integrate with backend systems, refer to the EFT online help or engage Globalscape Professional Services to set it up for you.