Oracle DB

Prerequisites

• Access credentials
• Database name, Host, Port
• Oracle SID

Create a New OracleDB Connection

In Figure 2 above:

• Access Type (required): The type of connection: Read-Only, Write-Only, Read-Write.
• Connection Name (required): The name to identify this connection with, such as 'OracleDB Connection'.
• Host (required): IP or the hostname of the OracleDB Server.
• Port (optional): Host server port number.
• Oracle SID (required): Oracle site identifier.
• Choose Credentials (required): Choose from existing credentials or create new credential for connecting to OracleDB if 'Required Credentials' checkbox is selected.

In Figure 3 above, create new credentials if the Required Credentials checkbox was selected and you do not want to use an existing credential.

• Credential Name (required): The name to identify this credential with.
• User (required): OracleDB username to connect with.
• Password (required): OracleDB password to connect with.

In Figure 4 above, use TEST CONNECTION button to check whether credentials are correctly configured and If ALL PASS, click CREATE.