​
Prerequisites

To get the most out of this guide, you will need to:

​
Features

The table below outlines the features available for this type of connection.
  • Native - This refers to when a database client connects through a specific protocol, such as an IDE or client libraries through hoop connect <connection-name>.
  • One Off - This term refers to accessing this connection from hoop web panel.
FeatureNativeOne OffDescription
TLS Termination Proxy The local proxy terminates the connection with TLS, enabling the connection with the remote server to be TLS encrypted.
AuditThe gateway store and audit the queries being issued by the client
Data Masking (Google DLP)A policy can be enabled to mask sensitive fields dynamically when performing queries in the database.
Data Masking (MS Presidio)A policy can be enabled to mask sensitive fields dynamically when performing queries in the database.
Credentials OffloadThe user authenticates via SSO instead of using database credentials.
Interactive AccessInteractive access is available when using an IDE or connecting via a terminal to perform analysis exploration.

​
Configuration

NameTypeRequiredDescription
HOSTenv-varyesThe IP or Host of the Oracle server
USERenv-varyesThe user to connect in the Oracle server
PASSenv-varyesThe password to connect to the Oracle server. Make sure to URL encode the password if it contains any special characters.
PORTenv-varyesThe port of the Oracle server
SIDenv-varyesThe service name or SID (System identifier) to identify the database service.

​
Connection Setup

hoop admin create conn oracledb -a youragent \
  -e HOST=<host> \
  -e USER=<user> \
  -e PASS=<pass> \
  -e SID=<sid> \
  -e PORT=<port> \
   -- sqlplus -s '$USER/$PASS@$HOST:$PORT/$SID'
The Webapp doesn’t support Oracle connection type at the moment. In upcoming releases, we will add support for this connection type.

​
Connection Usage

You can access it through hoop web panel.
create tcp connection screenshot