Re: data Extract, Transform, Load (ETL) on Iseries

Reasons for ETL may include:
- Slows down the .NET developers to have to learn how to connect to a real
database.
- Faster response time for non volatile data.
- Access to data regardless of availability of machine due to backups,
month end, PTF apply, etc.
All able to be worked around but still not totally negligible concerns.
But that decision has been made.

Mimix does have an HA solution, true, but them and/or their parent
company, Vision Solutions, also has products for this kind of processing
also. There's been a few other companies also peddling products. I don't
use any.

Then there's roll your own. It's a Make vs Buy decision. Common enough
occurrence in IT. Won't be the first or, God willing, last time you'll
ever hit it.


Rob Berendt