Oracle Cloud Infrastructure as a Service (IaaS) Compute Virtual Machine is now supported as a target.
SharePlex 9.2.4 is a patch release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.
SharePlex 9.2.3 is a minor release and includes resolved issues. See Resolved Issues and Enhancements for a complete list.
SharePlex 9.2.1 is a minor release and includes the following new features and enhanced functionality.
Support for Binary Collations in SQL Server to SQL Server Replication. This release includes support for BIN and BIN2 binary collation in SQL Server to SQL Server replication.
Note: Binary collations are not supported only in SQL Server to SQL Server replication. Binary collations are not supported in SQL Server to Oracle replication.
Support for SQL Server Native Client ODBC. SharePlex now supports the Microsoft SQL Server Native Client ODBC driver.
Database Support. This release of SharePlex includes support for the following database versions:
Oracle 18c. This release includes support for capture from and replication to Oracle 18c.
Note: SharePlex does not support replication of DML operations on objects compressed using OLTP Compression in Oracle 18c. This limitation applies to objects in the source database.
Kafka 1.1.x. This release includes support for replication to a Kafka 1.1.x target.
Operating System Support. This release includes support for SuSE SLES 15.
SharePlex installer packages for Linux/Unix. SharePlex installer packages for Linux/Unix are now database independent. You are no longer required to select an installer package based on the database for which SharePlex will be used (i.e., Oracle or Open Target). To install SharePlex for Oracle or Open Target, simply select the installer package for your operating system.
The SharePlex installer packages now have a slightly different naming convention:
For Oracle Solaris (Sun), the operating system version is included:
SharePlex 9.2 is a minor release and includes the following new features and enhanced functionality.
Oracle UROWID data type. Support has been added for the Oracle UROWID data type. This support applies to Oracle-to-Oracle configurations only.
Support for SCN metadata for HANA target. This release of SharePlex supports posting the Oracle SCN to a column in a HANA target table.
Oracle replication to MySQL 5.7. SharePlex supports replication from an Oracle source to a MySQL 5.7 target on-premises.
Support for 128-byte table and column names. In Oracle capture, SharePlex now supports table and column names that are up to 128 bytes in length. Please note the following limitations applicable to this release.
Support for Peer-to-Peer Replication Strategy for SQL Server.SharePlex now supports the peer-to-peer replication strategy for SQL Server databases. See the SharePlex 9.2 Administration Guide for more information about configuring peer-to-peer replication. SharePlex provides a prepared routine which you can use to perform basic conflict resolution.
Support for 128-byte table and column names. In SQL Server capture, SharePlex now supports table and column names that are up to 128 bytes in length.
Support for SQL Server 2017. This releases includes support for capture from SQL Server 2017 on Windows and replication to SQL Server 2017 on Windows or Linux.
SQL Server replication to Amazon Aurora PostgreSQL. SharePlex can replicate from SQL Server on-premises to Amazon Aurora with PostgreSQL Compatibility.
Support for Windows Server 2016. Support for capture from and replication to databases on Microsoft Windows Server 2016.
Improved Performance in the Post Process.
The following enhancements were made to improve performance of the Post process.
New jobs status database
Simplified SharePlex Installation Process on Windows
This release of SharePlex includes a new typemap command, as well as changes to the default data type mappings. Review the following details.
TLS 1.2 (or later) required for TLS connections. If you intend to use TLS connections in SharePlex, TLS 1.2 or later is required.