Skip to content

Instantly share code, notes, and snippets.

@jheys
Created September 20, 2013 14:11
Show Gist options
  • Save jheys/6638175 to your computer and use it in GitHub Desktop.
Save jheys/6638175 to your computer and use it in GitHub Desktop.
Installs Pentaho Data Integration (Kettle) CE tools with MS SQL and MySQL connectors/drivers for JDBC
# Download
wget http://hivelocity.dl.sourceforge.net/project/pentaho/Data%20Integration/4.4.0-stable/pdi-ce-4.4.0-stable.tar.gz
wget http://cdn.mysql.com/Downloads/Connector-J/mysql-connector-java-5.1.26.tar.gz
wget http://download.microsoft.com/download/0/2/A/02AAE597-3865-456C-AE7F-613F99F850A8/sqljdbc_4.0.2206.100_enu.tar.gz
# Extract
tar -xvzf pdi-ce-4.4.0-stable.tar.gz
tar -xvzf mysql-connector-java-5.1.26.tar.gz
tar -xvzf sqljdbc_4.0.2206.100_enu.tar.gz
# Move/Rename
mv data-integration/ kettle/
cp mysql-connector-java-5.1.26/mysql-connector-java-5.1.26-bin.jar kettle/libext/JDBC/mysql-connector-java-5.1.26-bin.jar
cp sqljdbc_4.0/enu/sqljdbc4.jar kettle/libext/JDBC/sqljdbc4.jar
# Cleanup
rm pdi-ce-4.4.0-stable.tar.gz
rm mysql-connector-java-5.1.26.tar.gz
rm -rf mysql-connector-java-5.1.26
rm sqljdbc_4.0.2206.100_enu.tar.gz
rm -rf sqljdbc_4.0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment