IDS GmbH – Analysis and Reporting Services Lowers Total Cost of Ownership and Quadruples Performance of Central Data Warehouse System
 
Oracle 1-800-633-0738
Find an Oracle Specialized Partner
Oracle Customer Programs
 
 

IDS GmbH – Analysis and Reporting Services Lowers Total Cost of Ownership and Quadruples Performance of Central Data Warehouse System

IDS GmbH – Analysis and Reporting Services (IDS) is a wholly owned subsidiary of Allianz SE, a global financial services company that provides a comprehensive range of insurance and asset management products and services to over 83 million customers in more than 70 countries.
IDS offers a full range of managed services encompassing data management, risk control, performance analysis, and reporting to the Allianz Group—for all investments made by its insurance and asset management operating entities—and third-party clients. As a one-stop shop for custom analysis and reporting solutions, IDS provides capabilities that are scalable to handle any production volume.

 
 

 
 

Challenges

A word from IDS GmbH – Analysis and Reporting Services

  • “Oracle Exadata Database Machine is a cost-effective, high performance, scalable system that provided us with an optimal data warehouse infrastructure—not only for the next three years, but for the long term. We’ve seen system performance increase 4x and the total cost of storage ownership fall by 30%, even as our data volumes have surged.” – Holger Haun, Managing Director, IDS GmbH – Analysis and Reporting Services

  • Integrate the company’s performance and risk analyses of international investment data, as well as financial-specific reporting for the Allianz Group, into a central platform for accurate reporting
  • Perform overnight batch jobs in required time frames to provide up-to-date data for financial analysis
  • Generate reports on financial and risk analysis, including ad hoc queries, several times daily—based on information such as stock market prices, share-price indices, and insurance- and asset-management inventories retrieved from more than 350 source systems
  • Ensure storage scalability without incurring costly add-ons, as data volume from the company’s international financial operations grows steadily

Solutions

  • Worked with Oracle partner Information Systems Engineering GmbH to replace the legacy, Oracle-based data warehouse with Oracle Exadata Database Machine without coding or design modification—eliminating storage and performance bottlenecks without incurring programming costs
  • Achieved a fast and easy deployment of Oracle Exadata—which is built on an integrated Oracle technology stack—allowing IDS to migrate approximately 10 TB of production data in a single day to ensure business continuity
  • Added Oracle Exadata Storage Expansion Rack to facilitate the management of high data volumes
  • Gained the ability to publish reports daily rather than monthly to deliver fast, accurate financial information on potential risk and legal liabilities to decision-makers worldwide
  • Ensured high performance data consolidation from more than 350 source systems—including stock market prices, share price indices, and inventory data from over 10,000 portfolios—within specifically defined timeframes for its clients, such as for monthly reporting
  • Improved database performance 4x by deploying the system out of the box, using sophisticated analytical models to generate portfolio and client analyses and reports 3x faster from day one
  • Provided more than 1,500 professional users with rapid access to financial data, enabling them to provide clients with faster insight into market fluctuations and potential risk
  • Tripled storage capacity from approximately 50 TB to 150 TB while lowering cost of ownership by 35%, allowing IDS to meet reporting requirements for the company’s international customers
  • Reduced average data back-up times by 70%, bolstering IDS’s ability to recover from potential system crashes

Why Oracle

“Oracle competed against a classical storage area network solution in a virtualized environment. We chose Oracle Exadata because we get much higher storage performance for a lower total cost of ownership. Also, with fixed capital costs over a three-year period, we are sure to avoid cost increases when our storage requirements grow,” said Holger Haun, managing director, IDS GmbH – Analysis and Reporting Services.

Implementation Process

IDS GmbH – Analysis and Reporting Services ensured a fast and seamless implementation of Oracle Exadata Database Machine with the help of Oracle Advanced Customer Support Services, whose experts have a track record of thousands of deployments worldwide.

Partner

“We have enjoyed a close relationship with Oracle partner Information Systems Engineering (ISE) for many years and have very positive experiences from previous migrations. With their profound knowledge of Oracle technology, ISE professionals provided consulting and technical support during the deployment, including fine-tuning Oracle Exadata,” Haun said.