Who uses it?
The DataMart Builder is for companies, departments, and groups that need a simple, low cost ETL tool for building data marts and data cubes. This is a wizard based application but some knowledge of databases as well as reporting measures and dimensions is beneficial.
What is it?
The DataMart Builder creates the reporting platform which in turn enables you to deploy reporting throughout your organization quickly and easily. With the DataMart Builder in place, staff can access pre-defined and parameter driven web-reports. As well, owners and managers can be empowered with a point and click interface to their corporate data for simple yet powerful reporting and analysis.
Where is it installed?
The application can be installed on a desktop or a server wherever it most convenient and accessible for the administrator.
When is it used?
The application is used initially to populate your datamart or mini data warehouse. After the initial load, the application is used to keep your datamarts and datacubes refreshed with up-to-date information. This can be accomplished by running jobs on demand from within the application or running scheduled jobs through a tool such as Windows Scheduler.
Why is it needed?
Many companies could take advantage of robust reporting solutions but need a simple method to build the reporting structures (mini data warehouse - databases, data marts, data cubes). DataMart Builder provides companies with an uncomplicated method of bringing data from various systems into specialized data structures for robust reporting that can be easily accessed by staff throughout the company. For example you can easily bring in data from legacy systems, access, excel, etc. to create consolidated reporting.
How does it fit?
From the IQub suite, the DataMart Builder is used to build the reporting structures which provide robust web reporting (see Report Gateway) and OLAP reporting and analysis (see OLAP Browser).