Data is in a constant state of change. To keep up, enterprises need to rethink how they manage their data. Change Data Capture is one solution that can help in this area.
Today’s enterprises rely on their data to power business performance and fuel business growth. With the volume of data generated growing exponentially, the way you process and manage your data becomes more critical. For example, organizations need to export data to other locations, such as consolidated repository data warehouses or data lakes, for analytics or other mission-critical purposes. But doing so without impacting operational efficiency and database performance is a significant challenge.
Historically, exporting data has been done in a recurrent batch process, causing the resulting analytics to be outdated. Additionally, if the replication process is pulling all of the data to the data warehouse, this is very inefficient both in terms of processing and time spent to complete the process.
Change Data Capture (CDC), which is available as a part of OpenEdge 11.7, can help enterprises minimize the time and effort it takes to keep their databases current. CDC enables businesses to capture the changes made within the OpenEdge database during a specific time period. This means enterprises can replicate only the changed data to all of their data sources, increasing the efficiency of the replication process as well as the overall database and application performance.
There are a lot of benefits to using a CDC solution. From an OpenEdge perspective, CDC will capture the data regardless of whether it’s an ABL update; a create, update, or delete function; or a SQL create, update or delete function—it’s one single solution.
CDC is very flexible in terms of configuration. You can capture any data at the field level if it changed. It’s easy to modify as well through either a browser-based solution, or by programmatically going through and modifying what’s being captured based on the policy information. The data is stored on a change table (or a shadow table) as it were, with the same data type and structure of the original data without converting it to any other types of fields.
Lastly, one of the more important benefits of CDC is that you don’t have to change your application to run CDC against your database. So, zero application changes are required to start capturing that data.
Speed is critical in today’s digital business environment—exporting data in a daily batch process is no longer an effective way to keep databases up to date. OpenEdge CDC facilitates accurate, efficient synchronization with other data sources and data warehouses without any downtime or major performance hitches.
At Progress, our goal is to deliver agile solutions that enable you to embrace change and turn it into a competitive advantage. This is why we made CDC a core focus of OpenEdge 11.7. However, CDC is only one major enhancement of the OpenEdge 11.7 release. Curious about what else OpenEdge 11.7 has to offer? Check out the top 5 reasons to upgrade to OpenEdge 11.7.
Dan is a Principal Sales Engineer for Progress and has been with the company for 12 years. He spent the 14 years prior to that at OpenEdge partner firm NxTrend Technology. Dan works with some of our largest direct customers and partners, helping them develop strategies that allow them to continue to take advantage of Progress technologies.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.