Business Intelligence (BI) - ERP - Dashboards

Physical Environment Setup

After the Requirements are gathered, its necessary to set physical Envioronment by installing database and maintaining the Physical servers.The usual set of servers include 3 sets of instances.

1. Development servers: where the developers work on the database and roll it for testing.
2. Testing Servers: the objects developed by the developers are tested on this server which has the database and data replica to that of Production server.
3. Production server: this is the real time data containing the Production data of any transaction sources. The testing on this is not advised by the internal testers. Testing on this is done only by end clients doing transactions.

Along with these separate instances, it is also necessary to have separate process of ETL, OLAP and Reporting tools on separate servers and all of them to have their own Application as well as Database servers running separately. The servers are setup with database with the help of Network admin and database Administrators (read DBA). They in turn will develop detailed document of the servers handed to the projects managers.

Next >> Data Modeling

Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, ERP, Hardware

Free Dashboards