Technology

MCIA Solution Inc. is interesting by the choice of the technology used in the Data Warehouse project.

In project solutions, MCIA Solution Inc. uses a wide portfolio of tools and technologies supplied by worldwide leading providers in the field of Business Intelligence and Data Warehousing (BI/DW). The Technology section contains an overview of the most popular BI/DW technologies used in nord-american project solutions. Beside descriptions, this section offers some examples, ideas and inspiration based on actual projects where the mentioned technologies have been successfully implemented.

The section is divided into the following areas:

RDBMS : Relational database systems - The relational database is the heart of a data warehouse. Selecting the right database marks the way to the final success of the entire project. The following survey characterizes relational database types MCIA Solution Inc. preferably works with : Oracle, DB2, SQL Server and Sybase

ETL : (Extraction, Transformation & Loading) tools are an integral part of every DW project. The success of the entire project often depends on the quality/efficiency of ETL tools. If the data warehouse is not filled with quality data within the planned schedule, then the data warehouse becomes an empty shell lacking any content.
Above all, the usage of a specific ETL tool depends on the implementation environment and on the required performance, eventually on the price of the solution. MCIA Solution Inc. predominantly works with ETL technologies outlined below : Informatica, Datastage and DTS (Data Transformation Services)