Integration
Connect FairTest to Oracle Database
When something happens in FairTest, your agent does the next thing in Oracle Database. Describe it in plain language and the automation is built, tested on every branch and kept running.
Build it
What do you want FairTest and Oracle Database to do together?
Describe it and your agent reads both APIs, builds the automation, tests every branch and ships it. The list below is what exists today, not the limit.
Ask the assistant
You'll sign in before anything runs. What you typed comes with you.
Or work from Claude Code
Install the APIANT plugin for Claude Code and build, edit, test and read run history from your terminal. Every plan gets this, including free, and it spends no assistant credits.
Connect Claude CodeEverything your agent can do with FairTest and Oracle Database
Triggers and actions 7 triggers ยท 14 actions
Trigger
New EmployeeTriggers when a new employee is added.
Trigger
New Selection EventTriggers when a random selection is run.
Action
Create EmployeeCreates a new employee
Action
Get employeeRetrieve a single employee by id.
Action
Get selectionRetrieve a single random selection event by id.
Action
List employeesList employees in the organisation, with pagination.
Action
List selectionsList random selection events, with pagination.
Action
Run Random SelectionRandomly selects employees for drug and alcohol testing
Action
Update EmployeeUpdates an existing employee
Trigger
New ColumnFires when a new column appears on an Oracle table you choose.
Trigger
New or Updated RowTriggers when a new row is added or modified.
Trigger
New or Updated Row (Custom Query)Fires for each new or changed row returned by a SELECT statement you write against the connected Oracle database.
Trigger
New RowTriggers when you add a new row.
Trigger
New TableFires when a new table appears in the connected Oracle user's own schema.
Action
Add RowAdd one row to a table on the connected Oracle database.
Action
Delete RowDelete the rows in a table whose chosen column equals a value.
Action
Find RowFind the first row in a table whose chosen column matches a value.
Action
Find Rows via Custom QueryRuns a SELECT statement you write against the connected Oracle database and returns every row it matches.
Action
Find Row via Custom QueryRuns a SELECT statement you write against the connected Oracle database and returns the first row it matches.
Action
Run Custom StatementRuns a statement you write against the connected Oracle database that changes data rather than returning rows, and reports how many rows it changed.
Action
Update RowChange column values on every row of a table whose chosen column matches a value.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.