A simple example shows how  Advanced ETL Processor can automatically extract data from POP3 servers

Loading Emails into Database

In fact, the picture above demonstrates how we process Email orders every day.

It is a very simple procedure

The reader connects to the POP3 server using SSL and extracts the following information

  • Email No
  • UID
  • Date Sent
  • From
  • Priority
  • Subject
  • Message

Since we know the sender it is easy to identify order type using the Validator object

Then, individual orders are transformed using the Transformation object and the following information extracted:

  • Order NO
  • Order Data
  • Product code
  • Customer details
  • Order amount
Direct link, no registration required.