Release Notes

SharePlex® 12.1

Release Notes

Revision: 8/5/2025

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.

New Features

What's New in this Release

The following new features, enhancements and platforms are supported in this release.

Technical feature enhancements

The following technical feature enhancements are supported in this release.

Oracle to Parquet file replication on Linux

SharePlex now supports direct replication from Oracle databases to Apache Parquet files on Linux.

This enhancement provides:

• Efficient, columnar data storage optimized for analytics workloads.

• Schema mapping and data type conversion between Oracle and Parquet formats.

File-to-Cloud storage platform integration - Oracle to Parquet file

SharePlex adds support for cloud-based file storage systems from Oracle to Parquet file, enabling replication to:

• Amazon S3 and Azure Blob Storage.

• Configurable endpoints with authentication via IAM roles or access keys.

• Data partitioning and compression options during replication.

Copy command - Oracle to Parquet file

The Copy command offers:

• Bulk data transfer between source and target systems.

• Greater control over replication workflows, including initial data loads.

Copy/Append command – Oracle to PostgreSQL

SharePlex now supports the Copy/Append command for Oracle to PostgreSQL.

It provides:

• Flexible table synchronization or migration from Oracle to PostgreSQL using copy (truncate & load) or append (load without truncation).

• Supports wildcard selection, multiple target configurations, and advanced performance tuning options such as thread management, compression settings, and buffer size adjustments.

Compare and Repair features - PostgreSQL to Oracle

Added support for the compare and repair commands for PostgreSQL to Oracle replication on Linux, providing the following capabilities:

• Validate synchronization between source and target tables, including schema-wide comparisons using wildcards.

• Detect and repair out-of-sync rows caused by DML operations (INSERT, UPDATE, DELETE), with support for UTF8 and Latin1 character sets across PostgreSQL and Oracle.

• Leverages advanced filtering, comprehensive sanity checks, and configurable options for specialized scenarios such as peer-to-peer replication, partitioned tables.

High Availability Failover with Capture auto restart for PostgreSQL

SharePlex now supports High Availability on PostgreSQL 17, offering the following capabilities:

• Utilizes PostgreSQL 17 failover slots to maintain logical replication across failovers, ensuring uninterrupted operation and preventing data loss.

• Supports automatic restart of capture process during HA failover using the SharePlex parameters SP_CAP_MAX_RETRY_COUNT_PG and SP_CAP_RETRY_INTERVAL_PG.

• SharePlex supports HA failover with PG17 [failover property], RDS Multi A-Z cluster environment, Azure flexible PoststgreSQL and HA configured using Crunchy data, Petroni, and repmgr.

SpClient – Windows monitoring utility

Users can now monitor SharePlex logs and processes on Windows using the SpClient utility, which provides the following features:

• Monitors SharePlex processes and event logs on Windows, with support for alerts and email notifications in case of failures.

• Enables configurable health checks (default interval: every 60 seconds) managed through the sp_NT_mon file.

• Includes a user interface (Sp Monitor) for real-time status monitoring, which requires sp_cop to be running and authenticates via sp_remote.

Enhanced performance of the SharePlex Open Poster

Enhanced performance of the SharePlex Open Poster during batch processing operations.

Cryptographic operations using the OpenSSL FIPS provider

To align with CMVP (Cryptographic Module Validation Program) guidelines and strengthen data security, SharePlex now supports cryptographic operations using the OpenSSL FIPS provider on Linux platform. This enhancement ensures that AES encryption algorithms used within SharePlex are executed through a validated cryptographic module, meeting FIPS 140-2 standards.

Platform support

The following new platforms are supported in this release.

• Windows 2025

• MYSQL 8.4

Resolved Issues and Enhancements

Resolved Issues in this release

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

Deprecated Platforms and Operating Systems

Platforms or operating systems that have been deprecated in SharePlex 12.1 version:

CentOS Linux 7.x

Planned platform deprecation in future releases:

No platforms are anticipated to be deprecated at this time.