On March 7, 2023, StreamSets, a subsidiary of Software AG, announced that it now supports the processing of change data capture (CDC) information from Oracle Data Guard deployments. This support for an additional data source offers a reliable and efficient way of developing data integration pipelines using CDC for production databases.
CDC captures and propagates database changes in near real-time, which reduces the time required to make new data available for analysis. This functionality is critical for rapidly updated data or replication scenarios with minimal latency. StreamSets enables data engineers to capture CDC information from Oracle Data Guard, efficiently replicating and synchronizing data to cloud destinations, such as AWS or Snowflake, for analytics and reporting.
Oracle Data Guard is also used as a disaster recovery solution, allowing data engineers to maintain a standby database in sync with the primary database in the event of primary database failure, which reduces the risk of data loss and recovery time, particularly for critical business systems. StreamSets users can leverage this new capability to replicate and synchronize data efficiently, ensuring high availability in the event of failures, a crucial consideration when constructing CDC pipelines for production databases. In addition, these pipelines can be utilized with modern data platforms such as Snowflake, allowing for streamlined reporting and enabling data-driven decision-making.
StreamSets COO Products Dima Spivak commented, "Keeping up with the fast-paced demands of today's data-driven world requires real agility." He further emphasized, "Organizations must be able to access, replicate, and synchronize their data securely and efficiently. This latest enhancement to our platform makes that easier than ever before."
(Source – PR Web)
About StreamSets
StreamSets, a subsidiary of Software AG, simplifies data integration in hybrid and multi-cloud environments to meet the growing demand for business data. The platform enables data teams to access data while retaining control, empowering enterprises to make data-driven decisions. StreamSets delivers reliable and repeatable pipelines that provide analytics-ready data for faster real-time decision-making while also reducing the costs and risks associated with data flow within an organization. The platform has gained the trust of the world's largest companies, powering millions of data pipelines for modern analytics, smart applications, AI/ML and hybrid integration.