Extraction \ Transformation \ Loading

The ETL component of a BI architecture is very critical to the success of the overall solution. This area usually requires the most significant amount of resources. Whatever design is mandated by the reporting requirements of the end users will eventually drive the actual design and development of the ETL mappings.

The tool that is selected and established within any BI architecture is absolutely critical, because as a BI solution evolves, the ETL mappings will need to be continually adjusted and augmented. Our team at Primus has been working various ETL tools for many years and we have a library of canned transformations that can be applied in most environments.