Kettle
One of my clients has been asking about statistics for his database ... being able to metric / measure more than just the sales people (and the sales people to a better degree).He faces the same problems most small-medium sized businesses have. That is, they have a wonderful database (sometimes it's NOT so wonderful), that is designed entirely to do data input. Running reports is not necessarily convenient.
What my client is really in need of is his database (which he has), an ETL tool, and a reporting database. This would take some of the load of the reports OFF of the database, which is used 24x7, and allow users to run "canned" reports.
I've spent some time researching the ETL tools, before writing my own, and have found that Octopus and Kettle appear to be two of the best. We're about to start a complete rewrite of some of the reports, and Kettle will probably be our choice. It seems to be more feature-rich, and with a built-in GUI / designer, no one has to learn ALL of the API to get off the ground and going.
I'll be sure to update as we get moving forward with the project ....
0 Comments:
Post a Comment
<< Home