Friday Apr 04, 2014

Turning Big Data into Real-Time Action for a Greater Customer Experience

The power shifted to us, consumers. The digital revolution allows us to access broader set of services, and communicate without boundaries. Today we demand more and better choices in a competitive market, putting pressures on businesses to catch up with our expectations.

By offering differentiated and improved experience to their customers organizations see that they can drive revenue growth via higher loyalty, and improved brand perception.  Because technology is a key enabler for delivering superb and consistent customer experience across all touchpoints, in recent years customer experience solutions have become a top priority for CIOs. Thanks to the availability of big data analytics, organizations can now analyze a broader variety of data, rather than a few basic data points, and gain deeper insight into their customers and operations. In turn, this deeper insight helps align their business to provide a seamless customer experience.

In our digital, fact-paced world we produce large volumes of data with unprecedented velocity. This data contains perishable value that requires fast capture, analysis, and action to be able to influence the operations or the interaction with the customer. Otherwise the insight or action may become irrelevant, which decreases the value for the customer and the organization significantly.  To extract the maximum value from highly dynamic and perishable data, you need to process much faster and take timely action. This is the main premise behind Oracle's Fast Data solutions, which we have discussed in previous blogs and webcasts.

Real-time data integration and analytics play a crucial role in our new world of big and fast data. Organizations that look into leveraging  big data to create greater customer experience, need to evaluate the analytical foundation behind their customer-facing systems and resulting interactions, and determine whether they can improve how and when they collect, analyze, and act on their ever-growing data assets.

In our next webcast my colleague Pete Schutt in the Oracle Business Analytics team and I will discuss how organizations can create value for their customers using real-time customer analytics, and how to leverage big data to build a solid business analytics foundation using the latest features of Oracle Data Integration and Oracle Business Analytics. We will provide multiple customer examples for different solution architectures.

Join us on April 15th 10am PT/ 1pm ET by registering via the link below.

Turning Big Data into Real-Time Action for a Greater Customer Experience

Tuesday, April 15th 10am PT/ 1pm ET

Until we meet at this webcast, please review my related article on this topic published on DBTA earlier this year:

Friday Jul 26, 2013

The Best Data Integration for Oracle Exadata Comes from Oracle

In a previous blog post I talked about about how Oracle Exadata customers can migrate/consolidate their systems without downtime. In that blog post I mentioned that Oracle Data Integrator and Oracle GoldenGate offer unique and optimized data integration solutions for Oracle Exadata. For example, customers that choose to feed their data warehouse or reporting database with near real-time throughout the day, can do so without decreasing  performance or availability of source and target systems. And if you ask why real-time, the short answer is: in today’s fast-paced, always-on world, business decisions need to use more relevant, timely data to be able to act fast and seize opportunities. A longer response to "why real-time" question can be found in a related blog post.

If we look at the solution architecture, as shown on the diagram below,  Oracle Data Integrator and Oracle GoldenGate are both uniquely designed to take full advantage of the power of the database and to eliminate unnecessary middle-tier components. Oracle Data Integrator (ODI) is the best bulk data loading solution for Exadata. ODI is the only ETL platform that can leverage the full power of Exadata, integrate directly on the Exadata machine without any additional hardware, and by far provides the simplest setup and fastest overall performance on an Exadata system.

We regularly see customers achieving a 5-10 times boost when they move their ETL to ODI on Exadata. For  some companies the performance gain is even much higher. For example a large insurance company did a proof of concept comparing ODI vs a traditional ETL tool (one of the market leaders) on Exadata. The same process that was taking 5hrs and 11 minutes to complete using the competing ETL product took 7 minutes and 20 seconds with ODI. Oracle Data Integrator was 42 times faster than the conventional ETL when running on Exadata.This shows that Oracle's own data integration offering helps you to gain the most out of your Exadata investment with a truly optimized solution. 

GoldenGate is the best solution for streaming data from heterogeneous sources into Exadata in real time. Oracle GoldenGate can also be used together with Data Integrator for hybrid use cases that also demand non-invasive capture, high-speed real time replication. Oracle GoldenGate enables real-time data feeds from heterogeneous sources non-invasively, and delivers to the staging area on the target Exadata system. ODI runs directly on Exadata to use the database engine power to perform in-database transformations. Enterprise Data Quality is integrated with Oracle Data integrator and enables ODI to load trusted data into the data warehouse tables. Only Oracle can offer all these technical benefits wrapped into a single intelligence data warehouse solution that runs on Exadata.


Compared to traditional ETL with add-on CDC this solution offers:

  • Non-invasive data capture from heterogeneous sources and avoids any performance impact on source
  • No mid-tier; set based transformations use database power
  • Mini-batches throughout the day –or- bulk processing nightly which means maximum availability for the DW
  • Integrated solution with Enterprise Data Quality enables leveraging trusted data in the data warehouse

In addition to Starwood Hotels and Resorts, Morrison Supermarkets, United Kingdom’s fourth-largest food retailer, has seen the power of this solution for their new BI platform and shared their story with us. Morrisons needed to analyze data across a large number of manufacturing, warehousing, retail, and financial applications with the goal to achieve single view into operations for improved customer service. The retailer deployed Oracle GoldenGate and Oracle Data Integrator to bring new data into Oracle Exadata in near real-time and replicate the data into reporting structures within the data warehouse—extending visibility into operations. Using Oracle's data integration offering for Exadata, Morrisons produced financial reports in seconds, rather than minutes, and improved staff productivity and agility. You can read more about Morrison’s success story here and hear from Starwood here.

I also recommend you watch our on demand webcast on Zero-Downtime Migration to Oracle Exadata Using Oracle GoldenGate: A Customer Case Study and download free resources on Oracle Data Integration products to learn more about their powerful architecture and solutions for data-driven enterprises.

Friday Jun 21, 2013

What Comes Next After You Decide on Using Oracle Exadata

As Oracle Exadata continues to expand its footprint for both transaction and analytical processing, moving existing systems to Exadata and feeding it with enterprise data on an ongoing basis have become important discussion topics for Exadata customers. Consolidation and migration is the first step of this powerful journey with Exadata, and I'd like to start there in today's blog post.   

The systems that benefit from Exadata's extreme performance and reliability are typically business-critical systems that carry major risks when it comes to migration. Any downtime or data loss can have significant impact to the business in terms of revenue generation, customer loyalty, and productivity. As Oracle GoldenGate user community knows well, GoldenGate's heteregenous, real-time, and bidirectional replication capabilities enable very strong zero downtime migration and consolidation solutions for major databases and platforms including Oracle, IBM DB2 (zOS, iSeries, and LUW), HP NonStop, SQL Server, Sybase ASE, MySQL, and Teradata.

We discussed GoldenGate's zero downtime migration to Exadata offering and best practices with our customer IQNavigator in a webcast that is now available on demand:

Zero-Downtime Migration to Oracle Exadata Using Oracle GoldenGate: A Customer Case Study

If you have not watched it, I highly recommend listening to the discussion, as it clearly explains there should be no concerns around causing business interruption when moving to Oracle Exadata using GoldenGate.  GoldenGate's failback option to the old environment is a great tool for minimizing risk and many organizations adopt that approach for their business-critical systems.  

In addition to migration to Oracle Exadata, customers use GoldenGate, and Oracle Data Integrator, with Exadata in a variety ways leveraging the natural fit between these technologies:

  • Active-active database synchronization across the globe for data distribution, continuous availability, and zero downtime maintenance purposes.
  • Real-time or near real-time data loading to data warehouse, or consolidated database, on Oracle Exadata from heterogeneous sources. Oracle Data Integrator plays the major role in this use case as it integrates with GoldenGate and loads data warehouse in near real-time after performing transformations within the Exadata machine. This use case will be another blog topic soon as it is a strong best practice for performing ETL/ E-LT for Exadata.
  • Moving change data from an OLTP application running on Exadata in real time, for downstream consumption by other systems including supporting service integration.

As additional resources on best practices for migrating to Exadata I'd like to point you to couple of great white papers: Zero-Downtime Migration to Oracle Exadata Using Oracle GoldenGate and Oracle GoldenGate on Exadata Database Machine.

Tuesday Apr 02, 2013

Starwood Hotels Presents in Customer Success Forum on April 11th

Register before April 5th for the online Customer Success Forum with Starwood Hotels and Resorts (April 11th 11am ET), and ask questions about how they used Oracle Exadata, Oracle GoldenGate, and Oracle Data Integrator for data warehousing and operational reporting.[Read More]

Thursday Dec 20, 2012

ODI 11g - Loading More Files Faster

This post shows you how to leverage more of your Oracle system, you can load more data and faster using these kind of best practices. The LKM here, lets you leverage the Oracle database's preprocessor to load MORE data faster. The KM also has the capability to leverage a regular expression to identify the file or files so that you can load much much more, it also sorts the files based on size to comply with the most efficient way of loading into Oracle via the external table. The preprocessor can basically do anything, but is commonly used to uncompress data on the fly - so you can eliminate transferring large uncompressed files around or needlessly uncompressing them! There are various creative blog posts around showing you what some customers have done - some even include the transfer in the preprocessing phase.

I posted the LKM on the java.net site here

You can see the LKM configured below, I have used the preprocessor and a regular expression to load all gzipped files in the directory; 

When the code is generated below you can see the PREPROCESSOR directive used, plus you can see that the file names are going to be generated from a Java API call where the regular expression and directory are passed.

My gunzipdb.bat script has the following definition, wrappering the gzip utility (note the use of the -d -c directives);

  • @echo off
  • c:\ext_tab_test\gzip -d -c %1

Check this creative use of the PREPROCESSOR directive here (External table to load compressed data residing on remote locations) which does some creative work in the preprocessing script. This could do pretty much anything you want including transforming from some complex file to project through an external table.

Wednesday Oct 17, 2012

And the Winners of Fusion Middleware Innovation Awards in Data Integration are…

At OpenWorld, we announced the winners of Fusion Middleware Innovation Awards 2012. Raymond James and Morrison Supermarkets were selected for the data integration category for their innovative use of Oracle’s data integration products and the great results they have achieved.

In this blog I would like to briefly introduce you to these award winning projects.

Raymond James is a diversified financial services company, which provides financial planning, wealth management, investment banking, and asset management. They are using Oracle GoldenGate and Oracle Data Integrator to feed their operational data store (ODS), which supports application services across the enterprise. A major requirement for their project was low data latency, as key decisions are made based on the data in the ODS. They were able to fulfill this requirement due to the Oracle Data Integrator’s integrated solution with Oracle GoldenGate.

Oracle GoldenGate captures changed data from different systems including Oracle Database, HP NonStop and Microsoft SQL Server into a single data store on SQL Server 2008. Oracle Data Integrator provides data transformations for the ODS. Leveraging ODI’s integration with GoldenGate, Raymond James now sees a 9 second median latency (from source commit to ODS target commit).

The ODS solution delivers high quality, accurate data for consuming applications such as Raymond James’ next generation client and portfolio management systems as well as real-time operational reporting. It enables timely information for making better decisions.

There are more benefits Raymond James achieved with this implementation of Oracle’s data integration solution. The software developers and architects of this solution, Tim Garrod and Ryan Fonnett, have told us during their presentation at OpenWorld that they also reduced application complexity significantly while improving developer productivity through trusted operational services. They were able to utilize CDC to generate alerts for business users, and for applications (for example for cache hydration mechanisms).

One cool innovation example among many in this project is that using ODI's flexible architecture, Tim and Ryan could build 24/7 self-healing processes. And these processes have hardly failed. Integration process fixes the errors itself. Pretty amazing; and a great solution for environments that need such reliability and availability. (You can see Tim and Ryan’s photo with the Innovation Awards trophy above.)

The other winner of this year in the data integration category, Morrison Supermarkets, is the UK’s 4th largest grocery retailer. The company has been migrating all their legacy applications on to a new-world application set based on Oracle and consolidating all BI on to a single Oracle platform. The company recently implemented Oracle Exadata as the data warehouse engine and uses Oracle Business Intelligence EE.

Their goal with deploying GoldenGate and ODI was to provide BI data to the enterprise in a way that it also supports operational decision making requirements from a wide range of Oracle based ERP applications such as E-Business Suite, PeopleSoft, Oracle Retail Suite. They use GoldenGate’s log-based change data capture capabilities and Oracle Data Integrator to populate the Oracle Retail Data Model. The electronic point of sale (EPOS) integration solution they built processes over 80 million transactions/day at busy periods in near real time (15 mins). It provides valuable insight to Retail and Commercial teams for both intra-day and historical trend analysis.

As I mentioned in yesterday’s blog, the right data integration platform can transform the business. Here is another example: The point-of-sale integration enabled the grocery chain to optimize its stock management, leading to another award: Morrisons won the Grocer 33 award in 2012 - beating all other major UK supermarkets in product availability. Congratulations, Morrisons,on another award!

Celebrating the innovation and the success of our customers with Oracle’s data integration products was definitely a highlight of Oracle OpenWorld for me. I look forward to hearing more from Raymond James, Morrisons, and the other customers that presented their data integration projects at OpenWorld, on how they are creating more value for their organizations.

Friday Oct 05, 2012

Hidden Gems: Accelerating Oracle Data Integrator with SOA, Groovy, SDK, and XML

On the last day of Oracle OpenWorld, we had a final advanced session on getting the most out of Oracle Data Integrator through the use of various advanced techniques.

The primary way to improve your ODI processes is to choose the optimal knowledge modules for your load and take advantage of the optimized tools of your database, such as OracleDataPump and similar mechanisms in other databases. Knowledge modules also allow you to customize tasks, allowing you to codify best practices that are consistently applied by all integration developers.

ODI SDK is another very powerful means to automate and speed up your integration development process. This allows you to automate Life Cycle Management, code comparison, repetitive code generation and change of your integration projects. The SDK is easily accessible through Java or scripting languages such as Groovy and Jython.

Finally, all Oracle Data Integration products provide services that can be integrated into a larger Service Oriented Architecture. This moved data integration from an isolated environment into an agile part of a larger business process environment. All Oracle data integration products can play a part in thisracle GoldenGate can integrate into business event streams by processing JMS queues or publishing new events based on database transactions.

  • Oracle GoldenGate can integrate into business event streams by processing JMS queues or publishing new events based on database transactions.
  • Oracle Data Integrator allows full control of its runtime sessions through web services, so that integration jobs can become part of business processes.
  • Oracle Data Service Integrator provides a data virtualization layer over your distributed sources, allowing unified reading and updating for heterogeneous data without replicating and moving data.
  • Oracle Enterprise Data Quality provides data quality services to cleanse and deduplicate your records through web services.

Monday Sep 24, 2012

Next-Generation Data Integration on Oracle Exadata

Companies are currently faced with increasing data volumes and retention times while simultaneously batch windows are shrinking. In the ‘Next-Generation Data Integration on Oracle Exadata’ session we will be discussing how Oracle with its innovative Data Integration solution along with Exadata can help companies tackle that challenge.

Oracle Data Integrator and Oracle GoldenGate provide industry-leading performance and scalability for data integration on Oracle Exadata. They are both uniquely designed to take full advantage of the power of the database and to eliminate unnecessary middle-tier components which can often be bottlenecks for data movement and transformation. Combined with the extreme performance provided by Exadata our Data Integration products help companies move towards a more efficient and flexible data integration infrastructure.


If you’re interested in hearing more about how our customers maximize the performance of their Exadata systems while minimizing batch windows, all without adding more hardware resources join us for the following session:

Next-Generation Data Integration on Oracle Exadata 

Thursday October, 4th - 11:15AM - 12:15PM

Moscone West – Room 3005

We also have many other exciting sessions including 'Oracle Data Integrator Product Update and Future Strategy' on October 2nd at 1:15PM in Moscone West Room 3005. In this session we will discuss the ODI roadmap and its integration with engineered systems such as the Oracle Big Data Appliance. It's a session not to be missed!

You can find a list of all the Data Integration sessions happening at Oracle OpenWorld in this document: Focus On Data Integration.

If you will not be able to come to OpenWorld, for more information please check out our data sheet Oracle Data Integration Solutions and the Oracle Exadata Database Machine.

Wednesday Mar 07, 2012

New productivity features in ODI 11.1.1.6: Global KMs, Variable tracking, Groovy Editor

ODI 11.1.1.6 introduces a number of features that make the everyday tasks of ELT developers easier. This blog explains the new features Global Knowledge Modules, Variable and Sequence Tracking, and Groovy Editor.

[Read More]

Sunday Feb 26, 2012

Total Economic Impact Report by Forrester: Oracle Data Integrator

See full size image

 

Oracle Data Integrator has proven customer success when it comes to bulk data movement and tranformation.  Forrester Consulting has produced a compelling report that illustrates just how Oracle Data Integrator delivers on its promise of low Total Cost of Ownership, high ROI, stellar performance and reduced project times.  This study is based on interviews with an Oracle Data Integrator customer as well as Forrester's Total Economic Impact methodology.  Don't miss this unique webcast and hear about ODI's results and all about -  "Revolutionizing Economic Impact with Oracle Data Integrator" on February 28, 2012, 10 AM PT/1PM ET.  Learn how ODI can help your organization achieve operational and capital savings for bulk data movement and transformation. Register now http://bit.ly/z0gXRa

Tuesday Dec 06, 2011

A Customer Case Study: Zero Downtime Migration to Oracle Exadata Using Oracle GoldenGate

IT service continuity is a strategic goal for IT organizations, especially when it comes to mission-critical systems. A common interruption to IT services is planned outages such as system migrations, upgrades, consolidation etc. Because they can be planned, IT teams typically schedule them to "off business" hours to minimize impact on end users. 

What happens when you don't have long enough "off business hours" and need to upgrade your system to support the business? This issue comes up quite often with customers that have have critical systems with close to 24/7 up-time requirement and they decide to move to a new system such as Oracle Exadata. Exadata is a great fit for mission-critical systems with its extreme performance and reliability. When moving to this new, modern platform majority of companies have to plan carefully for the migration process with a focus on avoiding business interruption and minimizing the risks involved with the migration effort.

IQNavigator, the leading services procurement solution provider, is one of these many customers that needed a robust solution to eliminate downtime and minimize risks when moving to Exadata. The company chose Oracle GoldenGate to migrate to Oracle Exadata without downtime and with minimal risk. I am very happy to announce that next week we will be able to hear their story directly from IQNavigator's CEO of Emerging Markets and CTO, John F. Martin

  On December 15th 10am PT we will host a live webcast Zero Downtime Migration to Oracle Exadata Using Oracle GoldenGate: A Customer Case Study to share IQNavigator's implementation of GoldenGate for migrating to Exadata. Oracle's VP of Product Management/Development for Data Integration, Alok Pareek, will present about Oracle's real-time data integration offering for Oracle Exadata, as well.

    If you have plans to move to Oracle Exadata or have any other upgrade/migration project for your critical systems, I strongly recommend joining this webcast to learn how you can use GoldenGate for:

  • Real-time data replication between heterogeneous systems to eliminate downtime
  • Active-Active database synchronization for phased migration to minimize risk
  • Real-time data feeds into Oracle Exadata for reporting with timely information
  • Reliable real-time data synchronization for the standby system

To join this free & live webcast on December 15th you can register here.


Friday Sep 30, 2011

Improving Data Warehouse Performance and Accuracy with Oracle GoldenGate and Oracle Exadata

Data warehouses are becoming a critical system for day-to-day operations, and many users, including customers, rely on the fast and accurate information that data warehousing solutions provide. With the exponential data growth IT systems are experiencing in today’s information age, delivering high performance data warehouses with accurate data is becoming more and more challenging for many lT organizations.

At OpenWorld we will hear about one of biggest data warehousing solutions in the telecommunications industry in Europe. Turkcell, a leading European GSM-based mobile communications operator, implemented Oracle Exadata and Oracle GoldenGate for their enterprise data warehouse to achieve the performance and reliability that their business needs. The data warehouse has several data marts with customer-specific information and provides its 34 million customers with accurate information.The data warehouse is fed from several often changing sources and Oracle GoldenGate is used to capture data changed from each production source and maintain more-up-to-date data for the data warehouse.

At OpenWorld, we will hear from Turkcell how they maximized the performance of their data warehouse and improved data accuracy using Oracle Exadata and GoldenGate.If you will be at OpenWorld next week, you can attend this session:

Data Warehouse Performance and Accuracy at a Telco with Oracle GoldenGate

Tuesday, October 4th 11:45 AM

InterContinental Hotel - Telegraph Hill Room

As a reminder, you can find out about other Data Integration Track sessions here and you can follow our updates and reminders for the Data Integration track via our Facebook and Twitter accounts.

Thursday Sep 29, 2011

Get hands-on with Oracle Data Integrator!

If you are visiting Oracle OpenWorld next week, you will have ample opportunity to see the latest Oracle Data Integrator live in action and work with it yourself. We will have the following hands-on labs in the Marriott Marquis - Salon 1/2:

  • Introduction to Oracle Data Integrator (Monday 2-3pm)
    See how easy it is to load and transform heterogeneous data from files, XML, and multiple databases.
  • Oracle Data Integrator and Oracle GoldenGate (Monday 3:30-4:30pm)
    Combine the best of both worlds to load real-time data into your Data Warehouse!
  • Data Integration with Oracle Business Intelligence (Thursday 10:30-11:30am)
    Do you know where your data is from? See the complete ODI data lineage from within OBIEE.

These hands-on labs fill up quickly ahead of time, so register yourself now to get a spot!

We also demo these use cases and more at our Demogrounds pods 253, 254, and 255 (highest 8-bit number, easy to remember...) at Moscone South, right side. At our pods you can see:

  • Loading a data warehouse with Oracle Data Integrator
  • Realtime data warehousing with Oracle Data Integrator and Oracle GoldenGate
  • Integrating Oracle SOA Suite with Oracle Data Integrator
  • Data Lineage from Oracle Data Integrator to Oracle BI
  • Loading Big Data into Exadata
  • Data Masking during Loads
  • Data Federation using Oracle Data Service Integrator

Wednesday Sep 14, 2011

Oracle Data Integration on Exadata: an Unbeatable Combination

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:

  1. 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.

Tuesday Jun 07, 2011

Zero Downtime Migration to Oracle Exadata with Oracle GoldenGate

System upgrades, migrations, consolidation and maintenance activities are fact of life in today’s IT environment, as companies strive to achieve higher performance, scalability and flexibility. Those activities typically require a “planned outage" and for systems that support global operations or require 24/7 availability even a planned outage can be disruptive to business.

Currently we see a great demand from customers for consolidating their databases to Oracle Exadata. As they embark on these projects, they also seek a solution to avoid interrupting availability of their business-critical systems, as it can significantly impact revenue, productivity, and customer satisfaction. Oracle GoldenGate’s real-time, heterogeneous data replication capabilities come very handy in these migration and consolidation projects. It synchronizes old environment, for example DB2, SQL Server or an earlier version of Oracle Database, with the new Oracle Exadata system in real time. While the new environment is prepared and tested, Oracle GoldenGate captures every new transaction from the production system and delivers to Oracle Exadata as soon as it is ready. Once the systems are in sync applications and users can be pointed to the Exadata system immediately without any downtime.

One recent customer that chose Oracle GoldenGate for migration to Exadata is e-Dialog. They are part of GSI Commerce Inc., and provide integrated digital marketing solutions to businesses worldwide. When their message volumes for multichannel marketing and campaign analytics services started to increase rapidly they decided to move to Exadata to achieve higher performance. At the same time they had to ensure business continuity during the migration as any outage would impact their customers’ access to their services. They used Oracle GoldenGate to complete the migration in phases over six months. Oracle GoldenGate’s bidirectional replication capabilities allowed e-Dialog to run the legacy system along with Exadata concurrently. I invite you to read more about e-Dialog success story to learn how Oracle GoldenGate enables successful migration to Oracle Exadata.

About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
23
24
25
26
27
28
29
30
   
       
Today