Chat now with support
Chat with Support

SharePlex 9.0 - Installation Guide

About this Guide Conventions used in this guide System Requirements SharePlex pre-installation checklist Installation and setup for Oracle cluster Installation and setup for cloud-hosted databases Download SharePlex Install SharePlex on Linux and UNIX Install SharePlex on Windows Assign SharePlex users to security groups Set up an Oracle environment for replication Set up replication between SQL Server databases Set up replication between different database types Basic SharePlex demonstrations Advanced SharePlex demonstrations Solve Installation Problems Uninstall SharePlex SharePlex Utilities Advanced installer options Install SharePlex as root Run the installer in unattended mode SharePlex installed items

Post to PaaS cloud from the source system

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

Overview of SharePlex setup on cloud databases

Source Oracle to cloud Oracle

All steps are performed on the source server.

  1. Complete the SharePlex preinstallation checklist.

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

  3. Run ora_setup to establish connection information for the source Oracle database. See Database Setup for Oracle. Important:

    1. When asked if the current SID will be used as a source, enter Y.

    2. When asked whether this is a bequeath connection, enter Y, unless this system is RAC.

  4. Add an entry in the local tnsnames.ora file that points to the target cloud database. This enables you to query the target database from the source server.

  5. Run ora_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. Important:

    1. When asked whether this is a bequeath connection, enter N. This directs SharePlex to use TNS to connect to the target cloud database.
    2. When prompted to specify the tns_alias, specify the one that you created for the target cloud database.

    3. When asked if the current SID will be used as a source, enter N.

  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 ORACLE_SID of the target cloud database.

    In the following example, source1 is the source system and orcldb1 is the tns_alias of the target cloud database.

    datasource:o.orcldbprim

    #source tables

    target tables

    routing map

    splex.demo_src

    splex.demo_dest

    source1@r.orcldb1

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

Source Oracle or SQL Server to cloud Open Target

All steps are performed on the source server.

  1. Complete the SharePlex preinstallation checklist.

  2. Install SharePlex. See:

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

    Important:

    1. (Oracle setup only) When asked whether this is a bequeath connection, enter Y to use bequeath, unless this system is RAC.

    2. Reply Y when asked if the database or SID will be used as a source.

  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.

    Important:

    • If the target is Aurora, use the mysql_setup utility.

    • If the target is SQL Server cloud, when asked if the database will be used as a source, enter N.

    • (All cloud targets) Specify the full target database name when prompted for the connection string.

  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.

    In the following example using a MySQL target, source3 is the source system and sptest3 is the target database.

    datasource:o.orcldbprim

    #source tables

    target tables

    routing map

    HR.EMP

    "sptest3"."emp"

    source3@r.sptest3

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 intermediate system

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

Overview of SharePlex setup on cloud databases

Source Oracle to cloud Oracle

  1. Complete the SharePlex preinstallation checklist.

  2. On the source server, install SharePlex for the source database. See:

  3. On the source server, run ora_setup to establish connection information for the source database. See Database Setup for Oracle. Important:

    1. When asked whether this is a bequeath connection, enter Y, unless this system is RAC.

    2. When asked if the current SID will be used as a source, enter Y.

  4. On the intermediary server, install the Oracle binaries. Do not create an Oracle instance.

  5. On the intermediary server, add an entry in the oratab file that points to the local Oracle home, and create a dummy entry for the ORACLE_SID. Make certain to specify N so that the startup scripts do not attempt to start the dummy instance.

    orcldb:/u01/app/oracle/product/12.1.0/dbhome_1:N

  6. On the intermediary server, add an entry in the tnsnames.ora file that points to the target cloud database.

  7. On the intermediary server, install SharePlex for the target cloud database. When prompted for the ORACLE_SID, specify the tns_alias that you created for the target cloud database. See:

  8. On the intermediary server, run ora_setup to establish connection information for the target cloud database. Run it as the master user that was created when the cloud service was created. This user has the required DBA privileges to establish connection information for the target database. Important:

    1. When asked whether this is a bequeath connection, enter N. This directs SharePlex to use TNS to connect to the target cloud database.
    2. When prompted to specify the tns_alias, specify the one that you created for the target cloud database.

    3. When asked if the current SID will be used as a source, enter N.

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

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

    • the ORACLE_SID of the target cloud database.

    In the following example, intermediary1 is the intermediary server and orcldb1 is the tns_alias of the target cloud database.

    datasource:o.orcldbprim

    #source tables

    target tables

    routing map

    splex.demo_src

    splex.demo_dest

    intermediary1@o.orcldb1

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

Source Oracle or SQL Server to cloud Open Target

  1. Complete the SharePlex preinstallation checklist.

  2. On the source server, install SharePlex for the source database. See:

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

    Important:

    1. (Oracle setup only) When asked whether this is a bequeath connection, enter Y to use bequeath, unless this system is RAC.

    2. Reply Y when asked if the database or SID will be used as a source.

  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:

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

    Important:

    • If the target is Aurora, use the mysql_setup utility.

    • If the target is SQL Server, reply N when asked if this database will be used as a source.
    • (All targets) Specify the full target database name when prompted for the connection string.

  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:o.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.

Download SharePlex

Contents

Where to get SharePlex installers

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

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

  1. Go to the Quest Software Support page: http://support.quest.com/

  2. Click Download Software.

  3. In the search box, type SharePlex and press Go.

  4. Click the arrow in the Download column for the version you need. You can also click the file name for access to more information and to download the file(s).

  5. Transfer the file to system where you are installing SharePlex.

  6. You are ready to begin the installation process. Be sure to thoroughly read the version specific Release Notes prior to running the installer.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating