Oracle@1

Oracle@1 Provider lets you read data from ORACLE databases, no drivers needed.

Oracle@1 provider works out-of-the-box, you don’t need any drivers installed.

Example 

Data sources:
- Name: MyOracleDatabase
  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;

Notice you can use an environment variable instead of real password (enclose the environment variable name with percents). See How to work with Passwords.

Storing Test definitions and Data Source definitions in DB

Reading and testing data is not the only purpose of providers. You can also use them for retrieving (potentially also automatically generating) test defintions and / or data sources.

Any SQL statement that returns columns expected by Test definition or Data source defintition will work. But if you want to persist those, you might find useful these scripts that prepares the necessary tables:

CREATE TABLE CAT_TestDefinition(
  "TestSuite" NVARCHAR2(300) NULL,
  "Order" NUMBER(10) NULL,
  "TestCase" NVARCHAR2(300) NULL,
  "TestName" NVARCHAR2(300) NOT NULL,
  "Description" NCLOB NULL,
  "FirstDataSource" NVARCHAR2(200) NULL,
  "FirstQuery" NCLOB NULL,
  "SecondDataSource" NVARCHAR2(200) NULL,
  "SecondQuery" NCLOB NULL,
  "Expectation" VARCHAR2(50) NOT NULL,
  "Categories" NVARCHAR2(100) NULL,
  "Tolerance" NUMBER(19, 4) NULL,
  "Timeout" NUMBER(10) NULL,
  "Key" NVARCHAR2(100) NULL,
  "MaximumErrorsLogged" NUMBER(10) NULL
);

CREATE TABLE CAT_ConnectionDefinition(
  "Name" NVARCHAR2(200) NOT NULL,
  "Provider" NVARCHAR2(200) NOT NULL,
  "ConnectionString" NVARCHAR2(2000) NOT NULL
);

Just fill them up with data and let CAT know about them (see Project files).

← ORACLE
Postgres@1 →