Release Notes

SharePlex® 11.4

Release Notes

Revision: 8/13/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 Compare and Repair commands for the PostgreSQL database as both a source and target. Additionally, SharePlex also supports the following database versions and operating systems:

• PostgreSQL 16 and PostgreSQL Enterprise Database (EDB) 16 as source and target

• Kafka 3.3 and 3.6.1 as target

• JMS Apache ActiveMQ 5.16.7

• JMS IBM MQ 9.3

• Snowflake 8.1 as target

• RHEL (Red Hat Enterprise Linux) 9.x

Revision History

New Features

What's New in this Release

Compare/Repair commands support:

SharePlex now supports the Compare and Repair commands for PostgreSQL database as both a source and a target.

Data Types support:

SharePlex now supports the JSON and JSONB data types for PostgreSQL to PostgreSQL replication.

Note: JSON and JSONB data types are supported only with logical replication.

Snowflake Performance Enhancement:

SharePlex now supports the replication of bulk updates and deletes for the Snowflake database as a target, excluding the following advanced data types:

• RAW, LONGRAW, BLOB, CLOB, NCLOB, BINARY_FLOAT (for Oracle databases)

• CHAR(2000), VARCHAR(4000), TEXT, BYTEA (for PostgreSQL databases)

Database/Platform Support:

• This release includes support for PostgreSQL 16 and PostgreSQL Enterprise Database (EDB) 16 as both a source and a target.

• This release includes support for Kafka 3.3 and 3.6.1 as a target.

• This release includes support for the following JMS message Queues:

  • Apache ActiveMQ 5.16.7

  • IBM MQ 9.3

• This release includes support for Snowflake 8.1 as a target.

Operating System support:

This release includes support for RHEL (Red Hat Enterprise Linux) 9.x.

Other features:

• This release includes support for Azure Flexible Server with high availability using logical replication.

• This release includes support for communication protocol TLS 1.3 for all supported Unix platforms.

• This release includes support for Docker containers.

Resolved Issues and Enhancements

Resolved Issues in this release

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