Many times working in an IT team you’ll be asked to provide an extract of data from System A in excel friendly format. I’ve seen this solved in many different ways, a couple being:
- Giving read only database accounts out to the business
- Using Excel VB macros with some embedded database connections
- Developing some sort of bespoke front end button to do it
Each introducing their own management headache:
- Exposing some part of the data you weren’t planning to
- Difficulty updating and maintaining versions (everyone loves there local copy)
- Added overhead of maintaining the bespoke front end service
How Interlok has been used to solve this is using a tool that we all use daily… email.
Simply the solution has three main parts:
- Listen for a new email in specific mailbox (maybe with a certain subject)
- Get and transform the data
- Send an email back
Technically what this means is:
raw-mail-consumer with a
xml-transformation-service (just one example of the many service combination options)
All together it looks like this:
A working example is available in a github project.
A fairly simple solution that uses an existing technology we are all familiar with, with the luxury of no additional front ends and keeping the configuration in a central location.
Also a: .
If you’re a user of the GUI, you could add the following template file into
./ui-resources/config-templates/workflows/, and add a new workflow using the
You've Got Mail! template: