Chat now with support
Chat with Support

SharePlex 9.2.5 - Upgrade Guide for Oracle Source

New Features in this Release

SharePlex 9.2.4

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

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

SharePlex 9.2.1 is a minor release and includes the following new features and enhanced functionality.

New Features for SQL Server Source

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.

Other New Features

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.

Installation

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:

SharePlex-release#-build#-platform-chipset.tpm

For Oracle Solaris (Sun), the operating system version is included:

SharePlex-release#-build#-platform-version-chipset.tpm

SharePlex 9.2

SharePlex 9.2 is a minor release and includes the following new features and enhanced functionality.

New Features for Oracle Source

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.

Oracle 12c R2 Support

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.

  • UDT column names more than 30-bytes in length are not supported.
  • Type names for UDTs and VARRAYS with names more than 30-bytes in length are not supported.
  • IOT names more than 30-bytes in length are not supported.

New Features for SQL Server Source

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.

New Parameters

  • SP_CAP_REPLICATE_POSTER. This new parameter can be used to specify whether or not to exclude from SQL Server Capture the data posted by the SharePlex Post process. This is useful in a peer-to-peer replication strategy to prevent looping. See the SharePlex 9.2 Reference Guide for a description of this parameter. By default, this parameter is set to ignore transactions performed by the Post process.

Other New Features

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.

  • Implemented multi-threading for SQL Server and PostgreSQL targets: The Transaction Concurrency component of Post Enhanced Performance has been extended to support SQL Server and PostgreSQL targets. A new parameter, SP_OPX_THREADS, controls this feature. When set to a value of 2 or greater, Post runs with the specified number of threads (concurrent operations).
  • Batch similar operations: To maximize its performance when applying SQL operations to the target, the Post process groups smaller replicated operations into one larger batched operation. Post groups replicated operations when the operations are identical and the SQL is similar. A new parameter, SP_OPX_BATCH_ENABLE, controls this feature and is enabled by default. Another new parameter, SP_OPX_MAX_BATCH_MBYTES, controls the maximum size of the batched DML operation that Post applies to the target. This supports databases, such as Teradata, that have a maximum transaction size and can be used for other purposes where batch size must be changed.

New jobs status database

  • This release includes a new jobs status database. This database resides in the data sub-directory of the SharePlex variable-data directory. The parameter SP_SYS_JOB_HISTORY_SIZE allows you to control the size of this database. Use this parameter to specify the maximum size (in kB) allowed for the database.

Simplified SharePlex Installation Process on Windows

  • When installing on Windows, you are no longer required to specify the Oracle database version or specify whether or not you are installing in a non-Oracle environment.
  • You no longer need to manually change the default setting for Global Resources memory in the MKS Toolkit after you install SharePlex on a Windows system. The setting is now modified automatically during installation.

Data Type Mapping

This release of SharePlex includes a new typemap command, as well as changes to the default data type mappings. Review the following details.

  • Use the typemap show command to display all default data type mappings. Use typemap show source-target to display the mapping for the specified source-target combination, for example oracle-sqlserver. See the SharePlex 9.2 Reference Guide for more information about using the typemap command.
  • Use the typemap command instead of the data type option of the target command. (The data type option of the target command has been discontinued in this release.)
  • For a list of supported data types, see Supported data types: Oracle to Open Target or Supported data types: SQL Server to Oracle and Open Target.

Other Changes in SharePlex

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.

Related Documents