Oracle as Source

General parameters 

  • database – The only appropriate value is source
  • dbtype – The appropriate value is oracle
  • generatesql – This parameter to identify if database objects are to be created (0 - value, default), or the only SQL script creating the objects to 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
  • dbname – Name of either container or pluggable database, valid only if database=source and for any Oracle versions 12c-19c but excluding RDS instances
  • user – Database User name
  • password – Database User password
  • supplementallog - Type of the supplemental logging to be enabled. The possible values are
    • "ALL”  (default)
    • “PRIMARY KEY”
    • “FOREIGN KEY”
  • directlogmode – The parameter specifies what type of “directlogmode” will be used by the Capture Processes (see details on directlogmode” parameter of the Oracle Capture Parameters). The value should be the same as for capture processes

Note - If database is to be used by multi capture processes utilising different “directlogmode” values, the "prepare"  command must be invoked for each type of the “directlogmode”  parameter

 

Web UI 

To prepare Oracle database using Web UI on the “Database Settings” form select Connection Type and provide database connectivity parameters:

 

 

“Capture method” is equivalent of the repcli's “directlogmode” parameter, and is to specify how the CDC data should be extracted (see Overview of Data Capturing Methods for Oracle Database for the details). 

If “Capture method” is "Mine from Redo (Local Directory)" , the “Local Dir” parameter should be also provided:

 

 

If “Capture method” is "Mine from ASM Device", the ASM Device connectivity parameters should be provided: