SAP Solution Brief
SAP Solutions for Enterprise Information Management SAP Data Services
Enable Timely, Accurate Business Intelligence with
Real-Time Change Data Capture
Benefits Solution
Objectives Quick Facts
AP affiliate company. All rights reserved.
Objectives
Inform decisions with real-time information management
In today’s fast-paced business climate, companies need real-time data for analyses and decision making. SAP® Data Services software offers a single source of truth by consolidating data from diverse databases to inform enterprise decision making. SAP Sybase® Replication Server® adds real-time change data capture functionality for a current, complete picture of
your business.
Many enterprises rely on SAP Data Services for sophisticated transformation, enrichment, and delivery of data from multiple data sources to target destinations such as data warehouses.
Using the change data capture edition of SAP Sybase Replication Server, SAP Data Services makes those data warehouses even more valuable. With real-time change data capture, the software continuously captures and transmits data changes from multiple sources to multiple targets, including SAP platforms and data warehouses.
By combining SAP Data Services with real- time change data capture, SAP delivers on the promise of the real-time enterprise.
Your mission-critical business intelligence applications receive a continuous flow of accurate, up-to-the-minute data from opera- tional systems. With this comprehensive information platform, you can identify trends as they emerge and decide how to seize opportunities for your competitive advantage – all in real time.
Inform decisions with real-time information management
Benefits Quick Facts
Solution
Improve operations and analytics with fresh enterprise data
While data warehouses can provide an enter- prise-wide view to better guide decisions, frequently that view is hours or even days old.
To thrive in this business climate, you need up-to-the-minute information that sheds light on business trends, operational issues, and market opportunities.
Until now, in order to update data warehouses, most organizations have relied on trigger- based or batch solutions. Such solutions refresh data on a scheduled basis, or in response to specific activities, but lack the ability to update continuously. There’s always
a delay – and depending on the organization, this delay could mean missed business oppor- tunities, lost revenue, or financial exposure.
There is a better way. SAP Sybase Replication Server – a proven replication solution – employs real-time change data capture to virtually eliminate this delay. Real-time change data capture functionality captures changes and transactions from the database log, as they occur, and immediately replicates them to SAP Data Services for data transfor- mation and loading into your data warehouse.
Old data can lead to lost opportunities and bad decisions.
Real-time change data capture helps you make decisions based on what’s real, right now.
Improve operations and analytics with fresh enterprise data
Access and understand complex operational data in real-time Gain greater insights while systems run at peak performance
Minimize administration and lower total cost of ownership
Proven in mission-critical environments
Solution Benefits
Objectives Quick Facts
Access and understand complex operational data in real-time
SAP Data Services provides sophisticated data transformation, enrichment, and delivery functionality that turns operational data into high-quality, usable business information.
Most large organizations have many databases and multiple database platforms, as well as unstructured data from sources such as Apache Hadoop. SAP Data Services creates a central repository for key business data by extracting data from these heterogeneous systems, transforming it into a unified format or schema to help ensure quality, and loading the transformed data into the data warehous- es. This synchronization allows key business applications to present information to users in a relevant, context-rich format.
Real-time change data capture functionality enhances the extraction phase of this process. Instead of waiting for each database to provide scheduled updates to SAP Data Services, the functionality captures data changes as they occur and immediately provides them to SAP Data Services for transforming and loading as appropriate.
The combined solution integrates all your data in a meaningful way – and helps ensure that users see actionable, up-to-the-second information.
Benefits Solution
Objectives Quick Facts
Improve operations and analytics with fresh enterprise data
Access and understand complex operational data in real-time Gain greater insights while systems run at peak performance
Minimize administration and lower total cost of ownership
Proven in mission-critical environments
Gain greater insights while systems run at peak performance
The real-time change data capture edition of SAP Sybase Replication Server does not impact the performance of your production systems and applications – a significant advancement from the way legacy batch or trigger-based systems behave. Legacy systems read data from the database itself, negatively impacting database and applica- tion performance; the database can’t process transactions at peak speeds if it’s also responding to read requests.
Real-time change data capture avoids such performance degradation by reading data from the database log only – so database
and application performance is completely unaffected. By providing continuous updates, this solution also eliminates data latency issues across the enterprise.
Automation and ease of administration of SAP Data Services and SAP Sybase Replication Server further enhance performance. The combined solution virtually eliminates the delays and errors that can occur when orga- nizations try to manage, extract, transform, and load processes manually or with homegrown scripts.
Benefits Solution
Objectives Quick Facts
Improve operations and analytics with fresh enterprise data
Access and understand complex operational data in real-time
Gain greater insights while systems run at peak performance
Minimize administration and lower total cost of ownership
Proven in mission-critical environments
Database log reports let you watch what’s going on in
your online transaction processing (OLTP) databases –
without sacrificing performance levels.
Minimize administration and lower total cost of ownership
Because it is so easy for IT to capture changes from all your databases on a continuous basis, the real-time change data capture edition of SAP Sybase Replication Server helps to significantly reduce total cost of ownership (TCO). SAP Sybase Replication Server is designed to be a single, straightforward tool that works seamlessly with SAP Data Services to automatically generate scripts. It elimi- nates the need for IT to schedule database batch programs, write scripts, save data, or perform other specialized administrative tasks. Once set up, the real-time data platform runs without ongoing administrative effort.
To further improve TCO, the real-time change data capture edition also incorpo- rates SAP Sybase PowerDesigner® software, a robust data-modeling tool that minimizes the resources and expertise necessary to set up and maintain the whole solution.
IT doesn’t need to write a single line of code, since the software can automatically gener- ate replication scripts and purge old data from runtime databases.
Benefits Solution
Objectives Quick Facts
Improve operations and analytics with fresh enterprise data
Access and understand complex operational data in real-time Gain greater insights while systems run at peak performance
Minimize administration and lower total cost of ownership
Proven in mission-critical environments
With real-time change data capture, you don’t need to
write a single line of code. The solution runs itself,
saving both time and administrative costs.
Proven in mission-critical environments
The change data capture edition of SAP Sybase Replication Server is a key technology that has been in use for more than 20 years in mission-critical real-time environments.
Plus, SAP Data Services is one of the world’s leading data integration and data quality offerings and has been proven in thousands of customer implementations across diverse industry sectors.
As an SAP solution, SAP Sybase Replication Server is certified and integrated with the SAP Data Services environment, helping to ensure a fast and straightforward implemen- tation process. When you select SAP Data Services along with the change data capture edition of SAP Sybase Replication Server, you get two proven products in a unified data platform – all from a single supplier. The solution delivers the advantages of proven technologies, plus the ongoing convenience and reliability of one-stop maintenance and support.
Benefits Solution
Objectives Quick Facts
Improve operations and analytics with fresh enterprise data
Access and understand complex operational data in real-time Gain greater insights while systems run at peak performance
Minimize administration and lower total cost of ownership
Proven in mission-critical environments
Data assets are vital to the success of your organization, so protect them and entrust them to SAP’s proven data management solution.
01001010111010010 10100101000101010 01001010001011101 00101010010100010 10100100101000101
Seize the moment ‒ run your business on real-time data
Today’s businesses operate in a fast-moving environment, where opportunities and threats emerge and change rapidly. Success depends on being able to respond “in the moment,” dodging pitfalls, and seizing every chance to increase sales, build the brand, and outpace the competition.
With SAP Data Services and SAP Sybase Replication Server providing a real-time information management platform, you know exactly what’s going on, as it happens. SAP Data Services can help your organization make full use of its data assets, wherever they are and whatever format they’re in.
The availability of real-time changed data capture functionality from SAP Sybase Replication Server takes your platform to the next level, giving your business users not just data access, but actionable, up-to-the-second insights.
Real-time changed data capture lets your business make timelier, more-informed decisions, because it enables you to base those decisions on current data. Because you can see opportunities and threats as they emerge, you can respond with a level of agility that wasn’t possible before – helping you succeed like never before.
Seize the moment ‒ run your business on real-time data
Benefits Solution
Objectives Quick Facts
Latin America pension fund giant Grupo Sura uses
SAP Data Services with change data capture to
identify cross-selling opportunities as they occur.
Summary
SAP® Data Services software and the change data capture edition of SAP Sybase®
Replication Server® transforms disparate enterprise data sources into a valuable business asset that helps your organization identify and respond to opportunities and threats in real time. With extract, transforma- tion, and load functionality on a proven data platform, and continuous real-time updates to that platform, your data warehouses accurately reflect the current state of the business. SAP Sybase PowerDesigner®
software further simplifies administration for an even lower TCO.
Objectives
• Supply data warehouses and analytics solutions with real-time data
• Enable business agility
• Maintain OLTP performance
• Minimize TCO
Solution
• Real-time data capture accurately reflecting the state of the business
• Log-based replication limiting overhead on OLTP performance
• Comprehensive, consistent data platform fully leveraging data assets
• Support for heterogeneous data sources
• Ease of administration for maximum reliability and lower TCO
Benefits
• Understand and respond to business changes in real time
• Maximum business value thanks to leveraging of data assets
• Eliminate data risks with a solution proven in hundreds of implementations
• Confident decision making based on a single source of truth
Learn more
To find out more about SAP Data Services and SAP Sybase Replication Server, visit us online at www.sap.com.
www.sap.com
Objectives Solution Benefits Quick Facts© 2013 SAP AG or an SAP affi liate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG.
The information contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
National product specifi cations may vary.
These materials are provided by SAP AG and its affi liated companies (“SAP Group”) for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials.
The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.
Please see http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.
