Chatta subito con l'assistenza
Chat con il supporto

SharePlex 12.1 - Upgrade Guide

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

 

 

 

 

 

 

 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione