Adhoc Data Processing / ETL

I have just started working with a new company in outsourced communications (eg print and mail, email, fax). One of the requirements is to process customer data and prepare it for distribution.

For repetitive jobs, this is easy to use with the ETL tool bundled with some addressing software, but for adhoc files it's a bit overkill. I used to use previously developed stuff (awkward but useful) but I don't want to recycle that here. Any recommendations?

Some features:

  • Basic DBMS functionality (preferably using a proper DBMS database to support SQL)
  • Concatenation of fields (e.g. concatenating first and last names)
  • "Clicking Columns" (for example, with address fields 1 - 8, click them on the left, so if one of them is empty, the next one will be inserted)
  • Mail distribution and sorting at post office in Australia (or external tools can be easily linked)
+1


a source to share


1 answer


Could your own Python or Perl be acceptable?



+1


a source







All Articles