Online Documentation for DB Extract for Oracle

Step 1 - Setting connection properties


At this step you should enter the necessary settings to establish connection to Oracle server.

 

Connection settings

Authentication Type

Specify whether to use Server or Windows authentication type.

 

Authorization

Specify Login and Password needed to connect to the database.

Database Home

Specify your Oracle Home storage for this connection.

 

Connect as

Select the type of connection to be established: Normal (by default), SYSDBA, SYSOPER.

 

After that it is necessary to specify the database you are going to work with: type in the database name in the Database field or select one in the drop-down list (the drop-down list is only available if more than one Oracle database are registered in the TNS file). Note: If no database are registered in Oracle Client (DB list is empty in this case), then you need to add registration info manually.

 

Optimize Goal

Establishes the behavior for choosing an optimization approach for the instance.

 

hs2103 - Step1 - Setting connection properties

 

 

Tunneling settings

 

To setup the connection via SSH tunnel, input the following values in the corresponding fields:

  • SSH host name is the name of the host where SSH server is running
  • SSH port indicates the port where SSH server is activated
  • SSH user name stands for the user on the machine where SSH server is running (Note: it is a Linux/Windows user, not a user of Oracle server)
  • SSH password is the Linux/Windows user password

 

For details see SSH tunneling options.

 

 

When you are done, press the Next button to proceed to the next step of the wizard.