Import Cases with Kettle

Instructions by Kari Kauppinen for importing test cases using Kettle tool.

Configuration Files

Download configuration files in zip package.


First I created an “import” user for mysql

mysql -u root
use testia;
CREATE USER 'testia'@'%' IDENTIFIED BY 'testia'; 
GRANT ALL PRIVILEGES ON *.* TO 'testia'@'%';

Then altered the steps table:

alter table steps add column external_id varchar(255);
alter table step_versions add column external_id varchar(255);

Then edited the file

TESTIA_MYSQL_PWD=Encrypted 2be98afc86aa7f2e4cb79ba75cd86a6db

I have included this in the zip-file.


If you want to change this use file from kettle main directory. -kettle password

this returns the “encrypted Passwordinencryptedformat”


The Cases and steps are in the excel-file. You should check the project field to match your tarantula project id.

I have zipped the Kettle repository from C:\TEMP\Testia

Download kettle from (4.2.1 version)
unzip it into C:\program files\pentaho\data-integration
run the C:\temp\Testia\import.bat


If you unzip to different folder change .kettle/repositories.xml line:



If you are using linux:

create directory /opt/repo/
unzip the to /opt/repo

You should have directory /opt/repo/Testia looks like (remove the — signs) :

export KETTLE_HOME=$( cd "$( dirname "$0" )" && pwd )
$PENTAHO_PATH/$KITCHEN -rep="Testia" -job="Import_data" -param:IMPORT_FILE="Cases_Steps.xls"

Change PENTAHO_PATH to match your installation

change .kettle/repositories.xml line:


Run the from the /opt/repo/Testia


Original support thread