Pentaho Data Integration - How To Create a Repository (#001)

Create a database user "penrep", and a password "penrep".

Run Pentaho. First window is "Repository Connection". Click the plus sign in the top right corner.

Select "Kettle database repository" and click "OK".

In the  "Repository Information" window, click "New" next to the "Select Database Connection" field.

In the "Database Connection" window.
Connection Name: conn_oracle11g_orcl_penrep_penrep
Host Name: host name or IP address
Database Name: orcl
User Name: penrep
Password: penrep

Connections’ naming convention:
- Oracle:        conn_[rdbms]_[instance]_[schema]_[username]
- SQL Server: conn_[rdbms]_[instance]_[database]_[schema]_[username]

Click "Test".

In the"Repository Information" window, the "Database Connection" field contains the name of the connection created in the previous steps.

Add "ID" and "Name" to "Repository Information"
ID: penrep_id
Name: penrep_name

Click "Create or Update"

Yes

Yes

"Simple SQL Editor". Click "Execute".

"Results of the SQL Statements":

"Repository Connection" window contain repository name:

Filling the "Password" field and clicking the "OK" button adds password to the repository connection.

Repository ID can be seen on the Pentaho's window title bar.

Exploring Repository:

At the moment repository is empty. Repository ID can be seen on the title bar.