Adhoc Data processing / ETL

Posted by Dane on Stack Overflow See other posts from Stack Overflow or by Dane
Published on 2009-05-26T00:11:37Z Indexed on 2010/06/11 1:02 UTC
Read the original article Hit count: 364

Filed under:
|
|

I've just started at a new company in outsourced communications (e.g. print and mail, email, fax). One of the requirements is to process clients data and get it ready for mailing.

For recurring jobs, this is easy using an ETL tool linked in with some addressing software, but for adhoc stuff it's a bit overkill. I've used inhouse developed stuff before (clunky but usable), but I don't want to have to re-develop that here. Any recommendations?

Some features :

  • Basic DBMS functionality (preferably with a proper DBMS backend for SQL support)
  • Field concatenation (e.g. combine Firstname + Surname)
  • "Pushing columns" (e.g. with address fields 1 - 8, push them left so if one is blank, the next one gets pushed up)
  • Australia post mail sorting and dpid allocation (or can link into external tools relatively easily)

© Stack Overflow or respective owner

Related posts about mail

Related posts about etl