# Oracle

{% hint style="warning" %}
**CARTO + Oracle is in private preview**

Oracle connections are only enabled to selected organizations. To become part of the private preview, please get in touch with your CARTO representative.

If you want to learn more about what's included, please check the [Oracle Supported Features](#supported-features) and the [Limitations & FAQs](#limitations-and-faqs) sections.
{% endhint %}

You can use CARTO with your data in an Oracle database, with full support for Oracle Spatial (`SDO_GEOMETRY`) and GeoRaster data types. **CARTO supports Oracle Database 19c and higher.**

## Authentication with Oracle Wallet

Oracle connections in CARTO use **Oracle Wallet** for secure authentication. [Oracle Wallet](https://docs.oracle.com/cd/E92519_02/pt856pbr3/eng/pt/tsvt/concept_UnderstandingOracleWallet.html?pli=ul_d96e224_tsvt) is a container that stores authentication and signing credentials, including private keys, certificates, and trusted certificates needed for secure connections.

If you want to create a connection to your Oracle database, you need to select the Oracle connector in the *New connection* dialog. After you select the connector click on the *Setup connection* button.

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-ee309ddb78766b6fb5a23d4ec77f83918baf3b89%2FScreenshot%202025-11-07%20at%2016.05.37.png?alt=media" alt=""><figcaption></figcaption></figure>

### Required Parameters

To establish a connection, you need to provide the following:

* **Name:** The name for the Oracle connection you're creating. You can use the name to identify different connections.
* **Wallet File (ZIP)**: Upload your Oracle Wallet file containing the security credentials and certificates. This file is typically provided by your Oracle database administrator.
* **Wallet Password**: The password protecting your Oracle Wallet file.
* **Username**: Name of the user account that will access the Oracle database.
* **Password**: Password for the user account.

<figure><img src="https://3029946802-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FybPdpmLltPkzGFvz7m8A%2Fuploads%2Fgit-blob-0c6fd4bc2520873644127ed7dacd87a3dd510ffd%2FScreenshot%202025-11-07%20at%2016.07.15.png?alt=media" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
**About Oracle Wallet**

Oracle Wallet files are ZIP archives containing security credentials. Your database administrator can provide this wallet file along with the connection string and wallet password. For Oracle Autonomous Database, you can download the wallet file from the Oracle Cloud Console.
{% endhint %}

Once you have entered all the parameters, you can click the *Connect* button. CARTO will try to connect to your Oracle database using the wallet credentials. If everything is OK, your new connection will be registered.

{% hint style="info" %}
CARTO will try to minimize and reuse the number of connections (sockets) made to the Oracle database. But in some cases the amount of connections can grow rapidly. If you have a strong requirement to control the incoming connections to your database, we recommend configuring connection pooling on your Oracle database.

The connections are only reused if they are going through the same CARTO-Oracle Connection. If you set up many Connections in your organization, the amount of database connections will grow faster.
{% endhint %}

### Advanced options <a href="#ip-whitelisting" id="ip-whitelisting"></a>

{% hint style="warning" %}
**Note:** Analytics Toolbox and Data Observatory locations are not yet available for Oracle connections.
{% endhint %}

* **CARTO temp location**

  Location to store **temporary tables** used during workflow execution. These include intermediate tables with hashed names created by nodes in a workflow. By default, CARTO uses a `carto_temp` schema per database.\
  **Example:** `my_oracle_db.carto_temp`

## IP Whitelisting <a href="#ip-whitelisting" id="ip-whitelisting"></a>

If you're using the cloud version of CARTO (SaaS), CARTO will connect to Oracle using a set of static IPs for each region. [Check this guide to find the IPs you need to allow](https://docs.carto.com/carto-user-manual/connections/ip-whitelisting) for your specific region.

## Supported Features

{% hint style="success" %}
**Oracle Spatial & GeoRaster Support**

Oracle connections fully support:

* **Oracle Spatial (SDO\_GEOMETRY)**: Native support for Oracle's spatial data type, including point, line, and polygon geometries
* **GeoRaster**: Support for raster data analysis with dedicated workflow components
* **Self-Hosted Deployments**: Available in both CARTO Cloud and Self-Hosted environments
  {% endhint %}

## Limitations & FAQs

Oracle connections in CARTO are currently under **private preview** currently have the following limitations:

{% hint style="warning" %}

* **Analytics Toolbox:** The general Analytics Toolbox (spatial analysis functions like clustering, enrichment, and spatial indexes) is not yet available for Oracle. However, 55+ standard workflow components are supported, including extensive spatial operations, plus Oracle-specific components for raster analysis and geocoding.
* **Data Import:** Direct file import to Oracle tables through the CARTO interface is not yet supported. Data must be loaded directly into Oracle using native tools.
* **Workflows:** Oracle supports most standard workflow components including spatial operations (buffer, intersection, centroid, etc.), data operations (select, join, filter, etc.), and Oracle-specific components (geocoding, raster loading and analysis). Components that depend on the Analytics Toolbox (H3/Quadbin indexes, clustering, enrichment, ML) are not yet available. See the [Workflows Components documentation](https://docs.carto.com/carto-user-manual/workflows/components) for the complete list.
  {% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.carto.com/carto-user-manual/connections/oracle.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.