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