NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Email to Database transformation

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

Loading Emails into Database

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

It is very simple procedure

Reader connects to 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 Validator object

Than, individual orders are transformerd using Transformation object and following information extracted:

  • Order NO
  • Order Data
  • Product code
  • Customer details
  • Order amount
Visit Support Forum Learn More Download Buy It
My boss told me to keep looking for a more expensive application, assuming Visual Importer ETL couldn't be very good because the price was just too low.  After testing several imports I convinced him that Visual Importer did everything we want so there was no need to pay for a more expensive solution.

Ron Bradshaw,
IT Reporting Manager,
ConAgra Foods / Lamb Weston

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with