Chat now with support
Chat with Support

SharePlex 9.0.1 - Preinstallation Checklist

Database specifications in a configuration file

A database specification is required in the following components of the configuration file:

  • the datasource (source data store) specification
  • routing map (target data store and location) specification
Database Database type notation* Database Identifiers
Oracle source or target


Depending on the Oracle database configuration, use one of the following. This is the string that SharePlex will use to connect to the database.

  • The Oracle SID of a regular (non-CDB) Oracle database, as in o.ora12.
  • The tns_alias of a pluggable database (PDB) in an Oracle container database (CDB), as in o.pdb1.
  • The global tns_alias of an Oracle RAC cluster, as in o.rac1. SharePlex connects to an Oracle RAC instance through this tns_alias, which is mapped locally on each node to the Oracle SID of the local Oracle instance. For more information about creating this alias, see Installation and setup for Oracle cluster in the SharePlex Installation Guide.

SQL Server source or target

Other Open Target targets


Use to specify the name of a SQL Server source database or an Open Target (non-Oracle) target database, as in r.mydb. Important! Use the actual database name. Do not use the ODBC datasource name (DNS) or database instance name. If the database name is case-sensitive, specify it that way.

Oracle change-history target c.

Use in a routing map to specify the Oracle SID, tns_alias, or global RAC tns_alias of an Oracle change history database, as in c.ORA12CH. In this configuration, SharePlex applies all source transactions as INSERTs to the target tables, to maintain a history of every operation performed.

For more information, see Configure replication to maintain a change history target.

* Note: The dot is required.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating