> ## Documentation Index
> Fetch the complete documentation index at: https://hoopdev-update-to-meta-tags.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle

> Execute queries to Oracle instances with [sqlcl](https://www.oracle.com/database/sqldeveloper/technologies/sqlcl/).

## Prerequisites

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

* Either [create an account in our managed instance](https://use.hoop.dev) or [deploy your own hoop.dev instance](/getting-started/installation/overview)
* You must be your account administrator to perform the following commands

## 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.

| Feature                    | Native                 | One Off               | Description                                                                                                             |
| -------------------------- | ---------------------- | --------------------- | ----------------------------------------------------------------------------------------------------------------------- |
| TLS Termination Proxy      | <Icon icon="xmark" />  | <Icon icon="check" /> | The local proxy terminates the connection with TLS, enabling the connection with the remote server to be TLS encrypted. |
| Audit                      | <Icon icon="xmark" />  | <Icon icon="check" /> | The gateway store and audit the queries being issued by the client                                                      |
| Data Masking (Google DLP)  | <Icon icon="xmark" />  | <Icon icon="check" /> | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database.                   |
| Data Masking (MS Presidio) | <Icon icon="xmark" />  | <Icon icon="check" /> | A policy can be enabled to mask sensitive fields dynamically when performing queries in the database.                   |
| Credentials Offload        | <Icon icon="xmark" />  | <Icon icon="check" /> | The user authenticates via SSO instead of using database credentials.                                                   |
| Interactive Access         | <Icon icon="xmark" />  | <Icon icon="check" /> | Interactive access is available when using an IDE or connecting via a terminal to perform analysis exploration.         |

## Configuration

| Name | Type    | Required | Description                                                                                                               |
| ---- | ------- | -------- | ------------------------------------------------------------------------------------------------------------------------- |
| HOST | env-var | yes      | The IP or Host of the Oracle server                                                                                       |
| USER | env-var | yes      | The user to connect in the Oracle server                                                                                  |
| PASS | env-var | yes      | The password to connect to the Oracle server. Make sure to URL encode the password if it contains any special characters. |
| PORT | env-var | yes      | The port of the Oracle server                                                                                             |
| SID  | env-var | yes      | The service name or SID (System identifier) to identify the database service.                                             |

## Connection Setup

```sh
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'
```

<Warning>
  The Webapp doesn't support Oracle connection type at the moment.
  In upcoming releases, we will add support for this connection type.
</Warning>

{/* <Frame>
  <img src="/images/quickstarts/create-database-connection-screenshot.png" alt="create tcp connection screenshot" />
</Frame> */}

## Connection Usage

You can access it through hoop web panel.

<Frame>
  <img src="https://mintlify.s3.us-west-1.amazonaws.com/hoopdev-update-to-meta-tags/images/quickstarts/client-pg.png" alt="create tcp connection screenshot" />
</Frame>