Case Studies: Government

Israel Police needed to unite data from more than 20 intelligence applications to give its officers a faster and more efficient tool for solving crime. They needed an enterprise grade extract, transform, and load (ETL) tool for performing complex transformations on feeds before adding information to its new online analytical processing (OLAP) intelligence system. After testing Informatica PowerCenter against Microsoft® SQL Server™ 2005 Integration Services, Israeli Police decided to use Integration Services for the ETL component of its OLAP solution. The 2-terabyte intelligence system, running on a single instance of SQL Server, helps Israeli Police intelligence officers complete data searches in seconds that once took days to assemble from disparate systems. Integration Services has also proven easy to incorporate into custom applications created using Microsoft Visual Studio® .NET.

The Alaska Department of Revenue, Permanent Fund Dividend (PFD) Division, managed a multitude of disconnected and continually failing technologies, housing several terabytes of data, with only a six-person IT staff. It needed a new data infrastructure to support its operations, which includes the distribution of between U.S.$500 million and a billion in dividends to approximately 630,000 Alaskans each year. Using Microsoft SQL Server 2005 Enterprise Edition, the organization’s new data warehouse contains 15 million images of historical and current documents, and has the ability to scale to support the roughly 3 million images added each year. After deployment, the PFD Division was able to integrate disparate technologies, increase infrastructure reliability and scalability, greatly improve operations and IT efficiency, and will ultimately save hundreds of thousands of dollars per year.