SharePlex 11.2 - Installation and Setup Guide

Download the SharePlex installer for PostgreSQL

SharePlex Installer

There are different installers for SharePlex based on the type of operating system. This topic helps you understand the differences and the naming conventions used.

Linux

The SharePlex installer on Linux is a self-extracting installation file with the extension .tpm.

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

The installer creates a temporary target directory, within the current directory, for extraction. This temporary target directory is removed upon installation completion. You can extract the files to a file system that is separate from the SharePlex installation location by using the -t option when running the .tpm file.

Where to get SharePlex installers

Download the SharePlex installation package that matches the operating system you are using.

Additionally, download any SharePlex patches, so that you can install them after you install the base software.

For more information on how to download the SharePlex patches, see Download the SharePlex patches.

Install SharePlex on Linux for PostgreSQL as a Source

You can run the SharePlex installer for PostgreSQL on Linux in an Interactive or Unattended mode. For more information on the steps to run the installer, see Install SharePlex on Linux/Unix for open target databases.

Set up Replication from PostgreSQL to Supported Target Types

Contents

About these instructions

This chapter contains instructions for configuring SharePlex to replicate from PostgreSQL to a different type of target. This is known as heterogeneous replication.

These instructions highlight specific tasks that are pertinent to the flow of data between source and target. Refer to other topics in the SharePlex documentation as needed to complete the configuration, deploy any optional features that apply, and monitor and maintain the environment.

For additional information, see:

• For the SharePlex-supported datastores, data types and operations that are supported by SharePlex, see the "System Requirements " section of SharePlex Release Notes.
• For additional configuration options, activation steps, and monitoring information, see SharePlex Administration Guide.
• For reference documentation on SharePlex commands, parameters and utilities, see SharePlex Reference Guide.

Set up replication from PostgreSQL to PostgreSQL

Note: These instructions apply to all implementations of PostgreSQL unless otherwise noted.

Overview

SharePlex can post replicated PostgreSQL data to a PostgreSQL target database through an Open Database Connectivity (ODBC) interface. SharePlex supports all implementations of the PostgreSQL open-source database.

These instructions contain setup instructions that are specific to this target. Install SharePlex on the source and target according to the appropriate directions in this manual before performing these setup steps.

For the versions, data types and operations that are supported when using SharePlex to replicate to this target, see the SharePlex Release Notes.

Configure SharePlex on the source and target

Set up SharePlex and the database on the PostgreSQL source and target system as follows.

Configure replication

On the source, create a SharePlex configuration file that specifies capture and routing information.

where:

• source_DB is the database name of the source database.
• src_schema.table is the schema and name of the source table.
• tgt_schema.table is the schema and name of the target table.*
• host is the name of the target system.
• database_name is the name of the target database.

Source configuration example

The following configuration file replicates table HR.Emp from PostgreSQL instance dbname112 to target table region1.emp in database mydb on target system hostB. The source table is case-sensitive.