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.
White Rabbit | Rabbit in a Hat |
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.
Whte Rabbit and Rabbit In A hat were designed and implemented for use within a secure and trusted environment. No efforts have been made to encrypt or otherwise protect the passwords, parameters and results. This should be kept in mind when deploying these tools.
Requires Java 1.8 or higher for running, and read access to the database to be scanned. Java can be downloaded from http://www.java.com.
For the distributable packages, the only requirement is Java 8. For building the package, Java 17+ and Maven are needed. There are exceptions for databases that use a JDBC driver with a license that does not allow distribution of the driver. (BigQuery, Teradata)
BigQuery
If you want to use a BigQuery instance as the source database, after installing WhiteRabbit, you will need to download
a zip file with the BigQuery JDBC driver, and unzip it in de repo
directory of the WhiteRabbit installation.
The latest version tested with WhiteRabbit is 1.5.2.1005 .
The zip file can be downloaded here
Teradata
If you want to use a Teradata instance as the source database, after installing WhiteRabbit, you will need to download
a zip file with the Teradata JDBC driver, and unzip it in de repo
directory of the WhiteRabbit installation.
The latest version tested with WhiteRabbit is 20.00.00.16 .
The zip file can be downloaded here
WhiteRabbit
WhiteRabbit*.zip
bin/whiteRabbit.bat
on Windows to start White Rabbit, and bin/whiteRabbit
on macOS and Linux.(See the documentation for details on how to run from the command prompt instead)
Rabbit-In-A-Hat
bin/rabbitInAHat.bat
to start Rabbit-In-A-Hat on Windows, and bin/rabbitInAHat
on macOS and Linux.Note: on releases earlier than version 0.8.0, open the respective WhiteRabbit.jar
or RabbitInAHat.jar
files instead.
WhiteRabbit is licensed under Apache License 2.0
Production. This program is being used by many people.