Oracle Data Integration on Exadata: an Unbeatable Combination
By Mala Narasimharajan on Sep 14, 2011
By: Jeff Pollock - Senior Director, Product Management, Oracle Data Integration
This year at Oracle Open World (http://www.oracle.com/openworld/index.html) I am very pleased to be presenting Oracle’s solution for Data Integration with the Oracle Exadata system. Please join me for the Data Integration Session on Wednesday at 10:15pm at the Intercontinental.
One big reason this is such an exciting topic for me to cover is that Oracle has a very unique solution for data integration with Exadata – so much so that I can confidently tell you that no other data integration vendor can match Oracle’s performance, simplicity, and cost-effectiveness.
· Performance – Oracle Data Integration technologies are specifically designed to take advantage of the Exadata systems. By enabling a data integration solution architecture that eliminates unnecessary mid-tier components, Oracle also eliminates all the potential bottlenecks for data movement and transformation. Exadata’s awesome performance is unencumbered by extraneous software or servers.
· Simplicity – Oracle Data Integration technologies are the only solutions that are certified and benchmarked to run directly on the Exadata machine. No other vendor’s solution can operate without additional footprint in your data center, many more connections, setup steps and significantly more potential points of failure.
· Cost Effectiveness – Because of the simple deployment architecture, the Oracle solution eliminates the need for extraneous hardware, management and administrative overhead, or additional systems monitoring. Oracle data integration runs faster, with less overhead.
Oracle’s Data Integration solution for Exadata covers three main functional areas:
3. Cleansing and Matching from Enterprise Data Quality
I really enjoy talking about the bits and bytes of Oracle’s data integration approach with Exadata since it is so different than what other vendors can accomplish. But all of this technology isn’t valuable unless it is applied to tangible business problems. So what exactly can you do with Oracle’s Data Integration products on Exadata?
· Load Data Warehouses – Exadata supplies the ideal data warehouse architecture, based on the industry leading Oracle Database software but part of an engineered system that takes advantage of numerous hardware optimizations. But every data warehouse needs reliable and high performance data feeds, which is precisely what Oracle’s Data Integration software can do – in Real Time or with High Performance Batches.
· Database Migrations – whether from non-Oracle databases or prior versions of Oracle Database, many Exadata customers are migrating schemas and data into Exadata. How can they do that without taking application downtime or custom-engineering a point solution? Yep, you guessed it, by using Oracle Data Integration solutions any Exadata customer can take advantage of Zero-Downtime Migrations and a tools-based approach that doesn’t have to be thrown away when the migration is over.
· Mixed Workload Integrations – unlike other vendor’s database appliances, the Exadata system can handle mixed workloads of OLTP and Warehousing on the same system. So customers who need to integrate data between the OLTP schemas, or from the OLTP schemas to the dimensional warehouses or marts will also need data integration solutions to do that work. Hands-down the best way to do this in Exadata is to ensure that the data doesn’t have to leave the Exadata environment – and that’s exactly what the Oracle Data Integration solutions can do. Data Integration for transactional applications or data marts can take advantage of the power of Exadata without having to off-load the data and re-insert it. Try doing that with any other vendor’s data integration solution – it’s impossible!
So now that I have hopefully whet your appetite for more information and a lively Q&A discussion, please plan on joining me at the Oracle Open World session for Data Integration on Exadata – October 5, 2011 10:30 AM-11:30 AM.