Skip to content

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.

License

Notifications You must be signed in to change notification settings

leeevans/WhiteRabbit

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

alt text WhiteRabbit

Introduction

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.

Features

  • Can scan databases in SQL Server, Oracle, PostgreSQL, MySQL, and CSV files
  • The scan report contains information on tables, fields, and frequency distributions of values
  • Cutoff on the minimum frequency of values to protect patient privacy
  • Interactive tool (Rabbit in a Hat) for designing the ETL using the scan report as basis
  • Rabbit in a Hat generates ETL specification document according to OMOP template

Screenshots

White Rabbit Rabbit in a Hat
White RabbitRabbit in a Hat

Technology

White Rabbit and Rabbit in a Hat are pure Java applications. Both applications use Apache's POI Java libraries to read and write Word and Excel files. White Rabbit uses JDBC to connect to the respective databases.

System Requirements

Requires Java 1.7 or higher, and read access to the database to be scanned. Java can be downloaded from http://www.java.com.

Dependencies

  • There are no dependencies.

Getting Started

WhiteRabbit

  1. Under the Releases tab, download WhiteRabbit*.zip
  2. Unzip the download
  3. Double-click on WhiteRabbit.jar to start White Rabbit.

Rabbit-In-A-Hat

  1. Using the files downloaded for WhiteRabbit, double-click on RabbitInAHat.jar to start Rabbit-In-A-Hat.

Getting Involved

License

WhiteRabbit is licensed under Apache License 2.0

Development

White Rabbit and Rabbit in a Hat are being developed in Eclipse. Contributions are welcome. ###Development status Beta testing - We invite everyone to try the software, and report any issues they may find.

About

WhiteRabbit is a small application that can be used to analyse the structure and contents of a database as preparation for designing an ETL. It comes with RabbitInAHat, an application for interactive design of an ETL to the OMOP Common Data Model with the help of the the scan report generated by White Rabbit.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 100.0%