A better way to view your data and report?

I just attended a session here that describes a product from Datatel that is designed to off-load data from your Unidata/SQL Server/Oracle backend for Colleague. This is an intriguing way of solving reporting problems.

It essentially works by making a copy of relevant data to a secondary (or reporting) server. The real trick is that no matter what database is used for the application back-end, you are reporting off a SQL compliant database with industry standard tools. Additionally, even if the application changes its data model over time (and what app doesn’t), it should not affect your existing reports. This is because when the data is copied (or extracted), only relevant fields are carried over. Those which are not typically used do not make the transition to the new database (let’s say with a name like person_extract).

For example, let’s say you have a table that describes a person. It will have typical information like name, address, city, state, zip, birthdate, social security number (a really helpful bit in tracking people. i know, a little creepy.), and perhaps maiden name for women. Now, the location for all this information may have names like first_name, last_name, etc. What you see on the reporting server is something like first_name_extract, last_name_extract, etc. However, if the data model is changed and the maiden name is then placed in another table and given a name like maiden_name or name (assuming a table name like alternate_names and a field denoting maiden name, it will not make a difference to you. You are still reporting off person_extract. Where the data comes from to populate first_name_extract or last_name_extract, you do not care. The ODS takes care of that.

Really nice for keeping old reports relevant.

In addition, you can also use several database servers to report from. Datatel’s Data Orchestrator ODS (Operational Data Store) can use Microsoft SQL Server and Oracle. They are looking at MySQL as well. Moving forward, any additional SQL compliant servers they add just gives the IT department flexibility and smaller organizations a chance to save money.