CROSSMARK helps the Consumer Packaged Goods (CPG) industry refine marketing efforts by gathering vast amounts of Point-Of-Sale (POS) information into a data warehouse. As the company prepared to expand its biweekly POS data loads from 300 million rows to 4 billion, it needed a more robust Extract, Transform, and Load (ETL) solution and an easier-to-use reporting solution. It upgraded its data warehouse to Microsoft SQL Server 2005 running on the Microsoft Windows Server 2003 Enterprise Edition operating system. CROSSMARK replaced its Business Objects reporting application with SQL Server 2005 Reporting Services.
Did you find this white paper useful?
31 out of 50 users found this white paper useful
Related white papers
Ferplast Improves Service and Maintains Competitive Edge With Data Integration
Ferplast SpA a leading supplier of more than 2,000 pet products, wanted to provide management the ability to reorganize information quickly by classifications in the staging area, and obtain reports...
Ethernet Network-Based DAQ and Smart Sensors for the OPERA Long-Baseline Neutrino Experiment
This paper proposes a data acquisition scheme for the OPERA long-baseline neutrino experiment based exclusively on Ethernet. The expected data rate allows the use of an Ethernet capable device close...
Bank Asya Accelerates ETL Processes by 400%
Bank Asya provides a wide range of banking products and services to retail, corporate and commercial customers in Turkey. Bank Asya wanted to integrate multiple databases to create a single...
MSDN Webcast: geekSpeak Extending SQL Server Integration Services With Reza Madani (Level 100)
The presenter of this webcast shows the tips for extending Microsoft SQL Server Integration Services (SSIS) with scripts. He also takes the questions about the most effective use of this...
Helped Save Reporting and Analysis Costs for IATA Through Centralized Data Warehouse
IATA wanted a system that would consolidate all the E-Ticketing information from various sources and generate specific reports that would show the compliance status and related information of each airline....
The Forrester Wave: Information-as-a-Service, Q1 2008
Forrester evaluated leading enterprise Information-as-a-Service (IaaS) vendors across 94 criteria and found that BEA Systems, IBM, Oracle, and Red Hat have established leadership positions, thanks to their IaaS capabilities, breadth...
Managing Complex XML Data in Oracle XML DB 11g
Over the past few years, XML has emerged as the new standard for data transmission, and its use is becoming more prevalent as companies continue to adopt XML-based solutions. As...
