Data Warehouse Automation

“We’re trying to reduce our 2 a.m. calls, like everyone else.” That’s what I heard when a CIO came to us looking to solve problems in his data center. He didn’t sound excited about it. But, he knew that if they could find solutions to common problems they’ve encountered, that there could be a tremendous positive impact on the organization.

How often are your data center operators called in to rescue you from a bad situation? Can these situations be avoided to reduce these calls? Data warehouse automation is an area where workload automation can truly shine.

1. Did the data arrive from the customer as expected? If not, does the customer need to be notified?
2. Was the data intact and valid?
3. Is the ETL process started as soon as the data is available?
4. Could the data be extracted, transformed, and loaded without any errors?
5. If there are errors, are they resolved automatically with proper logging, auditing, notifications, and reporting?
6. Does the entire process need to start over when an error occurs, or can parts of the process be restarted to increase throughput?
7. Is report generation started as soon as the data is available?
8. Are reporting errors handled automatically?
9. Is the report sent to recipient as soon as it’s available?
10. Are multiple delivery mechanisms supported, such as: FTP, FTPS, SFTP, UNC, JMS, etc?

Are you looking to solve some of these problems with your data warehouse automation solution? Great! I’ve got some news for you! Flux 7.11 will include Cognos integration straight out of the box! We’re in the preliminary stages of planning support for Informatica as well. With support planned for Informatica and Cognos, Flux should be on your radar.