AkbarAhmed.com

Engineering Leadership

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;

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 …

Continue reading

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 …

Continue reading

Introduction Installing the MySQL package on Ubuntu is extremely simple. Installation Open a terminal and enter the following commands. sudo apt-get install mysql-client mysql-navigator mysql-server Type Y to accept the additional packages. Press Enter. After downloading and during installation, the MySQL configuration dialogs will display in the terminal. In the first dialog, press Enter. Enter …

Continue reading