Better Together – Exadata and PowerCenter for High-Speed Analytics

Exadata and PowerCenter
Pump Data Into a High-Speed Analytics process
You are inundated by an avalanche of data.  It is coming at you faster and faster.  It has many varaieties. And it’s multiplying.  The business needs to make sense of it all in a timely manner.  How do you tame this beast?  How can you quickly and cost-effectively capture and pump all this data into a high-speed Analytics process? With the right kind of pump, of course!

Recently, at Oracle OpenWorld 2014, many of our customers have told us they are migrating their Data Warehouse into Oracle Exadata.  The driver behind this migration is the need to combine and analyze high volumes of data, at increased speeds.  Our customers have said they need their Data Integration process to match the speed and performance of Exadata.  And they want to scale cost-effectively.

We have good news for our customers moving to Exadata. We can do that for you!  We just completed a benchmark with Oracle to certify PowerCenter as optimized for Exadata and SuperCluster.  The benchmark used PowerCenter Advanced Edition to load a 1 TeraByte data table into Exadata. The results were conclusive and demonstrated a 5X performance improvement over traditional Oracle Data Warehouse!

With PowerCenter, you can now extract and transform data from hundreds of data-sources, from social to mainframe, and load it into Exadata with the highest data throughput and scalability.  This ensures the right data is available in the Data Warehouse in a timely manner.  Trusted Analytics is enabled at the speed of your business.

You may be worried about your previous investments in Data Warehousing? When you use PowerCenter to migrate to Exadata, your investment is protected.  You can reuse your existing data integration mappings to load data from existing and new sources into Exadata.  Just faster. And more of it. No additional coding required!

You can further harness the Exadata horsepower by utilizing PowerCenter Advanced Edition PushDown Optimization.  This unique capability allows you to seamlessly process portions of your Data Integration directly on Exadata and further improve performance and scalability.

What else is in the secret sauce? PowerCenter Advanced Edition boasts advanced Scaling capabilities, such as High Availability with automatic fail-over, Enterprise Grid and Partitioning.  This will allow you to extract, transform and load (ETL) high volumes of data at unheard of speeds. You can cost-effectively scale your ETL process, with increased performance, by simply adding PowerCenter CPUs and cores.  You can increase overall scalability and performance of your Data Management system while optimizing Total Cost of Ownership (TCO).

You want to increase scale and speed of your Data Analytics, as data volumes grow and more projects and stakeholders emerge.  It is critical to deliver data insights to stakeholders via data lineage and facilitate impact analysis by developers.  PowerCenter Advanced Edition delivers Metadata Management tools and a collaborative Business Glossary to ensure high-quality business analytics across the enterprise. You can accomplish that without compromising speed and cost-efficiency.

Our benchmark also included a profiling query of over 1 TB data set. It was performed 5x faster using Informatica Data Quality. 1.5 million objects could be captured for data lineage. That is Big Data management for many of you. Done faster with quality and governance.

If you too, are thinking of migrating to Exadata, please think of PowerCenter as your on-ramp into Exadata. Together with Oracle, we can help you dramatically and cost-effectively increase the performance and throughput of your Data Warehouse.  We can help you pave the way to the new age of high-speed Analytics.  We enable you to expand Data Management investments to incorporate any new Data sources which come along.  Our tools will help you bring order into the data chaos.  The goal is to deliver the right data at the right time for your analysts to consume and analyze.  The business demands no less.

Watch the video from Oracle OpenWorld 2014
Read the press release
More information about Informatica for Oracle


  • Pawan Agarwal

    Does Informatica Version 9.1.0 supports Exadata?

  • Fábio de Salles

    Just to make sure I understood it: You are not talking about running PC inside Exadata cluster, but on a separate computer, networked to Exadata just as it would be networked to a standard Oracle server.Right?