Get Help

Oracle@1

Oracle@1 reads data from ORACLE databases. Nothing to install.

Connects to

ORACLE databases, on premises or hosted.

Example

Name
MyOracleDatabase
Technology
ORACLE
Provider
Oracle@1
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;

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 ODP.NET documentation.

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.

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 of definitions: any statement that returns the columns of a test, data source or query definition works. Ready-made table scripts are in Store definitions in a database.

← Odbc@1
Postgres@1 →