Tedex is a database application utility for extracting test data.

You select a table and optional where clause, and it will navigate through all the foreign key constraints that apply to the starting data.

Primarily designed to access Oracle databases, it will also let you connect to :-

It also supports connections over SSH tunnels, and Oracle cloud wallet connections.

Extraction projects can be saved, opened and edited.

You can save the extracted data to a sql file as insert statements, or save the data to an Excel spreadsheet

You could also compare before and after data extract files as a way of checking test results.

Run the latest version of the TedEx application using Java 1.8 here.

A quick guide to running TedEx is here.

The latest development build version is here.