---
title: "Oracle@1"
description: "Oracle@1 — ORACLE databases over Oracle.ManagedDataAccess, no driver needed"
url: "https://docs.justcat.it/reference/data-sources/providers/oracle-1/"
---
# Oracle@1


## Connects to

ORACLE databases, on premises or hosted.

## Example


**Properties**



Name
: MyOracleDatabase

Provider
: Oracle@1

Technology
: Oracle

Connection string
: ```
  Data Source=(DESCRIPTION = (
      ADDRESS = (PROTOCOL = TCP)(HOST = DATA1.DEMO.COM)(PORT = 1521)
  )
  (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DWHDemo)));
  User Id=User123;
  Password=%MyEnvironmentVariable%;
  Persist Security Info=True;
  ```





**YAML**


```yaml
Data sources:
- Name: MyOracleDatabase
  Provider: Oracle@1
  Technology: Oracle
  Connection string: >
      Data Source=(DESCRIPTION = (
          ADDRESS = (PROTOCOL = TCP)(HOST = DATA1.DEMO.COM)(PORT = 1521)
      )
      (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DWHDemo)));
      User Id=User123;
      Password=%MyEnvironmentVariable%;
      Persist Security Info=True;
```




## Connection string

A standard ODP.NET (`Oracle.ManagedDataAccess`) connection string — `Key=Value` pairs separated by semicolons. The keys you will use most:

| Key | Meaning |
|---|---|
| `Data Source` | Where the database is: a full TNS descriptor as in the example, a TNS alias, or the short `host:port/service_name` form |
| `User Id`, `Password` | Credentials |
| `Persist Security Info` | `False` by default; `True` leaves the password readable on the open connection — most setups do not need it |
| `Connection Timeout` | Seconds to wait for the connection to open |

The full list is in the <a href="https://docs.oracle.com/en/database/oracle/oracle-data-access-components/19.3/odpnt/ConnectionConnectionString.html" target="_blank">ODP.NET documentation</a>.

A password, or the whole string, can come from an environment variable — `%NAME%` is replaced with the value of `NAME`; see [How every provider is used](https://docs.justcat.it/reference/data-sources/providers/introduction/#how-every-provider-is-used "How every provider is used").

## Settings

None beyond `Connection string`.

## Query

One SQL statement in ORACLE's dialect that returns a result set — a `SELECT`.

## Prerequisites

None. The driver ships with CAT. Windows; on Linux it has no extra dependencies and is expected to work, but it has not been tested there.

## Serving test and data source definitions

`Oracle@1` can also serve [lists](https://docs.justcat.it/reference/project-file/lists/ "Lists") of definitions: any statement that returns the columns of a [test](https://docs.justcat.it/reference/tests/properties/ "Test properties"), [data source](https://docs.justcat.it/reference/data-sources/properties/ "Data source properties") or [query](https://docs.justcat.it/reference/queries/properties/ "Query properties") definition works. Ready-made table scripts are in [Store definitions in a database](https://docs.justcat.it/how-to-guides/organize-and-run-tests/store-definitions-in-a-database/ "Store definitions in a database").

## Related

* [Technologies](https://docs.justcat.it/reference/data-sources/technologies/ "Technologies").
* [ORACLE output](https://docs.justcat.it/reference/outputs/oracle/ "ORACLE output") — the same database can also receive the test results.