EA Assist

EA Assist accelerates development of data warehouses in Microsoft SQL Server saving time and money.

Wave has developed a number of extensions  to Enterprise Architect from Sparx Systems that further improves the productivity and quality of systems designed with Enterprise Architect.

Wave has developed Wave EA Assist to raise productivity and quality in developing and implementing data warehouses with Microsoft SQL Server.

Wave EA Assist automates the process to develop Microsoft SQL Server Integration Services (SSIS) packages.

The result is a high quality and easily maintainable Extract, Transform and Load process to support data warehouse environments implemented in Microsoft SQL Server.

Background

A general rule of thumb is that 80% of data warehouse development is consumed in developing the Extract, Transform and Load process.

Whilst Microsoft SQL Server Integration Services is a highly productive environment, it requires considerable expertise to code. Maintaining the packages over time in response to changing business requirements is a continuing overhead.

Wave EA Assist auomates the process of creating and maintaing the SSIS packages. Business rules and processes can be applied consistenly across the environment.

The result is significant savings in the cost of developing and maintaining data warehouses developed in Microsoft SQL Server. It also accelerates the development phase with earlier deliverables with higher quality.

To learn more about how Wave EA Assist can help with your next data warehouse project or get your current one under control please download the  EA Assist Flyer 400kb