Table of Contents
Table of Contents
1Table of ContentsChapter 1: Ahead of the Curve 3Chapter 2: All Your Data 7Chapter 3: Anywhere 11Chapter 4: Uninterrupted 15Chapter 5: Real-Time Data Integration 17Chapter 6: With Trusted Data 21Chapter 7: Only from Oracle 23Resources 252
Future-Ready Data Integration
Data integration is the foundation for many IT initiatives including cloud computing, modernization, and big data analytics. Formerly seen as a background technology for transporting data around, it has vaulted to the top of the CIO agenda as a must-have technology for innovative IT environments.
The reason for this shift is clear: Data integration technology gives you a common, consistent way to link, transform, and manage many types of information so that you can obtain a more complete picture of your business. As Baratunde Thurston writes in Fast Company, “If the prevalence of chatter about big data is any indicator, data has evolved from something we collect with the vague promise of future value to something we analyze to retrieve that value.”
Where does that value come from? In many cases it comes from combining that data in unique ways. It comes from integration.
To address future requirements, you need to be able to handle any type of data, from any source—on premises or in the cloud. That data must be continuously available, error-free, and up to date.3
Starwood Hotels is a prime example for leveraging timely trusted information for creating value. As business accelerated for the North American hotel chain, it was taking longer and longer to access data from central reservation systems to those OLTP applications and external vendors that needed it.
With the implementation of Oracle Data Integration, Starwood Hotels can complete high performing extract, transform, and load (ETL) operations for real-time reporting. Real-time feeds, which were not possible before, now allow transactions to be posted immediately to the data warehouse, and users can access the changes in 5 to 10 minutes instead of 24 hours, making the process up to 288-times faster.4
Accelerated data access allows all Starwood properties to get the same, up-to-date data needed for their reports, globally. Previously, hotel managers in some areas could not do same-day or next-day analyses. There were some locations that got fresh data and others that got older data. Hotel managers, worldwide, now have up-to-date data for their hotels, increasing efficiency and profitability, improving customer service by making sure rooms are available for premier customers, and improving the company’s ability to manage room occupancy rates. Additional reporting tools, such as those used for CRM and sales and catering also benefited from the improved processing. Other critical reporting has benefited as well.
Whether you need bulk data integration, data transformation, real-time data replication, or data quality, Oracle Data Integration solutions hold the answers. Oracle has constructed a layered suite of technology that delivers pervasive and continuous access to timely and trusted data across heterogeneous systems. Capabilities include real-time and bulk data movement, transformation, bidirectional replication, data services, big data integration, data virtualization, and data quality for customer and product domains.5
As you will see in the remainder of this e-book, companies in every industry depend on Oracle’s modern data integration technology to achieve pervasive and continuous access to trusted data.6
Any Data, Any Source
Decision-makers need timely, accurate information to create value for the enterprise. Obtaining that information and delivering it in a useful format is becoming progressively more difficult as the volume, velocity, and variety of data escalates. Unlike yesterday’s data management architecture, where data was modeled, structured, and stored in relational tables, today’s data comes from many different sources and appears in many different forms such as web pages, social media sites, e-mail exchanges, search indexes, click streams, sensor data, and all types of multimedia files including audio, video, and photographic.
Large, unstructured data stores don’t offer much insight until you can unlock the patterns and apply the learnings to other sources of enterprise data. Data integration technology holds the key.
For example, sentiment data can tell you if a particular individual likes or dislikes your company. To understand why these opinions matter, you need to also relate them to customer records in your CRM applications, e-commerce systems, and web tracking systems. By correlating all of this data, you can obtain a more complete view of your customer, such as what they purchased, what they are about to purchase, and how they are influencing other people in your customer database.7Video: Caixa Bank implemented Oracle Big Data infrastructure to maximize business value of any kind of dataWatch the Video (2:36)
Business innovation is a critical success factor in today’s highly competitive banking environment. CaixaBank, the leading bank in the Spanish market, has implemented a strategic Big Data project with the objective of maximizing the business value of any kind of data, regardless of its type or origin. Using Oracle’s Big Data solution, which includes Oracle Data Integrator and Oracle Big Data Appliance, Caixa Bank built a unified, agile, powerful and secure data repository (Data Pool), from which any informational business request can be easily and rapidly answered. The Data Pool allows a faster decision making process, as well as the implementation of new competitive banking services.
When SK Telecom became the first mobile communications operator in Korea to introduce rate plans with unlimited data usage, they experienced a large increase in usage data. The company implemented Oracle Data Integrator to integrate data from three back-end systems into a data billing analysis system on Oracle Exadata Database Machine, attaining extremely fast data integration capabilities. Managers use Oracle Business Intelligence Suite to glean insights about billing, roaming, and trends in mobile internet usage, improving the customer experience.8
With help from Oracle Data Integrator, SK Telecom achieved average data processing rates that are 8 to 20 times greater than those seen with other in-house systems. They also delivered performance that was two to three times higher for real-time ETL processes and established an environment for processing approximately 40 billion transactions per day. This versatile architecture keeps managers apprised of changes in customer usage and preferences, helping them develop strategies to grow the business.Report: The Economist Intelligence Unit conducted a global survey of 373 senior executives, sponsored by Oracle and Intel. When asked about the key data challenges they faced, 43 percent of the respondents said they lacked effective systems to gather and analyze data.Read the Report9
Oracle Data Integrator has all of the necessary capabilities to support big data projects that require the integration of structured, semistructured, and unstructured data. For example, it includes a unified design environment for developing MapReduce transformations, for transforming structured data, and for developing Hive-based transformations, all in a single utility. You can also run big data transformations that integrate directly with Oracle Loader for Hadoop to merge data into and out of Hadoop environments.
Oracle’s big data solution includes multiple systems handling data acquisition, loading, storage, management, analysis, integration, and presentation so that you can quickly extract value from big data with integrated analytics. Oracle Data Integration tools make it easy to tackle big data analytic problems with engineered systems such as Oracle Big Data Appliance and Oracle Exalytics.10
On-Premise or in the Cloud
How can you access all relevant enterprise data, regardless of the source or originating format, and integrate it across social, mobile, and cloud technologies?11
Data integration solutions play a vital role in connecting on-premises information systems to cloud-based information systems. These solutions hold the answers to many pressing problems. According to independent research conducted by Dynamic Markets, 83 percent of companies say they aren’t getting the right insight out of their departmental cloud applications, and one in four of these companies claim that the reason is poor integration. Half of these companies have abandoned departmental cloud apps in the last three years due to integration problems.112
“Companies have abandoned roughly one cloud app a year due to integration problems.”An Independent Report: Cloud for Business Managers: the Good, the Bad, and the UglyRead the Report
Today, vast majority of industry leaders are adopting hybrid cloud architectures to reduce cost and increase agility. BT is one of the many companies that partnered with Oracle to move to the cloud. BT uses Oracle GoldenGate to migrate data from legacy systems to the cloud with a fallback option. The solution supports optimal customer experience with availability, reliability and scalability.“The Oracle Data Integration tool set is one of the cornerstones in how BT is actually going to get to the cloud.”Surren Partabh, CTO Strategic Technology Services, BT13Video: BT discusses cloud migration and Oracle Data Integration 12cWatch the Video (2:39)
Zero downtime consolidation via real-time data replication is the preferred strategy for many other leading organizations when moving to the cloud. FedEx implemented an Oracle-based private cloud environment to increase IT service quality, reduce complexity, lower costs, and improve agility. To consolidate its distributed database assets into this private cloud, FedEx used Oracle GoldenGate to migrate approximately 480 databases in five data centers onto a standard architecture. FedEx is completing this migration with minimal application downtime and no interruption to essential business operations.14
Continuous Performance—Without Fail
Most organizations have pressing needs to eliminate downtime, and those needs extend to back-office IT projects as well. System modernization and consolidation projects, in particular, must be executed without interrupting business operations. A high-availability strategy must not only address unplanned outages such as disasters; it should also eliminate downtime from planned outages such as maintenance and upgrades, as well as performance issues.
That’s why MediSwitch used Oracle GoldenGate to provide highly reliable services to its customers, boosting performance for routine business operations while bolstering its ability to respond to disasters and unexpected events.Video: “We look to Oracle for availability, stability, and speed of transactions, and to ensure industry-leading uptime for our electronic message switching solution.”Wayne Botha, IT Manager, MediSwitchWatch the Video (3:19)15
Performance remains a perennial requirement, especially for fast-paced organizations with a growing number of users and large volumes of data. Data integration technology has proven its ability to solve common problems such as the performance degradation that invariably results when read-only applications must access a production environment.
Herbalife uses Oracle GoldenGate to replicate ERP data to two target systems for global reporting and e-commerce lookups in real time. The solution allows offloading operational reporting from Herbalife’s primary production systems and frees up valuable CPU resources. This real-time integration architecture supports reporting and e-commerce lookups for 2 million distributors in 75 countries. Up-to-date data is there the instant people need it.Video: “GoldenGate is nonintrusive, easy to implement, and it doesn’t put any restrictions on the target system.”Angshuman Ghosh, Sr. Manager, Database Operations, HerbalifeWatch the Video (3:09)16
Data at the Speed of Thought
Today’s always-on economy has effectively eliminated the concept of the business day. The Internet of Things and the interconnectedness of all computing devices are pushing a greater volume and variety of data into business operations. This data needs to be acted on instantaneously to deliver maximum value. As data latency increases, the information becomes less relevant and its value diminishes. Heightened customer expectations and the growth of customer touchpoints also require businesses to be more responsive. Managers are intent on capturing and responding to business events faster, more accurately, and more knowledgeably than ever before.
This sense of urgency takes place in the IT department as well, especially as it tries to complete batch processing jobs with a growing amount of data. The time window available for processing this data shrinks as more and more business applications must run around the clock, even as the volume of data that must be processed during these batch windows continues to grow. No wonder 40 percent of executives say their infrastructure is not able to handle the growing data volumes and 53 percent of executives say critical information is delivered too late.2
2 Aberdeen Group, January 2012, survey of 247 executives: Data Management for BI―Big Data, Bigger Insight, Superior Performance.17
Paychex is avoiding this scenario with real-time data integration architecture for centralizing payroll reporting for its customers. The leading payroll services provider deployed Oracle Data Integrator and Oracle GoldenGate on Oracle Exadata, and created a one-stop-shop for its customers to access critical reports with near real-time data from all their enterprise applications. This flexible reporting environment with low-latency data differentiates Paychex in the market, and raises service quality for its customers.Video: Oracle Delivers Real-Time Data Integration for PayChexWatch the Video (2:33)18
Some organizations use real-time data integration to support high-volume, nonstop operations by offloading reporting from production systems. BT uses Oracle GoldenGate and Oracle Data Integrator to extract, transform, and load data to a reporting database for use by senior management.“By offloading queries we have seen a 15 to 20 percent improvement in the performance of our production environment.”Vipul Patel, Platform Designer, BTVideo: Learn how BT keeps its data fresh and relevant for reporting and analysis.Dhananjay Papde, Principal Consultant, BTWatch the Video (2:48)
Fast Data Fuels Immediate Action
To maximize the economic value out of dynamically changing data, companies need to minimize the duration between the business event and its consequent action. Most of the latency is introduced between the initial acquisition of the event data and its delivery to the analytical environment. By shortening this gap, you can produce greater value by acting right away.19
Reducing latency is an especially important goal for today’s mobile apps. For example, SFpark enables San Franciscans to easily find spaces in city-owned parking garages. The award-winning application uses Oracle Service Bus and other Oracle Middleware technology to display up-to-the-second information from meters, parking sensors, and garages, as well as to share real-time data with other agencies and the public. Real-time data and demand-responsive pricing work together to help people find parking spaces and reduce congestion by impacting parking patterns throughout the city.Case Study: "The principles behind SFpark are conceptually simple though technologically complex: First, provide real-time information to people looking for parking about where spaces are available. Next, tweak the price of parking in relation to demand so that there are always at least a few spaces available everywhere."Minda Zetlin, Profit MagazineRead the Case Study20
High-Quality and Error-Free
Reliable, timely, trusted, and high-quality data is essential for conducting business. Bad data can quickly populate numerous systems, compromising all types of business initiatives. Not only do internal systems depend on accuracy, but also regulatory compliance initiatives necessitate tracing the source of the data used in financial reports, as well as the examination, tracking, and certification of the associated business data.
Oracle Enterprise Data Quality enables organizations to measure, improve, and manage the quality of data from any domain, including customer and product data, and minimize exposure to risk. Oracle’s data quality products identify and correct flaws in the data with powerful data profiling, cleansing, matching, and monitoring capabilities.Video: "The best part of the tool is that it is easy for the business to use it and to put in the rules"Paritesh Sharma, Strategic Manager, Zebra TechnologiesWatch the Video (2:41)21
Zebra Technologies, a global leader in barcode printing, decided to reduce bad data, eliminate inefficient processes, and achieve higher data quality standards. The company implemented Oracle Enterprise Data Quality to centralize all business rules for data quality operations. Zebra Technologies’ business teams can easily use Oracle Enterprise Data Quality without technical expertise, and they actively and happily participate in data governance.
By avoiding cleaning up dirty data and handling issues in downstream processes, the company was able to save over $650,000. Zebra Technologies’ IT team also uses Oracle Enterprise Data Quality for transactional data validation and on boarding new companies after mergers and acquisitions.
Data quality technology also plays a huge role in preventing financial fraud. Barclays uses a data quality solution called Oracle Watchlist Screening to verify transactions from 48 million customers. The centrally governed solution accommodates all of Barclays’ global offices, accurately identifying sources of risk by rectifying typos, misspellings, transpositions, and other data-entry errors. The solution helps ensure that the bank only conducts business with sanctioned customers and has reduced false positives by 40 percent.22
The New Leader in Data Integration
Data integration has become a critical enabler to improve the accessibility, timeliness, and quality of mission-critical data. With real-time and bulk data movement, bidirectional replication, big data transformation, data services, metadata management, data virtualization, and cloud data integration capabilities, Oracle combines all of the best-of-breed technical elements into a unified, multipurpose platform that functions with remarkable efficiency and reliability.
The new releases of Oracle’s data integration products, Oracle Data Integrator 12c and Oracle GoldenGate 12c, advance Oracle’s leadership in the market even further. Both Oracle GoldenGate 12c and Oracle Data Integrator 12c introduced new features that deliver higher IT productivity and extreme performance, and have deeper integration that enables end-to-end real-time data integration in a single platform. In addition, Oracle’s data integration products have tighter integration with other Oracle technologies, including Oracle Database, Oracle Coherence, and Oracle Applications, enabling faster time to value and streamlined solutions for customers. This flexible and robust offering helps organizations easily keep pace with new data-oriented technology trends, including cloud computing, big data analytics, and real-time replication.23Video: Learn about Oracle Data Integration 12c in this exciting overview by Brad Adelberg, Vice President of Development.Watch the Video (43:30)
Oracle’s future-ready data integration products enable you to leverage any data, from any source, at any latency—on premises or in the cloud—with zero downtime and maximum performance. No other vendor offers such a complete set of data integration capabilities for pervasive, continuous access to trusted data across Oracle platforms as well as third-party systems and applications. Join thousands of other organizations as you embrace Oracle Data Integration 12c to transform your business and position for the future.24
ResourcesWhite PapersVideosCase StudiesArticles and ReportsWebcasts and PodcastsWebsitesServices and SupportSocial Media
- White Paper: Oracle Data Integrator 12c Key New Features
- White Paper: Oracle GoldenGate 12c Release 1 New Features Overview
- White Paper: Data Integration Architectures for Operational Data Warehousing
- White Paper: Demystifying Data Integration for the Cloud
- White Paper: Oracle GoldenGate 12c: Real-Time Access to Real-Time Information
- White Paper: Zero-Downtime Migration to Oracle Exadata Using Oracle GoldenGate
- White Paper: Big Data and Enterprise Data: Bridging Two Worlds with Oracle Data Integration
- Video: RBS Takes Smarter Risks Using Real-Time Data Integration (2:21)
- Video: Griffith University Streamlines Student Enrollment (1:52)
- Video: Accenture & Oracle Help CaixaBank Succeed with Big Data (2:36)
- Video: National Pharmacies Uses ODI for Its Data Warehouse (2:11)
- Video: Wm Morrison Supermarkets Plc Improves Performance on Exadata (1:42)
- Video: Oracle Delivers Real-Time Data Integration for PayChex (2:34)
- Video: Rittman Mead Evaluates Oracle Data Integrator 12c (14:13)
- Video: Thomson Reuters (1:46)
- Video: Raymond James Uses Oracle Data Integration for Central ODS (3:24)
- Video: Turkcell Deploys Oracle Data Integrator to Drive Efficiency (2:06)
- The Italian Air Force Supports Air Operations with Real-Time, Mission-Critical Information
- Raymond James Financial Drives Smarter Operational Decisions with Oracle
- Ministero del Lavoro e delle Politiche Sociali Consolidates Data Warehouse, Supporting More Effective Labor Policy Through Accurate Analytics
- Starwood Hotels & Resorts Worldwide Delivers More Competitive Rates and Offerings by Accessing Reservation Data Updates 233x Faster
- Vodafone Shortens Application Access Provisioning by 90%, Integrates Applications 50% Faster, and Cuts Operating Costs by 15%
- LIFE Financial Group Empowers 5,000 Managers to Make Better Decisions, Faster—Integrates 30 Source Systems to Boost Quality of Financial Analytics
PodcastsOracle Services helps you deploy and optimize your Oracle technology to enable the success of your Oracle investments - throughout your IT lifecycle - and across the complete Oracle stack. From strategy and architecture, to managing upgrades, migrations and implementations, to ongoing support and education, Oracle Services can help you take advantage of best practices and technology to get the most from your Oracle investment.Copyright © 2013, Oracle and/or its affiliates. All rights reserved.25
- Webcast: How to Future Proof your Big Data Integration Solution
- Webcast: Oracle GoldenGate for the Enterprise and Cloud
- Webcast: Big Data Governance and Metadata Management
- Webcast: Data Integration for Big Data-- Introducing Big Data Reservoir
- Webcast: Zero Downtime Consolidation to Oracle Database 12c with Oracle GoldenGate 12c
- Launch Webcast: Introducing 12c for Oracle Integration Products
- Webcast: Putting Data to Work Using Oracle Enterprise Data Quality