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
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