Introduction Google Drive is a combination of cloud storage and local disk synchronization services. Google Drive allows you to use Google’s servers as your primary file storage, and then sync those files to one or more devices. Supported devices include Windows (XP, Vista, 7), Mac OS X, iPad, iPhone, and Android (tables and phones). Google …
Introduction sed provides a quick and easy way to find and replace text via it’s search command (‘s’). Sample File Copy and paste the following text into a file named practice01.txt. Author: Akbar S. Ahmed Date: July 1, 2012 Subject: Sed sed is an extremely useful Unix/Linux/*nix utility that allows you to manipulate a text …
Introduction sed is short for Stream EDitor, which is a utility that allow you to parse and transform text one line at a time. sed is a useful tool, along with grep and awk, when manipulating text files. It is also often overlooked when working with Hadoop, although the use of sed, awk and grep …
Introduction There are many reasons for changing the Pentaho BI Server’s default port, but one of the most common is a conflict with another server. I ran into this issue where both the Pentaho User Console and the Hadoop MapReduce ShuffleHandler were trying to use port 8080. I wrote an earlier article on how to …
Introduction Creating a database in MySQL is exceptionally as you only have to execute one SQL statement after logging in. Step-by-Step Open a terminal and run the following commands. mysql -u root -p This will open the mysql> prompt. CREATE DATABASE mytest;
What is the Google Wallet Android app? I have finally had an occasion to use the Google Wallet app on my Galaxy Nexus. So what is the Google Wallet Android app? It’s basically an Android app that acts like a digital credit card that you can use to purchase coffee at Peet’s, medicine at CVS …
Introduction I had installed JDK 6.0 update 31 in an earlier post. However, I now need to write a Java application that requires the features available in JDK 7. In this post, I will install JDK 7 update 5 as a secondary JDK, while JDK 6.0 u31 will be the primary JDK. It’s perfectly normal …
Introduction Creating a DB connection from Kettle to MySQL involves creating a MySQL use who can access the DB in question, installing the JDBC driver, and creating a connection. Install the MySQL JDBC driver Download the MySQL JDBC driver from http://dev.mysql.com/downloads/connector/j/. Login to mysql.com, then click Download. cd ~/Downloads tar -xzf mysql-connector-java-5.1.20.tar.gz cd mysql-connector-java-5.1.20 cp …
Introduction Sakila is an example database for MySQL. It is often used for training purposes. Installation cd ~/Downloads wget http://downloads.mysql.com/docs/sakila-db.tar.gz tar -xzf sakila-db.tar.gz cd sakila-db mysql -u root -p < sakila-schema.sql mysql -u root -p < sakila-data.sql
Introduction Open Kettle cd ~/bin/data-integration To run Spoon: ./spoon.sh Create a new repository Run the following in a terminal. mkdir ~/kettle The steps below are performed within the PDI UI. In the Repository Connection dialog box, click the small green plus symbol. In the Select the repository type dialog box, select Kettle file repository. Click …
AkbarAhmed.com 