Can high-performance database replication deliver quick time-to-value even faster for Oracle customers?

By now, Attunity has established the fact that its database replication product, Attunity Replicate, is a high-performance data replication solution supporting a wide range of data sources and targets. As the ROI report by Nucleus Research states, “With Attunity, one organization was able to reduce the data management update process from 10 hours to 20 minutes”, there is no doubt that Attunity Replicate can deliver quick time-to-value for any data integration project.

But is it possible to achieve even better results and raise the expectations even higher? Yes, it is! With every new release of Attunity Replicate, Attunity strives to improve the customer experience, add new sources and targets to its support matrix and tighten the integration with already-supported platforms. Attunity Replicate is no exception from its predecessors when it comes to raising the bar. In this release, major effort was invested to improve Attunity Replicate integration with the Oracle database, and it paid off in spades.

Oracle Replication

When accessing an Oracle database source using the Bfile Reader API to read the transaction logs in an environment with very high transaction rates or throughput, Attunity Replicate now supports:

  • Greatly improved performance when accessing redo logs that are stored in ASM.
  • Capturing change data from Transparent Data Encrypted (TDE) tablespaces by specifying the encryption key (stored in the Oracle Wallet) that was used to encrypt the tablespaces.
  • Oracle 12c as Multitenant Architecture that allows a multi-container database to hold single or many pluggable databases.
  • Capturing changes directly from archive logs, moving archived redo logs to a temporary folder and reading the files directly from there for faster file-level access to changes.

There are also significant performance enhancements, up to 40% improvement, when targeting an Oracle database and particularly Oracle Exadata. A new option was added to use Oracle’s Direct Path Load when loading data to Oracle. Using this configuration option eliminates much of the database overhead by formatting data blocks and writing them directly to the database files when loading large amounts of data with Attunity’s TurboStream CDC.

But this is not all! One of the major enhancements of Attunity Replicate 4.0 is its integration with Attunity Maestro. Attunity Replicate is designed from the ground up to scale and support large-scale enterprise data replication scenarios with a multi-server, multi-task, and multi-threaded architecture. But in order to alleviate the burden of designing and managing complex data flow configurations across the enterprise, Attunity Replicate relies on Attunity Maestro, a highly-scalable platform that orchestrates and automates the data transmission and deployment processes of Big Data projects.

When Attunity Replicate is deployed in conjunction with the Attunity Maestro platform, it alleviates the burden of designing and managing complex business processes by providing a single point of control for defining, executing and monitoring data transfer and distribution tasks throughout an organization.

Organizations can install multiple replication servers, each of which can run many replication tasks. Each one can be managed and monitored by a single Attunity Maestro Center, allowing control and automation of processes throughout the IT landscape.

This enterprise-grade platform comes packaged with a web-based monitor that enables users to instantly view the status of replication servers and tasks using a dashboard. This dashboard presents metrics, gauges, and alert notifications. Using a browser, users can view and manage the system from anywhere, making it easier than ever before to control data (e.g. start/stop/reset replication tasks). In addition, logs are produced to support enterprise management systems.

 

In this article:

Comments

Get ready to transform your entire business with data.

Follow Qlik