Database replication refers to the processes of creating and maintaining multiple copies of a database, or synchronizing database objects between two or more databases. Companies use database replication to improve the performance and availability of their databases and the applications that depend on them, incorporate new technologies into their IT infrastructure, and enable data analytics on non-production systems.
Although some companies continue to rely on a database-vendor provided database replication tool to implement and manage database replication processes, more companies are discovering the flexibility and efficiencies provided by database-agnostic data replication software. DBAs that have long struggled with their existing toolset are enjoying the simplicity, cost-savings, and convenience of powerful new data replicationsolutions.
In the enterprise, database replication is commonly used to offload data from the main transactional database to another database for operational reporting or analytics purposes, and to enable distributed processing of data. Database replication is also implemented to create a database or system for testing or failover purposes, consolidate data from multiple sites, share data among geographically dispersed users or remote offices, or migrate data from a legacy mainframe or database to a new or different type of environment on premises or in the cloud.
Database replication enables enterprises to:
Qlik Replicate (formerly Attunity Replicate) is a powerful database-agnostic platform for data replication and ingestion that is easier to use, less intrusive, and more affordable than database vendor-provided replication tools like Oracle GoldenGate or IBM'S DB2 SQL replicationtool.
Replicate features a zero-footprint architecture—minimizing impact on IT operations—and an intuitive graphical user interface. With Replicate, there's no need to install replication agents on source or target databases. And setting up and implementing replication processes is remarkably simple via our Click-2-Replicate designer, which eliminates the need for manual coding and advanced database replication skills. Our web-based management console can be accessed from anywhere and simplifies the user experience by automating the steps required to define, configure, and manage replication jobs.
Equipped with our TurboStream change data capture technology, Replicate automates incremental replication of data changes—eliminating data processing bottlenecks and enabling real-time data integration for reporting, analytics and other use cases that benefit from having the freshest possible data.
Suitable for Oracle database replication and SQL Server database replication, Qlik Replicate (formerly Attunity Replicate) provides a simple and universal integration platform for all major databases, data warehouses, legacy and Hadoop environments, on premises and in the cloud.