DataMart Builder

By: Iqub  09-12-2011
Keywords: Reporting Solutions, Robust Reporting

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? 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).

Keywords: Reporting Solutions, Robust Reporting

Contact Iqub

Email - none provided

Print this page

Other products and services from Iqub



We are SQL Server experts, well versed in all aspects and components of SQL Server allowing us to provide a full range of SQL Server solutions that go far beyond normal run-of-the-mill database systems. We build knowledge transfer and collaboration into the process to ensure our clients are self reliant with their new technologies and solutions.


BI Jump Start

This question is examined with the client to explore different technologies and strategies that can be deployed quickly and easily within your organization; to deliver the right information when and where required. BI Jumpstart is your own personal expert to provide you with knowledge and training in Data Warehousing, Business Intelligence, and Reporting Solutions.


OLAP Browser

On a monthly or quarterly basis this application is routinely used to provide more in-depth analysis on the business; show best selling products, show top performing agents, show customers with sales last year but no sales this year, show sales growth monthly/yearly, etc. OLAP Browser offers a low cost solution for providing staff with the tools they need to examine their data and manage their business more effectively.


eBusiness Report Gateway

EBusiness Report Gateway with Reporting Services allows companies to quickly and economically develop and deploy tailored reports for distribution throughout the company. EBusiness Report Gateway with Reporting Services is a web-page or portal making a host of reports and information available to whomever and whenever it’s needed.


eBusiness Advisor

EBusiness Advisor tracks and monitors your business to provide insight into your business, highlighting what is working well and what isn’t. Designed for simplicity but built for performance, eBusiness Advisor puts key information in the hands of those that need it. EBusiness Advisor eliminates your development life cycle, reducing risk and cost.