Informatica and Cisco Partner on Data Warehouse Optimization Solution that Works with Hadoop

Informatica, a provider of data integration software, has announced a joint Data Warehouse Optimization solution with Cisco for organizations looking to modernize data management. Combining Informatica and Cisco technologies with Hadoop, the new Data Warehouse Optimization solution is targeted at helping customers to integrate and analyze more data and types of data, more effectively and economically. 

With the growing pace of business and increasing use of mobile devices and industrial sensors, businesses have an opportunity to create competitive edge fueled by data, and new scalable and efficient technologies such as Hadoop are enabling larger quantities and varieties of data to be collected, perfected, and protected. 

Citing data from Appfluent Technology, Inc., Informatica said that as much as 50% of a traditional data warehouse’s processing capacity is spent on data integration tasks, and that up to 70% of data in a typical warehouse environment is infrequently used, thus exerting a further drag on warehouse resources.

The Informatica and Cisco Data Warehouse Optimization solution aims to help minimize the risks of transitioning from traditional systems to Hadoop for faster integration and preparation of greater volumes and more varieties of data.

The Data Warehouse Optimization solution works with a customer’s Apache Hadoop distribution of choice, including Cloudera, Hortonworks and MapR.

The solution provides a software, networking and computing infrastructure for utilizing big data and includes:

  • Informatica Big Data Edition, which runs data integration and data refinement workloads (ELT and ETL) natively on Hadoop and enables infrequently used historical data to be archived to Hadoop, while keeping archived data readily accessible to business users and analytic applications.
  • Cisco Data Virtualization Platform, which federates data across the data warehouse and Hadoop for logical data warehousing, providing organizations a comprehensive view of all their data assets.
  • Cisco Unified Computing System (UCS), which provides a high- performance and scalable Hadoop-optimized hardware platform that combines compute, networking, storage and unified management capabilities for efficiently and cost-effectively handling big data.

“The Data Warehouse Optimization solution is about enabling organizations to more easily leverage all their data assets – current and historical, transaction and interaction – for more effective analytics while reducing their data management costs,” said Mike Flannagan, vice president and general manager of Data and Analytics at Cisco. “More than the sum of its parts, the solution’s Cisco and Informatica elements work synergistically to meet the demands of big data, to respond quickly to changing information needs, and to deliver insights that drive increased competitiveness and business innovation.” 

More information is available about the Data Warehouse Optimization Solution.