Chat now with support
Chat with Support

SharePlex 11.2 - Release Notes

Release Notes

SharePlex® 11.2

Release Notes

Revision: 8/5/2024

 

About SharePlex

For over two decades, SharePlex has provided high speed database replication for mission critical database environments.

SharePlex supports a wide variety of configurations to meet different and complex data availability needs. A primary class of use cases revolves around database scaling and availability.

  • SharePlex supports reliable Oracle and PostgreSQL high-availability and disaster recovery configurations where replication maintains a duplicate database in a different location that is ready for fast, seamless fail-over and failback in planned or unplanned mode.

  • SharePlex also supports bi-directional, active/active configurations with conflict resolution for PostgreSQL to PostgreSQL and Oracle to Oracle to support horizontal scaling and strategic placement of databases near regional users.

  • SharePlex can support cross platform (Oracle ← → PostgreSQL) bi-directional, active-active replication with conflict resolution to de-risk Oracle to PostgreSQL migrations in complex Oracle environments.

  • SharePlex can improve scaling by offloading Oracle or PostgreSQL reporting workloads.

Another class of use cases involves (generally) cross-platform data movement to support application integration, database interoperability and data lake population. Examples include:

  • PostgreSQL and/or Oracle replication to Snowflake to support data warehouse/data lake pipelines

  • PostgreSQL and/or Oracle replication to Kafka for real-time streaming analytic applications

  • PostgreSQL to Oracle (or) Oracle to PostgreSQL replication to provide interoperability between systems to support database refactoring or migration from Oracle to PostgreSQL.

You can also use SharePlex to replicate data from Oracle source to maintain a change history database in an Oracle target. Rather than updating or deleting target rows based on the source change, SharePlex inserts a new row on the target for every source change. The result is an archive that reflects the chronological history of every change made to the source database.

SharePlex's value and versatility continue to grow with the requirements and requests of our customers. Although SharePlex is a reliable, relatively low-maintenance solution, our top-rated support team is ready around the clock to help with any trouble you may have. To get you started with your deployment, our professional services team is highly experienced and readily available.

Join our community

For expert advice and the latest news about SharePlex, join the SharePlex Community at https://www.quest.com/community/products/shareplex. Take advantage of our forums, blogs, videos, and more from our own experts, as well as input from our customers and partners.

About this release

In this release, SharePlex supports the latest versions of PostgreSQL DB at the source and target, as well as SQL Server database as a target. The release also includes support for PostgreSQL Database as a service on Google Cloud Platform.

Revision History

Document Version Date Change History
2 18th September 2023
3 3rd October 2023
  • Added the BOOLEAN, TIME, and BYTEA data types in the Supported data types section for various targets .

  • Added the list of supported data types for replication from PostgreSQL or PostgreSQL Database as a Service to Oracle when conflict resolution is configured.

4 19th November 2023 Removed information related to the support for Oracle 23c. As per Oracle's announcement, the Oracle-supported release of 23c Database On-premises, Exadata, and Exadata Database Service should be available in FY'24. SharePlex support for OCI Oracle Base Database Service is planned in a future release.
5 4th December 2023
6 28th February 2024

Updated the licensing related information in the Licensing section.

7 5th March 2024 Added an important note regarding OLS policy configuration in the Conditions of Support - OLS section.
8 6th May 2024
9 17th May 2024

Added Oracle 21c as a supported database for OLTP compressed data.

10 5th August 2024 Added a limitation regarding the replication of data containing the ALTER statement during DDL operations.

New Features

What's New in this Release

Database support

  • This release includes support for PostgreSQL 15.x as a source and target.

  • This release includes support for SQL Server 2022 as a target.

Google Cloud platform support

This release includes support for PostgreSQL Database versions 14.x and 15.x as a service on Google Cloud Platform.

Resolved Issues and Enhancements

Resolved Issues in this release

The following is a list of issues addressed in this release of SharePlex.

Issue ID Known Issues Source and Target Component/ Feature
SPO-24752

The SharePlex Poster process stops with the 'ORA-04016' error while replicating a sequence from Oracle to Oracle.

Oracle to Oracle Poster

 

 

 

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating