Chat now with support
Chat with Support

SharePlex 11.2 - Installation and Setup Guide

About this Guide Conventions used in this guide Revision History Installing and Setting up SharePlex on an Oracle Source
SharePlex Pre-installation Checklist for Oracle Download the SharePlex installer Install SharePlex on Linux and UNIX Set up an Oracle environment for replication Set up replication from Oracle to a different target type Installation and Setup for Cloud-Hosted Databases for Oracle Installation and setup for remote capture Installation and setup for HA cluster Generic SharePlex demonstration for Oracle Advanced SharePlex demonstrations for Oracle Database Setup Utilities Solve Installation Problems for Oracle
Installing and Setting up SharePlex on a PostgreSQL Database as Source and Service
SharePlex Pre-installation Checklist for PostgreSQL Download the SharePlex installer for PostgreSQL Install SharePlex on Linux for PostgreSQL as a Source Set up Replication from PostgreSQL to Supported Target Types Installation and Setup for Cloud-Hosted Databases for PostgreSQL Installation and Setup for Remote Capture for PostgreSQL Install SharePlex on PostgreSQL High Availability Cluster Generic SharePlex Demonstration for PostgreSQL Advanced SharePlex Demonstrations for PostgreSQL Database Setup for PostgreSQL Database Setup for PGDB as a Service Solve Installation Problems for PostgreSQL
Assign SharePlex users to security groups Solve Installation Problems Uninstall SharePlex Advanced installer options Install SharePlex as root SharePlex installed items

Overview of SharePlex Setup on Cloud for PostgreSQL

SharePlex supports databases installed as services of Amazon Web Services (AWS), Google Cloud SQL for PostgreSQL, and Microsoft Azure. To view the cloud databases that SharePlex supports, refer to the Supported Cloud Platforms section in the SharePlex Release Notes document for the respective databases.

There are some differences in the way that SharePlex installs in an IaaS cloud environment, a PaaS cloud environment, and a SaaS cloud environment. These differences are only in the installation and configuration of SharePlex. Once installed and configured, SharePlex operates in the cloud the same way that it operates in on-premise installations. For detailed information regarding how SharePlex is installed in various environments, see Overview of SharePlex Setup on Cloud.

Post to PaaS Cloud from the Source Server for PostgreSQL

These instructions help you set up SharePlex to replicate to a target cloud database directly from the source server. All of the SharePlex processes will run on this server. In a high-volume transactional environment, this may generate unacceptable overhead on the production system. In that case, you should use an intermediary server.

See also:

Post to PaaS cloud from an intermediary server for PostgreSQL

Overview of SharePlex setup on cloud databases

Source PostgreSQL to cloud PostgreSQL

All steps are performed on the source server:

  1. Complete the SharePlex pre-installation checklist.

  2. Install SharePlex. See Install SharePlex on Linux/Unix for PostgreSQL Database.

  3. Run pg_setup to establish connection information for the source PostgreSQL database. See Database Setup for PostgreSQL.

  4. Add an entry in the local ODBC.ini or ODBCINST.ini files that points to the target cloud database. This enables you to query the target database from the source server.

  5. Run pg_setup to establish connection information for the target cloud database. Run the utility as the master user that was created when the service was created. This user has the required DBA privileges.

  6. Specify the following in the routing map of the SharePlex configuration file:

    • The name of the source host to specify the target system.

    • The PostgreSQL database name of the target cloud database.

    In the following example, source1 is the source system and postgresqldatabasename is the alias from ODBC files of the target cloud database.

    datasource: r.orcldbprim
    #source tables target tables routing map
    splex.demo_src splex.demo_dest source1@r.postgresqldatabasename

For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.

Source PostgreSQL to cloud Open Target

All the below steps are performed on the source server:

  1. Complete the SharePlex preinstallation checklist.

  2. Install SharePlex. See: SharePlex on Linux/Unix for PostgreSQL Database.

  3. Run the appropriate database setup utility for the source database. See:

  4. Install the appropriate ODBC client of the target cloud database.

  5. Run the appropriate database setup utility for the target cloud database. See Database Setup Utilities.

  6. Specify the following in the routing map of the SharePlex configuration file:

    1. the name of the source server as the target host.

    2. the name of the cloud database as the target database

For more information about how to specify configuration components, see Configure SharePlex to replicate data in the SharePlex Administration Guide.

Post to PaaS Cloud from an Intermediary Server for PostgreSQL

These instructions help you set up SharePlex to replicate to a target cloud database from an intermediary server that runs the SharePlex Import and Post components.

See also:

Post to PaaS cloud from the source server for PostgreSQL

Overview of SharePlex setup on cloud databases.

Source PostgreSQL to cloud Open Target

  1. Complete the SharePlex preinstallation checklist.

  2. On the source server, install SharePlex for the source database. See: Install SharePlex on Linux/Unix for PostgreSQL Database.

  3. On the source server, run the appropriate database setup utility for the source database. See: Database Setup for PostgreSQL.

  4. On the intermediary server, install the appropriate ODBC client of the target cloud database.

  5. On the intermediary server, install SharePlex for the target cloud database. See: Install SharePlex on Linux/Unix for PostgreSQL Database.

  6. On the intermediary server, run the appropriate database setup utility for the target cloud database. See Database Setup Utilities.

  7. Specify the following in the routing map of the SharePlex configuration file:

    1. the name of the intermediary server as the target host.

    2. the name of the cloud database as the target database.

In the following example using a MySQL target, intermediary3 is the intermediary system and sptest3 is the target cloud database.

datasource:r.orcldbprim
#source tables target tables routing map
HR.EMP "sptest3"."emp" intermediary3@r.sptest3

For more information, see Configure SharePlex to replicate data in the SharePlex Administration Guide.

Installation and Setup for Remote Capture for PostgreSQL

Using PostgreSQL as a source with remote capture requires that the database instances be accessible from the servers on which SharePlex is installed.

To set up SharePlex for remote capture:

  1. Run PG Setup on the SharePlex system according to the instructions provided in the Database Setup Utilities for PostgreSQL section of the SharePlex Reference Guide.

    • When prompted with "Is DB hosted over Azure Single Server?", reply with "No" as Azure Single Server is not supported as a source.

  2. Complete all the setup tasks as mentioned in the Database Setup for PostgreSQL Database as a Service.

  3. After completing the setup, start sp_cop and sp_ctrl.

  4. For configuring and starting replication, refer to the SharePlex Administration Guide.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating