Re: Suggestions for a reporting system

Yash,

First you need to decide where the data will come from your users want to see, from the operational data base or from a data warehouse kind of thing. The latter is better for historical views (mixed with your up-to-real-time-data) and getting data in frequently can be a bit demanding. For this you need something called ETL-Tool for data extraction. ETL stands for extraction, transformation, load. You can find several tools in the market for this and Clementine is none of them. You will find highly functional and expensive tools like Ascential, Business Objects (Acta), Informatica, etc. and cheaper ones. Further you need to have an idea what kind of reporting tool you want your users to use. You will find tools from Actuate (which is nice for incorporating data from disparate data sources in reports and very often used in finance institutes), Business Objects (also ETL tool vendor), Cognos ReportNet (dto.), Hyperion (Performance Suite), Information Builders (they also have software to incorporate data from disparate sources, even realtime), MicroStrategy.

Kind regards,
Joerg
ath0tmailc0mf0remails

<yashgt_at_yahoo.com> schrieb im Newsbeitrag news:1119875329.661449.124990_at_g14g2000cwa.googlegroups.com...
> Hi,
>
> We will be developing a management reporting software for a bank. The
> user will see reports that get updated in near real time( e.g. every 5
> min), with data regarding transaction amounts, etc. across a number of
> dimensions such as day, time, region, etc.
> The dimensions will be hierarchical in nature. So a zone will have
> states and a state will have cities.
> The raw data has to be pulled from several different databases, such as
> a DB for ATM transactions, another for home loan applications, etc.
> It should be easy to add customized reports if a different view of the
> data is desired.
> Our clients suggest that we use a tool called Clementine developed by
> SPSS. But we have the liberty to choose a different tool if that serves
> our purpose.
> Clementine seems to allow a data flow to be defined which might be of
> use to pur project. Does anyone have any idea how this could be
> different from SQL server's Data Transformation Services?
>
> Any other thoughts regarding the approach to be taken, will be
> appreciated.
>
> Thanks
> Yash
>
Received on Mon Jun 27 2005 - 12:23:44 CDT