Platforms or operating systems that have been deprecated in SharePlex 11.4 version:
Oracle Solaris x86 11.3
Note: While SharePlex 11.x only supports installation on Unix and Linux platforms, a version that supports Windows will be provided in the future. As such, the Windows platform is not considered deprecated. In most cases, replication for systems running on Windows is supported through remote replication. Please see Source and Target System Requirements and Data Types for details.
Planned platform deprecation in future releases:
No platforms are anticipated to be deprecated at this time.
This chapter contains the basic system requirements for SharePlex. See also: Source and Target System Requirements and Data Types
Before installing SharePlex, ensure that your system meets the minimum hardware and software requirements.
For TLS connections, SharePlex supports TLS 1.2 or 1.3 only.
SharePlex supports IPv4 and IPv6 internet protocols. The following table shows the operating systems for which SharePlex was tested with IPv6.
Operating System |
Source |
Target |
SharePlex versions |
On-premises |
Cloud |
---|---|---|---|---|---|
Linux RHEL 7 |
Link-Local IPV6 |
Link-Local IPV6 |
11.0 and above |
√ |
√ |
Linux RHEL 8 |
Link-Local IPV6 |
Link-Local IPV6 |
11.0 and above | √ |
√ |
Linux RHEL 9 |
Link-Local IPV6 |
Link-Local IPV6 |
11.4 | √ |
√ |
HP UA |
Link-Local IPV6 |
Link-Local IPV6 |
11.0 and above | √ | √ |
HP IA |
Link-Local IPV6 |
Link-Local IPV6 |
11.0 and above | √ | √ |
SUN Sparc |
Link-Local IPV6 |
Link-Local IPV6 |
11.0 and above | √ | √ |
SUN Solaris |
Link-Local IPV6 |
Link-Local IPV6 |
11.0 and above | √ | √ |
AIX |
Link-Local IPV6 |
Link-Local IPV6 |
11.0 and above | √ | √ |
Refer to the following guidelines if the system where you are installing SharePlex is in a configuration where one or more other systems will continue to use an older version of SharePlex. An example is when installing or upgrading SharePlex on a target, but the source will continue to use SharePlex 9.4.x/10.x.
Versions with interoperability for Oracle database as a source
The following SharePlex versions are interoperable for Oracle database as a source, including the Compare/Repair feature:
Notes:
|
To support replication from a higher to a lower version, set the SP_SYS_TARGET_COMPATIBILITY parameter on the source system to the lower SharePlex version. If Capture is running, restart it.
Important: Downgrading from a higher to a lower version of SharePlex is not supported.
Notes:
|
To reset SP_OCT_TARGET_COMPATIBILITY:
In sp_ctrl on the source system, issue the following command:
sp_ctrl>reset param SP_OCT_TARGET_COMPATIBILITY
Restart Capture.
sp_ctrl>start capture
The below table provides a list of features with their SharePlex version compatibility details with supported source and target databases.
SharePlex feature | Supported source database | Supported target database | SharePlex source version | SharePlex target version |
---|---|---|---|---|
Ability to replicate PostgreSQL timestamp to Oracle Date Unidirectional replication | PostgreSQL | Oracle | SharePlex 11.0 and above | SharePlex 11.1 and above |
Ability to replicate PostgreSQL timestamp to Oracle Date replication with BDR support | PostgreSQL | Oracle and PostgreSQL | SharePlex 11.1 and above | SharePlex 11.1 and above |
Activate config with LSN using user provided LSN | PostgreSQL* | PostgreSQL, Oracle, SQL Server, Kafka, Snowflake | SharePlex 11.1 and above | SharePlex 11.1 and above |
SharePlex PostgreSQL - show_last_posted utility - P2P | PostgreSQL* | PostgreSQL | SharePlex 11.1 and above | SharePlex 11.1 and above |
Support for High Availability cluster environment with CrunchyData | PostgreSQL* | PostgreSQL | SharePlex 11.1 and above | SharePlex 11.0 and above |
PG2O-O2PG BDR - SharePlex prepared routines - !MostRecentRecord, !LeastRecentRecord, !UpdateUsingKeyOnly, !HostPriority, !UpdateUsingKeyOnly | Oracle and PostgreSQL | Oracle and PostgreSQL | SharePlex 11.0 & Above | SharePlex 11.0 & Above |
Case sensitive column names | PostgreSQL | Oracle | SharePlex 11.1 & Above | SharePlex 11.1 and above |
PostgreSQL Database as a Service as source | PostgreSQL | PostgreSQL, Oracle, SQL Server, Kafka, Snowflake | SharePlex 11.1 and above | SharePlex 11.0 & Above |
Trigger scripts | PostgreSQL | PostgreSQL | SharePlex 11.1 and above | SharePlex 11.1 and above |
SharePlex PostgreSQL - config.sql and build_config.sql scripts | PostgreSQL | Not target dependent | SharePlex 11.1 and above | SharePlex 11.1 and above |
Implementation of the BOOLEAN data type | PostgreSQL | PostgreSQL, Oracle, Kafka, Snowflake | SharePlex 11.1 & Above | SharePlex 11.1 & Above |
Implementation of the TIME data type | PostgreSQL | PostgreSQL, Kafka, Snowflake | SharePlex 11.1 & Above | SharePlex 11.1 & Above |
Implementation of the BYTEA data type | PostgreSQL | PostgreSQL, Kafka, Oracle | SharePlex 11.1 & Above | SharePlex 11.1 & Above |
Support for column name > 30 characters | PostgreSQL, Oracle | PostgreSQL, Oracle, SQL Server, Kafka, Snowflake | SharePlex 11.1 and above | SharePlex 11.1 and above |
Support for Kafka Partition key | Oracle | Kafka | SharePlex 11.1 and above | SharePlex 11.1 and above |
Long table name | Oracle | PostgreSQL, Oracle, SQL Server, Kafka, Snowflake | SharePlex 11.0 and above | SharePlex 11.1 and above |
PostgreSQL Compression Algorithm with Physical replication** | PostgreSQL | PostgreSQL, Oracle, SQL Server, Kafka, Snowflake | SharePlex 11.0 and above | SharePlex 11.0 and above |
PostgreSQL Compression Algorithm with Logical replication** | PostgreSQL | PostgreSQL, Oracle, SQL Server, Kafka, Snowflake | SharePlex 11.1 and above | SharePlex 11.1 and above |
* These features are available only with PostgreSQL physical replication and not with PostgreSQL Database as a Service.
**Types of PostgreSQL Compression Algorithm:
pglz is supported with physical replication, where Capture receives data in compressed format and decompresses it.
pglz and lz4 are supported with logical replication, as decompression is done by the output plugin (pgoutput), and Capture receives data in decompressed format.
This chapter contains the requirements when capturing from various source databases and replicating to supported target databases.
The following table provides information about the supported source and target database combinations.
Target databases | Oracle (Source) | PostgreSQL (Source) | PostgreSQL Database as a Service (Source) |
---|---|---|---|
Oracle | √ | √ | √ |
PostgreSQL | √ | √ | √ |
SQL Server | √ | √ | √ |
JMS | √ | X | X |
Azure Event Hub | √ | X | X |
Hana | √ | X | X |
MySQL | √ | X | X |
Kafka | √ | √ | √ |
File Output | √ | X | X |
Snowflake | √ | √ | √ |
PostgreSQL Database as a Service | √ | √ | √ |
This chapter contains the requirements when capturing from an Oracle database and replicating to supported target databases.
Prerequisite: At least the minimum level of supplemental logging must be enabled. Some SharePlex features may require PK/UK supplemental logging to be enabled.
This section contains the requirements for an Oracle database as a source when capturing from an Oracle database and replicating to supported target databases.
The following operating systems are supported for capture from a supported Oracle database and replication to an Oracle target database. For a list of supported source and target databases for Oracle capture, see Supported Source and Target Combinations.
SharePlex supports only the 64-bit version of the listed operating systems.
Supported operating systems via native installation:
Note: SharePlex supports the following operating systems and only where the version matches the Oracle certified platforms. For example, Oracle 19c supports Linux 7 and later, therefore installation of SharePlex on a system with Oracle 19c is supported only on Linux 7 and later.
AIX 7.1, 7.2, and 7.3
CentOS Linux 7.x
HP-UX 11.31 Itanium
Oracle Linux 7.x and 8.x
Oracle Solaris SPARC 11.4
Oracle Solaris x86 11.4
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Rocky Linux 8.x
Supported operating systems via remote replication:
All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.
Important! SharePlex 11.0 and above versions can only be installed on Unix and Linux platforms.
A SharePlex version that can be installed on Windows will be supported in a future version. Customers with database platforms that run on Windows should consult the Installation and Setup for Remote Capture and Run database setup for Oracle remote capture sections from the Installation and Setup Guide for an Oracle Source for the Capture process and the Replicate to a remote target system section from the SharePlex Admin Guide for the Poster process that describe support for remote replication scenarios that may address your particular platform requirements. |
SharePlex supports the Standard and Enterprise Editions of Oracle 12cR1, 12cR2, 18c, 19c, and 21c.
Notes:
|
Oracle Cloud Infrastructure
Amazon Web Services
Microsoft Azure: Azure Virtual Machine (IaaS)
Oracle Exadata Cloud@Customer (ExaCC): Issues on Oracle Exadata Cloud@Customer will be tested against Oracle Exadata Cloud Service for reproduction purposes.
Oracle Database Cloud Service (DBCS): SharePlex only supports Transparent Data Encryption (TDE) feature on DBCS EE-HP, DBCS EE-EP, and ExaCS/CC.
Amazon RDS for Oracle: Please see Supported Oracle Source and Target Versions for additional clarification on version compatibility.
This is a list of commonly used Oracle features which SharePlex does not replicate and are not listed elsewhere in this document. Since both Oracle and SharePlex continually change and improve, this list of exclusions cannot be considered complete. Unless an item is stated here as being supported, assume that SharePlex does not replicate it.
Object/operation/feature | Not supported |
---|---|
Oracle operations | Operations that do not appear in the redo logs. This includes any DML or DDL not in the redo logs, and also PL/SQL packages which do not write results to the redo logs, for example, dbms_shared_pool.keep and related packages. |
dbms_scheduler.create_job |
This object is not supported. |
Flashback |
SharePlex does not support the Oracle Flashback Table feature. If the SP_REPLICATE_ALL_DDL parameter is enabled (value of 1), SharePlex may try to replicate the flashback DDL, which will return an error. To perform Flashback Table on a table that is in replication, use the following procedures
|
Notes about open target data type support
Replication of LOB operations generated by dbms_lob are not supported when replicating to non-Oracle targets.
SharePlex does not support the replication of data from Oracle to open targets for the below Extended Data Types:
The following table shows whether specific SharePlex features are supported for replication from Oracle to open targets.
SharePlex feature | Supported open targets |
---|---|
reconcile command (target instantiation) | All |
compare/compare using and repair/repair using commands | Not supported |
copy/copy using and append/append using commands | Not supported |
Hash horizontally partitioned replication | All |
Column-based horizontally partitioned replication | All |
Vertically partitioned replication | All |
Column mapping | All |
Key definition | All |
Build configuration with scripts | Not supported |
Named queues | All |
Commit Reduction (feature of Post Enhanced Performance) | All |
Dependency Checking (feature of Post Enhanced Performance) | Not supported |
Transformation | Not supported |
Conflict resolution |
PostgreSQL |
Peer-to-peer replication (bi-directional) | PostgreSQL |
Consolidated replication (many to one) | All |
Broadcast replication (one to many) | All |
High availability replication (active/passive bi-directional) | PostgreSQL |
Change tracking target (CDC) | Not supported |
Data encryption | All |
Data compression | All |
SSH | All |
auth_hosts file | All |
Monitoring scripts | All |
SNMP monitoring | All |
Continue posting on error (SP_OPX_CONT_ON_ERR) | All |
Suspend on out of sync errors (SP_OPX_OUT_OF_SYNC_SUSPEND) | All |
Reduced key (SP_OPX_REDUCED_KEY) | All |
Logical Transaction Rollback on out-of-sync transactions | Not supported |
HSM: Oracle database wallet key store on external storage using sp_hsm utility | All |
This chapter contains the requirements when capturing OLTP compressed data from an Oracle source database and replicating it to a supported target database.
The following operating systems are supported for capture from a supported Oracle database and replication to a supported target database.
SharePlex supports only the 64-bit version of the listed operating systems.
For OLTP, SharePlex supports the following operating systems only:
CentOS Linux 7.x
SuSE SLES 12.x and 15.x
HP-UX 11.31 Itanium
Rocky Linux 8.x
SharePlex supports the Standard and Enterprise Editions of Oracle 12cR1, 12cR2, 18c, 19c, and 21c for replicating the OLTP compressed data.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an Oracle or an open target.
Note: Replication to targets with a different character set is supported, with limitations. When posting to open target databases, XML files and JMS, SharePlex supports only UNICODE and US7ASCII on the target, but conversion can be performed by an Oracle client installed on the target system. For full details, see the Preinstallation Checklist in the SharePlex Installation and Setup Guide.
SharePlex supports the following DML operations on tables:
Direct-path loads (SQL*Loader) (INSERT AND FULL ROLLBACK).
Note: Replication of partial rollbacks of DLOADs is not supported.
The target table must support the column types that are being replicated from the source Oracle table.
SharePlex supports the following table types for DML operations:
Supported table type* |
Conditions of Support |
---|---|
Regular Oracle tables |
None |
Index-organized tables |
SharePlex does not support:
|
Partitioned tables |
None |
Views |
None |
Materialized views |
SharePlex does not support replication from a materialized view to a materialized view. SharePlex can replicate the underlying table of a materialized view to a regular target table. |
SharePlex does not support the following table types:
*SharePlex does not support the following for any table type:
SharePlex supports DML operations on secured or compressed objects as described in the following table. See "Conditions of support" following this table for additional information.
Secured/Compressed Object | Can be replicated to: |
---|---|
DML on tables encrypted by Oracle Obfuscation Toolkit | All target types |
DML on tables with Transparent Data Encryption (TDE)1 |
All target types |
DML on Oracle Label Security (OLS)2 |
All target types |
DML on compressed objects: Basic, Advanced Row (OLTP) Compression, HCC3 |
All target types |
Direct Load (DLOAD) on compressed objects: Basic, Advanced Row (OLTP) Compression, HCC3 |
All target types |
1. Conditions of support - TDE
SharePlex supports Tablespace Encryption and Column Encryption, both source and target.
The SharePlex copy/append command does not support TDE.
TDE is not supported for sources on RDS.
SharePlex only supports the AES and DES encryption algorithms.
2. Conditions of support - OLS
By default, SharePlex cannot process rows that are protected by OLS (Oracle Label Security) because users granted DBA privileges (like SharePlex) do not have enough privileges to access those rows. However, if privilege is granted from the OLSSYS user, SharePlex can support OLS. SharePlex was tested under the following OLS configuration:
Note: If the OLS policy data label column is defined as hidden, the data in that column cannot be replicated by SharePlex.
Important: Shareplex does not support OLS policy configuration changes on tables during active replication. Users need to apply these configurations before activating the configuration.
3. Conditions of support - compression
For HCC compression: SharePlex does not support query low compression. Supported types of compression are query high, archive low and archive high.
For Advanced Row (OLTP) Compression: Under certain conditions, Oracle does not provide enough information in the redo log for SharePlex to replicate a DML operation on a OLTP compressed object. Testing of OLTP compressed objects is advised.
SharePlex provides default and optional DDL support.
Notes: ALTER TABLE to ADD COLUMN and ALTER TABLE to DROP COLUMN are supported on Basic, Advanced Row (OLTP) Compression, and HCC compressed Oracle objects for replication to all Oracle and open targets. |
SharePlex does not support:
SharePlex provides limited DDL support for replication from Oracle to open targets. The involved objects must be listed in the active configuration file explicitly or with a wildcard. There is no optional DDL support for replication from Oracle to cross platforms.
The default Oracle to open target configuration is represented by the following parameter setting:
SP_OCT_REPLICATE_DDL=3
See "Table Notes" following this table for additional information.
Supported object | Supported Operation |
---|---|
Table and IOT | Truncate1 |
Alter table add column2 | |
Alter table drop column |
Table Notes:
|
SharePlex supports replication from Oracle to Azure Event Hubs, according to the details below.
SharePlex replicates remotely to the Azure Event Hubs service. Remote replication from the following operating systems is supported:
CentOS Linux 7.x
Oracle Linux 7.x and 8.x
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Note: SharePlex supports only the 64-bit version of the listed operating systems.
Supported platform as a service: Azure Event Hubs
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an Azure Event Hubs target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to an Azure Event Hubs target. For additional information, see Oracle to open target DDL support.
SharePlex supports replication from Oracle to File Output, according to the details below.
Supported operating systems via native installation:
AIX 7.1, 7.2, and 7.3
CentOS Linux 7.x
HP-UX 11.31 Itanium
Oracle Linux 7.x and 8.x
Oracle Solaris SPARC 11.4
Oracle Solaris x86 11.4
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Rocky Linux 8.x
NOTE: SharePlex supports only the 64-bit version of the listed operating systems.
This mapping applies to all targets that receive messages as XML:
Oracle | XML |
---|---|
BINARY_DOUBLE | decimal |
BINARY_FLOAT | decimal |
BLOB | base64Binary |
CHAR | string |
CLOB | string |
DATE | dateTime |
INTERVAL DAY TO SECOND | dayTimeDuration |
INTERVAL YEAR TO MONTH | yearMonthDuration |
LONG | string |
NCHAR | string |
NCLOB | string |
NUMBER | decimal |
NVARCHAR2 | string |
RAW | base64Binary |
ROWID | string |
TIMESTAMP | dateTime |
TIMESTAMP WITH LOCAL TIME ZONE | dateTimeStamp |
TIMESTAMP WITH TIME ZONE | dateTimeStamp |
VARCHAR2 | string |
VARRAY | Post maps the data types in the source VARRAY to the appropriate XML data types. Only certain data types in a VARRAY are supported. See the conditions of support. |
Only the following data types in a VARRAY are supported by SharePlex when replicating to XML output:
See Conditions of support for the additional conditions of support for the above-mentioned supported data types.
This mapping applies to all targets that receive messages as JSON:
Oracle | JSON |
---|---|
BINARY_DOUBLE | Number |
BINARY_FLOAT | Number |
BLOB | String containing base64 encoded data |
CHAR | String |
CLOB | String |
DATE | String containing date |
INTERVAL DAY TO SECOND | String containing interval |
INTERVAL YEAR TO MONTH | String containing interval |
LONG | String |
NCHAR | String |
NCLOB | String |
NUMBER | Number |
NVARCHAR2 | String |
RAW | String containing hex encoded data |
ROWID | String |
TIMESTAMP | String containing timestamp |
TIMESTAMP WITH LOCAL TIME ZONE | String containing timestamp |
TIMESTAMP WITH TIME ZONE | String containing timestamp |
VARCHAR2 | String |
Conditions of support: See Conditions of support for the conditions of support for the above-mentioned supported data types.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a File Output target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a File Output target. For additional information, see Oracle to open target DDL support.
SharePlex for Hana is in limited support effective February 1, 2022. SharePlex supports replication from Oracle to HANA, according to the details below.
SAP HANA 1.0 SPS 11
SharePlex supports the following data types for replication from Oracle to Hana:
Oracle | HANA |
---|---|
BINARY_DOUBLE | DOUBLE |
BINARY_FLOAT | DOUBLE |
BLOB | BLOB |
CHAR (n) | CHAR (n) |
CLOB | CLOB |
DATE | TIMESTAMP |
LONG | CLOB |
LONGRAW | BLOB |
NCHAR (n) | NCHAR (n) |
NCLOB | NCLOB |
NUMBER | DECIMAL |
NUMBER (p,0:) | DECIMAL (p,s) |
NUMBER (p,s) | DECIMAL |
NVARCHAR2 (n) | NVARCHAR (n) |
RAW (n) | VARBINARY (n) |
TIMESTAMP (p) | TIMESTAMP |
VARCHAR2 (n) | VARCHAR (n) |
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a Hana target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a Hana target. For additional information, see Oracle to open target DDL support.
SharePlex supports replication from Oracle to JMS Message Queues, according to the details below.
Native SharePlex installation is supported on the below operating systems:
AIX 7.1 and 7.2
CentOS Linux 7.x
HP-UX 11.31 Itanium
Oracle Linux 7.x and 8.x
Oracle Solaris SPARC 11.4
Oracle Solaris x86 11.4
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Rocky Linux 8.x
Note: SharePlex supports only the 64-bit version of the listed operating systems.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a JMS Message Queues target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a JMS Message Queue target. For additional information, see Oracle to open target DDL support.
SharePlex supports replication from Oracle to Kafka, according to the details below.
Supported operating systems via native installation:
CentOS Linux 7.x
Oracle Linux 7.x and 8.x
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Rocky Linux 8.x
Remote replication from the following operating systems is supported:
CentOS Linux 7.x
Oracle Linux 7.x and 8.x
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Rocky Linux 8.x
Note: SharePlex supports only the 64-bit version of the listed operating systems.
Apache Kafka 0.8.x, 0.9.x, 0.10.x, 0.11.x, 1.0.x, 1.1.x, 2.0.x, 2.1.0, 2.3.1, 2.5.0, 3.0, 3.3, and 3.6.1
We test and reproduce issues against:
Apache Kafka
Confluent Kafka
NOTE: If you would like to use a different vendor who provides their own Kafka distribution or provides a Kafka compliant interface, you are welcome to do so. From a support perspective, our support and development teams will share any Kafka broker errors that SharePlex receives and also ensure SharePlex itself is working properly to capture data, the target configuration formats in SharePlex are correct, and the SharePlex poster is posting or attempting to post according to the Kafka versions under support. If there are SharePlex issues with Kafka support that can be reproduced on Apache Kafka or otherwise demonstrated to be definitely associated with SharePlex, our team will address those as standard Kafka issues.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a Kafka target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a Kafka target. For additional information, see Oracle to open target DDL support.
SharePlex supports replication from Oracle to MySQL, according to the details below.
Supported operating systems via native installation:
RHEL 7.x and 8.x
Rocky Linux 8.x
Oracle Linux 7.x and 8.x
Remote replication from the following operating systems is supported:
RHEL 7.x and 8.x
Rocky Linux 8.x
Oracle Linux 7.x and 8.x
Supported target operating systems via remote replication:
AIX 7.1, 7.2, and 7.3
CentOS Linux 7.x
HP-UX 11.31 Itanium
Oracle Linux 7.x and 8.x
Oracle Solaris SPARC 11.4
Oracle Solaris x86 11.4
RHEL 7.x, 8.x, and 9
Rocky Linux 8.x
SuSE SLES 12.x and 15.x
Windows Server 2016 and 2019
Note: SharePlex supports only the 64-bit version of the listed operating systems.
MySQL 5.5, 5.6, 5.7, and 8.0.26
ODBC driver requirement:
ODBC 8.0.26 for Linux
ODBC 5.3.14
Amazon Web Services
Microsoft Azure
SharePlex supports the following data types for replication from Oracle to MySQL:
Oracle | MySQL |
---|---|
BINARY_DOUBLE 1 | DOUBLE |
BINARY_FLOAT | DOUBLE |
BLOB | LONGBLOB |
CHAR (n) | CHAR (n) |
CLOB | LONGTEXT |
DATE | DATETIME (0) |
LONG | LONGTEXT |
LONGRAW | LONGBLOB |
NUMBER | DOUBLE |
NUMBER (p,0:) | NUMERIC (p,s) |
NUMBER (p,s) | DOUBLE |
RAW (n) | VARBINARY (n) |
TIMESTAMP (7:9) 2 | DATETIME (6) |
TIMESTAMP (p) 2 | DATETIME (p) |
VARCHAR2 (n) | VARCHAR (n) |
See Conditions of support for the additional conditions of support for the above-mentioned supported data types.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a MySQL target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a MySQL target. For additional information, see Oracle to open target DDL support.
SharePlex supports replication from Oracle to Oracle, according to the details below.
Supported operating systems via native installation:
AIX 7.1, 7.2, and 7.3
CentOS Linux 7.x
HP-UX 11.31 Itanium
Oracle Linux 7.x and 8.x
Oracle Solaris SPARC 11.4
Oracle Solaris x86 11.4
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Rocky Linux 8.x
Remote replication from the following operating systems is supported:
AIX 7.1, 7.2, and 7.3
CentOS Linux 7.x
HP-UX 11.31 Itanium
Oracle Linux 7.x and 8.x
Oracle Solaris SPARC 11.4
Oracle Solaris x86 11.4
RHEL 7.x, 8.x, and 9.x
SuSE SLES 12.x and 15.x
Rocky Linux 8.x
Supported target operating systems via remote replication:
All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.
Note: SharePlex supports only the 64-bit version of the listed operating systems.
SharePlex supports the Standard and Enterprise Editions of Oracle 12cR1, 12cR2, 18c, 19c, and 21c.
Notes:
|
Oracle Cloud Infrastructure
Amazon Web Services
Microsoft Azure
Azure Virtual Machine (IaaS)
Oracle Exadata Cloud@Customer (ExaCC): Issues on Oracle Exadata Cloud@Customer will be tested against Oracle Exadata Cloud Service for reproduction purposes.
Oracle Database Cloud Service (DBCS): SharePlex only supports Transparent Data Encryption (TDE) feature on DBCS EE-HP, DBCS EE-EP, and ExaCS/CC.
Amazon RDS for Oracle: Please see Supported Oracle Source and Target Versions for additional clarification on version compatibility.
SharePlex supports the following Oracle data types for replication to Oracle targets. See the Conditions of support for additional information.
Note: SharePlex supports columns that are defined as INVISIBLE.
1. ANYDATA
Replication of ANYDATA is supported, except when it contains a UDT or the storage is defined as SecureFile LOB with compression. SecureFile LOB without compression is supported. Only the following data types within ANYDATA are supported by SharePlex:
2. LONG and LOB (BLOB, CLOB)
SharePlex supports SecureFiles LOBs as follows:
3. NCLOB
NCLOBs are not supported by Compare/Repair if the source and target have different character sets.
4. XMLTYPE
SharePlex supports the replication of XMLTYPE stored as CLOB and BINARY. SharePlex does not support XMLTYPE stored as OBJECT RELATIONAL or TRANSPORTABLE BINARY. Additionally, the following applies:
XMLTYPE stored as BINARY is not supported when the storage is defined as SecureFile LOB with compression. SecureFile LOB without compression is supported.
5. User-defined types
SharePlex does not support abstract data types and VARRAYs in a configuration where the SharePlex conflict resolution feature is performed.
NOTE: SharePlex replicates tables with the UDT fields in the base type ONLY. In case of columns containing multiple subtypes, replication is applicable only for base type fields.
6. General
If the precision or size of the target data type is not large enough for the data being replicated, the data may be truncated or rounded by the database when applied.
7. BINARY DOUBLE and BINARY FLOAT
The BINARY DOUBLE and the BINARY FLOAT data types are not supported for the copy command.
8. Extended Data Types
SharePlex provides default and optional DDL support.
Note: ALTER TABLE to ADD COLUMN and ALTER TABLE to DROP COLUMN are supported on Basic, Advanced Row (OLTP) Compression, and HCC compressed Oracle objects for replication to all Oracle and open targets. |
SharePlex does not support:
During DDL replication, data containing the ALTER statement related to Oracle extended statistics—'Virtual by User'— is not supported. Oracle also does not recommend to use the extended stastistics 'Virtual by User'.
SharePlex supplies default and optional DDL replication for objects whose names are listed in the configuration file explicitly or by wildcard. See "Conditions of support" following this table for additional information.
For details about the controlling parameter, see the SharePlex Reference Guide.
Supported object | Supported DDL Operation |
Enabled by default? |
Controlling parameter |
---|---|---|---|
Table and IOT (when they exist in the source at the time of configuration activation) |
Truncate Alter to add, drop, modify columns Alter to add, modify, drop, split, coalesce, move, truncate, exchange partition or subpartition1 Drop Table |
Yes |
SP_OCT_REPLICATE_DDL=3 |
Table and IOT |
Create Create as Select2 |
Yes |
SP_OCT_AUTOADD_ENABLE=1 |
Table | Alter Table Rename | Yes | SP_OCT_DDL_UPDATE_CONFIG=1 |
Index |
Create Alter Drop |
Yes |
SP_OCT_AUTOADD_ENABLE=1 |
Materialized View3 |
Create Drop |
No |
SP_OCT_AUTOADD_ENABLE=1 and SP_OCT_AUTOADD_MVIEW=1 and SP_SYS_TARGET_COMPATIBILITY=8.6.2 or higher |
Sequences4 |
Create, Drop |
No |
SP_OCT_AUTOADD_ENABLE=1 and SP_OCT_AUTOADD_SEQ=1 and SP_SYS_TARGET_COMPATIBILITY=8.6.3 or higher |
Trigger |
Create, Drop |
No |
SP_OCT_REPLICATE_TRIGGER=1 |
Synonym |
Create, Drop |
No |
SP_OCT_REPLICATE_SYNONYM=1 |
Grant5 | Create, Drop |
No |
SP_OCT_REPLICATE_GRANT=1 |
For CREATE MATERIALIZED VIEW the following applies:
To replicate sequences, the supplemental logging of primary and unique keys must be enabled at the database level, or you must enable supplemental logging for primary keys on the sys.seq$ table.
Amazon RDS restricts DBA users from issuing the GRANT command. Because SharePlex runs as the DBA user, SharePlex cannot replicate GRANT to or from an RDS database.
SharePlex provides expanded DDL support for Oracle objects that are not listed in the configuration file. SharePlex replicates the DDL statements for these objects, but does not maintain synchronization of the objects through DML replication. Expanded DDL replication is optional and is enabled with the following parameter setting:
SP_OCT_REPLICATE_ALL_DDL=1
Note: Expanded DDL replication supports not only tables and sequences but also a wide range of other objects such as procedures, functions, users, and views, which are not part of replication. Some of these objects may have underlying objects that are in replication. In those cases, Expanded DDL replication applies to the underlying objects in replication, as well as to the object that is not in replication.
See "Table Notes" following this table for additional information.
Supported object | Supported Operation |
---|---|
Table and IOT | Create table |
Create table as select | |
Alter table add column | |
Alter table drop column | |
Drop table | |
Truncate | |
Comment on table | |
Comment on columns | |
Associate Statistics | |
Disassociate Statistics | |
Cluster | Create cluster |
Crop cluster | |
Sequence | Create |
Drop | |
Alter | |
Partition/ Subpartition |
Add |
Split | |
Merge | |
Drop | |
Modify | |
Coalesce | |
Exchange | |
Move | |
Truncate | |
Rename | |
Set | |
Index | Create |
Alter | |
Drop | |
View | Create |
Alter | |
Drop | |
Comment on view | |
Synonym | Create |
Drop | |
Directory1 | Create |
Drop | |
User-defined type | Create type |
Alter type | |
Drop type | |
Create type body | |
Drop type body | |
Stored procedure | Create |
Alter | |
Drop | |
Stored function | Create |
Alter | |
Drop | |
Package | Create package |
Create package body | |
Alter package | |
Alter package body | |
Drop package | |
Drop package body | |
User | Create user |
Alter user | |
Drop user | |
Grant1 | |
Revoke | |
Role | Create role |
Alter role | |
Drop role | |
Grant1 | |
Revoke |
Table Notes:
Amazon RDS restricts DBA users from issuing certain commands on an Amazon RDS database instance. Because SharePlex runs as the DBA user, SharePlex cannot replicate the following commands to or from an RDS database:
|
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an Oracle target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports replication from Oracle to PostgreSQL, according to the details below.
Supported operating systems via native installation:
RHEL 7.x, 8.x, and 9.x
Rocky Linux 8.x
Oracle Linux 7.x and 8.x
Remote replication from the following operating systems is supported:
RHEL 7.x, 8.x, and 9.x
Rocky Linux 8.x
Oracle Linux 7.x and 8.x
Supported target operating systems via remote replication:
All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.
Note: SharePlex supports only the 64-bit version of the listed operating systems.
PostgreSQL 9.4, 9.5, 9.6, 10, 13.4, 13.6, 14.1, 15.x, 16
Enterprise Database (EDB) 15.x, 16
Fujitsu Enterprise PostgreSQL 15 SP2
AlloyDB Omni 15.5.x*
*Note: To use the AlloyDB Omni 15.5.x database for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.
ODBC drivers for Community Edition: postgresql13-odbc-13.02.0000, postgresql14-odbc-13.02.0000,postgresql15-odbc-16.00.0000, and postgresql16-odbc-16.00.0000
ODBC drivers for Enterprise Edition (EDB): edb-odbc-13.02.0000, edb-odbc-16.00.0000.01
Oracle Cloud Infrastructure
Oracle Compute (IaaS) Virtual Machines and Bare Metal
Amazon Web Services
Microsoft Azure
Google Cloud Platform
Cloud SQL for PostgreSQL
AlloyDB for PostgreSQL*
*Note: To use the Google AlloyDB for PostgreSQL Cloud platform for data replication using SharePlex, contact the Quest Support team at www.quest.com/contact.
SharePlex supports the following data types for replication from Oracle to PostgreSQL:
Oracle | PostgreSQL |
---|---|
BINARY_DOUBLE | DOUBLE PRECISION |
BINARY_FLOAT | REAL |
CHAR (n) | CHAR (n) |
CHAR (n CHAR) | CHAR (n) |
CLOB | TEXT |
DATE | DATE |
DATE | TIMESTAMP (0) |
LONG | TEXT |
NCHAR (n) | CHAR (n) |
NCLOB | TEXT |
NUMBER | NUMERIC |
NUMBER (p,0:) | NUMERIC (p,s) |
NUMBER (p,s) | NUMERIC |
NVARCHAR2 (n) | VARCHAR (n) |
TIMESTAMP (7:9) | TIMESTAMP (6) |
TIMESTAMP (p) | TIMESTAMP (p) |
TIMESTAMP (7:9) WITH TIME ZONE | TIMESTAMP (6) WITH TIME ZONE |
TIMESTAMP (p) WITH TIME ZONE | TIMESTAMP (p) WITH TIME ZONE |
TIMESTAMP (7:9) WITH LOCAL TIME ZONE | TIMESTAMP (6) |
TIMESTAMP (p) WITH LOCAL TIME ZONE | TIMESTAMP (p) |
VARCHAR2 (n) | VARCHAR (n) |
VARCHAR2 (n CHAR) | VARCHAR (n) |
BLOB | BYTEA |
Conditions of support: See Conditions of support for the conditions of support for the above-mentioned supported data types.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to a PostgreSQL target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to a PostgreSQL target. For additional information, see Oracle to open target DDL support.
SharePlex supports replication from Oracle to Snowflake, according to the details below.
SharePlex replicates remotely to Snowflake. Remote replication from the following operating systems is supported:
RHEL 7.x, 8.x, and 9.x
Oracle Linux 7.x and 8.x
Note: SharePlex Snowflake supports only the 64-bit version of the listed operating systems.
Snowflake 6.31 Enterprise, Community version, and Snowflake 8.1
ODBC driver requirement:Snowflake 3.1.4 and above
Microsoft Azure
SharePlex supports the following data types for replication from Oracle to Snowflake:
Oracle | Snowflake |
---|---|
CLOB | TEXT |
NUMBER | INT, INTEGER, NUMBER |
CHAR(n) | VARCHAR(n) |
CLOB | VARCHAR(n) |
NCHAR | CHAR(n) |
VARCHAR2(n) | VARCHAR(n) |
CLOB | VARCHAR(n) |
NCLOB | TEXT |
CLOB | VARCHAR(n) |
LONG | TEXT |
BLOB | BINARY, VARBINARY |
RAW(n) | VARBINARY |
LONGRAW | VARBINARY |
BINARY_FLOAT | REAL |
NUMBER | SMALLINT |
NUMBER | BIGINT |
NUMBER | NUMERIC, DECIMAL |
DATE | DATE |
BINARY_DOUBLE | DOUBLE PRECISION |
TIMESTAMP | TIMESTAMP |
TIMESTAMP_TZ | TIMESTAMP_TZ |
Note: It is anticipated that the Snowflake DB's default "HEX" format for binary type will be maintained for Oracle binary to Snowflake binary data type replication. Since source Oracle DB binary data is stored only in "HEX" format, Shareplex does not guarantee data integrity for any other format.
Char(n) data type - In Oracle, Char(n) is a fixed-size data type. If you insert char data with a length less than "n" into the "Char(n)" column, the remaining slots (n - length) are padded with space to occupy the complete "n" memory positions. Snowflake uses VARCHAR(n) for char storage since Snowflake lacks a comparable fixed-length character data type and only saves char data up to its length. Live replication will ensure that char column data is correctly copied. However, if users are manually inserting data into Snowflake for the equivalent of a Char(n) Oracle column, then the user will need to handle padding as well to occupy the full "n" length so that data will be in sync in both the source and target DB.
Binary & Text data types - Snowflake Binary & Text data types have size limitation of 8 MB, so Oracle’s advance Data type replication will be restricted to max 8 MB size limit of equivalent counterpart. Refer table below.
Oracle Data type | Max Size | Snowflake Data type | Max Size |
---|---|---|---|
LONG | 2 GB | TEXT | 8 MB of unicode chars |
CLOB | 4 GB | TEXT | 8 MB of unicode chars |
LONGRAW | 2 GB | BINARY or VARBINARY | 8 MB |
BLOB | 4 GB | BINARY or VARBINARY | 8 MB |
See Conditions of support for the additional conditions of support for the above-mentioned supported data types.
SharePlex supports DML operations on tables, with some conditions. DML can be replicated from an Oracle source to a Snowflake target.
SharePlex supports the following DML operations on tables when replicating data from an Oracle source to the Snowflake target:
Singular and bulk operation - Insert with key(s)/ non key(s)
Singular and bulk operation - Update with key(s)/ non key(s)
Singular and bulk operation - Delete with key(s)/ non key(s)
Limitations:
The following DML operations related limitations are observed while replicating data from Oracle to Snowflake:
|
For additional information, see Supported Operations and Objects for DML Replication.
SharePlex does not support DDL operations and objects when replicating data from an Oracle source to a Snowflake target.
SharePlex supports replication from Oracle to SQL Server, according to the details below.
The following operating systems are supported for SQL Server database. SharePlex supports only the 64-bit version of the listed operating systems.
Supported operating systems via native installation:
RHEL 7.x, 8.x, and 9.x
Rocky Linux 8.x
Oracle Linux 7.x and 8.x
Remote replication from the following operating systems is supported:
RHEL 7.x, 8.x, and 9.x
Rocky Linux 8.x
Oracle Linux 7.x and 8.x
Supported target operating systems via remote replication:
All platforms listed above, plus Windows Server 2016 and 2019, are supported via remote replication.
SQL Server 2012, 2014, 2016, 2017, 2019, and 2022
Note: SQL Server 2012, 2014, and 2016 databases hosted on Windows servers are compatible with Windows Server 2016 and above.
ODBC driver requirement: ODBC 17.10.1.1-1 and 18.3.2.1-1
Amazon Web Services
Amazon EC2 (IaaS) Virtual Machine
Microsoft Azure
SharePlex supports the following data types for replication from Oracle to SQL Server:
Oracle | SQL Server |
---|---|
ANYDATA | VARIENT |
BINARY_DOUBLE | FLOAT (53) |
BINARY_FLOAT | FLOAT (24) |
BLOB | VARBINARY (MAX) |
CHAR (n) | CHAR (n) |
CHAR (n CHAR) | CHAR (n) |
CLOB | VARCHAR (MAX) |
DATE | DATETIME2 (7) |
LONG | VARCHAR (MAX) |
LONGRAW | VARBINARY (MAX) |
NCHAR (n) | NCHAR (n) |
NCLOB | NVARCHAR (MAX) |
NUMBER | FLOAT (53) |
NUMBER (p,0:) | NUMERIC (p,s) |
NUMBER (p,0:)* | DECIMAL |
NUMBER (p,s) | FLOAT (53) |
NVARCHAR2 (n) | NVARCHAR (n) |
RAW (n) | VARBINARY (n) |
TIMESTAMP (8:9) | DATETIME2 (7) |
TIMESTAMP (p) | DATETIME2 (p) |
TIMESTAMP (8:9) WITH TIME ZONE | DATETIMEOFFSET (7) |
TIMESTAMP (p) WITH TIME ZONE | DATETIMEOFFSET (p) |
VARCHAR2 (n) | VARCHAR (n) |
VARCHAR2 (n CHAR) | VARCHAR (n) |
Conditions of support:
NUMBER (P, 0) - DECIMAL: If we add a new column with the Number data type in the Oracle source, the new column will be replicated with the Numeric data type to the SQL Server target.
See Conditions of support for the additional conditions of support for the above-mentioned supported data types.
SharePlex supports DML operations on tables and sequences, with some conditions. DML can be replicated from an Oracle source to an SQL Server target. For additional information, see Supported Operations and Objects for DML Replication.
SharePlex supports DDL operations on tables and sequences, with some conditions. DDL can be replicated from an Oracle source to an SQL Server target. For additional information, see Oracle to open target DDL support.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center