All free apps
– Android File Transfer (OK, that one I actually installed on my latop to sync my phone on my Mac)
– Llama – Change phone settings based on location
– TrustGo Mobile – antivirus (one can never be too careful)
– Aviate – Theme your phone based on times of day
– PasswdSafe/PasswdSafeSync (to be able to open your PasswordSafe file straight from your dropbox)
– JuiceSSH – free good SSH client
– AndroZIP – Handles Archive Files
– Dropbox – Access your dropbox files
– AndSMB – Access your network shares to upload and download files
– Komik Reader – Read comics!
to do properly what Windows should do but doesn’t (not properly anyway)
Tabbed Windows Explorer
TabExplorer – http://www.iwesoft.com/product/36/tabexplorer
AgentRansack – http://www.mythicsoft.com/agentransack
General Code Editor
Notepad++ – http://notepad-plus-plus.org/
7Zip – http://www.7-zip.org/
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!