This manual provides instructions for installing SharePlex and performing initial setup. It also contains some demonstration tutorials that show how certain features of SharePlex work.
For the complete SharePlex documentation set, go to:
See the SharePlex Administration Guide for instructions for:
See the SharePlex Reference Guide for reference information that you will need from time to time. It includes detailed information about:
You can download, view and save this document in Adobe PDF format. Click Download this document in the upper right-hand corner of this page. This action downloads the entire publication.
The following typographic conventions are used in this guide.
[Brackets] represent optional command components and may also be used in example command strings to emphasize required user defined variables in long strings.
Example:
reconcile queue {queuename} for {datasource-datadest} [on host]
A vertical bar, or “pipe” character, ( | ) within brackets or braces indicates that you can use only one of the enclosed components.
Example:
abort service {service | all}
Names of commands, programs, directories and files are expressed in Bold.
Other names are expressed in capital letters using the default font.
Examples:
The sp_ctrl program is located in the bin directory.
Open the oramsglst file.
Find the value for ORACLE_HOME.
Click Apply.
System displays, such as prompts and command output, are expressed in a monofaced (fixed-space) font.
Examples:
sp_ctrl(sysA)>
User is a viewer (level=3)
Windows menu items, dialog boxes, and options within dialog boxes are expressed in Bold.
Example:
From the File menu, select Print.
System names are expressed generically or fictitiously. When necessary, the source system (or primary system) is referred to as SysA. Target systems (or secondary systems) are referred to as SysB, SysC, SysD, and so forth.
This chapter contains the following:
Before installing SharePlex, ensure that your system meets the minimum hardware and software requirements.
SharePlex supports both IPv4 and IPv6 internet protocol. The following table shows the platforms for which SharePlex was tested with IPv6.
Platform |
Source |
Target |
SharePlex Source |
On-premise/Cloud |
---|---|---|---|---|
Linux RHEL |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
Linux RHEL |
Link-Local IPV6 |
Link-Local IPV6 |
8.6.5 - 9.0 |
On-premise |
Linux RHEL |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 8.6 |
On-premise |
Linux Suse |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
Windows |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
Windows |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 8.6.4 |
On-premise |
HP UA |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
HP IA |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
SUN Sprac |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
SUN Solaris |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
AIX |
Link-Local IPV6 |
Link-Local IPV6 |
9.0 - 9.0 |
On-premise |
Linux RHEL |
Public IPV6 |
Public IPV6 |
9.0 - 9.0 |
Cloud |
Windows |
Public IPV6 |
Public IPV6 |
9.0 - 9.0 |
Cloud |
Refer to the following guidelines if the system where you are installing the current version of SharePlex is in a configuration where one or more other systems will continue to use an older version. An example would be where you are installing or upgrading SharePlex on a target, but the source will continue to use SharePlex 8.5 or earlier.
Versions with full interoperability
The following SharePlex versions are fully interoperable, including the Compare/Repair feature:
8.0.x
8.5.x
8.6.x
9.0.x
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
Stop Capture.
sp_ctrl>stop capture
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
Data Store | Type of Support | Version | Driver version |
---|---|---|---|
Apache Kafka | target | .08 and later |
N/A Note: A Kafka target is supported on Red Hat Linux version 6.0 or later. |
Flat file - SQL output | target | N/A | N/A |
Flat file - XML output | target | N/A | N/A |
JMS - ActiveMQ | target | 5.8 | N/A |
JMS - IBM MQ | target | 7.x and 8.x | N/A |
Microsoft SQL Server |
source and target |
2012 2014 2016 Note: Supported as a source only on Windows 2012 R2. |
Microsoft SQL Server ODBC Driver Do not use the Microsoft SQL Server Native Client. SharePlex will return an error during setup if the correct driver is not used. To tell the difference between the two:
|
MySQL | target | 5.6 and later | ODBC driver version 5.3.2 or later. |
Oracle Database (64-bit only) |
source and target |
10g R1 and R2 11g R1 and R2 12cR1 and R2 |
N/A |
PostgreSQL*
(Symfoware Server, EDB Postgres Advanced Server, others) |
target | 9.4 and later* |
Use the driver version that is recommended by the vendor of the PostgreSQL implementation that you are using. |
SAP Adaptive Server Enterprise (ASE) | target | 15.7 | N/A |
SAP HANA | target | 1.0 SPS 11 Rev111 | HDBODBC or HDBODBC32 driver provided with the HANA database installation. |
Teradata | target | 15.00.03.05 | Teradata ODBC driver version 15.10.00.01 or later |
* SharePlex supports all implementations of the PostgreSQL open source object-relational database system.
The following shows the configurations that SharePlex supports when either the source or target, or both, are cloud-based databases.
Source | To Target |
---|---|
Oracle on EC2 Linux |
Oracle on AWS EC2 Linux |
Oracle on Azure Linux |
Oracle on Azure Linux |
Oracle on on-premise Linux |
|
SQL Server on on-premise Windows |
|
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy