Evaluation is still work in progress but I thought I would jolt down my findings as I go.
- Tool Description and Relevant Links
- Connection to database (to run jobs directly on the source of the data)
I used a MS SQL database for my test, other sources of data are available as per Juicebox one pager documentation but I haven’t tried these.
I didn’t find it a straightforward process but then I am no java expert. The MSSQL driver (I used the Microsoft JDBC Driver 4.0 for SQL Server – http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774) isn’t included in the Juicebox application and I didn’t find a way to add it while running the application using the embedded jetty server, I am guessing it would require unpacking the juicebox.war, adding the driver JAR, and repacking it.
Instead, I installed Apache Tomcat, deployed juicebox on it and added the JAR file to the exploded juicebox file structure, $CATALINA_HOME\webapps\juicebox\WEB-INF\lib (I am on Windows). This makes the MS SQL driver available to Juicebox.
Do read the help file bundled with the driver files for the syntax to use to define your Driver and Connection URL. For me, it ended up looking like the below:
JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC Connection URL: jdbc:sqlserver://<serverName>:<serverPort>;databaseName=<databaseName>;user=<userName>;password=<userPassword>;
And it works!