Oracle as Target

General parameters 

• database – The only appropriate value is target
• dbtype – The appropriate value is oracle
• generatesql – This parameter is to identify if database objects are to be created immediately (0 - value, default), or the SQL script creating these objects should be generated (1 value).

Database Connectivity

• connectiontype – Specifies the Oracle connection method, the possible values are:
  • tns – Local Naming Method to be used
  • ezconnect – EZCONNECT to be used
• tnsname – Name of the TNS alias, valid only if connectiontype=tns
• server – Host name or IP address of the database server, valid only if connectiontype=ezconnect
• port – Database port number, valid only if connectiontype=ezconnect
• servicename – Database service name or SID, valid only if connectiontype=ezconnect
• user – Database User name
• password – Database User password

Web UI

To prepare Oracle as a Target database, on the “Database Settings” form select Connection Type, provide the database connectivity parameters and click “Test connection” and then “Prepare for Replication” button:

Clicking on the “Show Prepare SQL” will generate script creating necessary replication objects.