Kettle Creating a Database resource library

There are 3 common resource libraries in Kettle: Database repository, file repository, Pentaho resource library.

The file repository is defined as a repository in a file directory, because Kettle uses a virtual file system (Apache VFS), so the file directory here is a broad concept that includes zip files, Web services, FTP services.

The Pentaho repository is a plugin (available in the Kettle Enterprise Edition) and is actually a content management system (CMS) that has all the features of an ideal repository, including versioning and dependency integrity checking.

Database repository is to keep all the ETL information in the relational database, including database connection, transformation and job. Save, manage, and remotely schedule developed ETL transformations, jobs, and related configurations in the database repository. This article mainly introduces how to create a database repository:

1, enter the spoon, tools--Resource library--Connect the library, click the Plus + new resource Library

　　　　

2. Select Database repository and click OK

　　　　

3, database connection Select New, configure database connection information, proposed to create a new blank database

　　　　

　　　　

4, configure the database connection, select Create or update, continue to select Yes

　　　　

　　　　

　　　　

5. Select Execute SQL statement

　　　　

6, the prompt to execute the SQL error, select OK, later in the processing of this error, the above SQL to perform all the error prompts to determine

　　　

7. Now connect to the repository you just created will be error, as follows

　　　　　

8. Enter the SQL Server client below (because this is the SQL Server database repository, which adjusts according to the repository used), connect the repository you just created, execute the following SQL statement

DELETE TABLE r_version;

CREATE TABLE r_version

(Id_version INTEGER,

Major_version INTEGER,

Minor_version INTEGER,

Upgrade_date DATETIME,

Is_upgrade CHARACTER (1)

);

　　　　INSERT into R_version (id_version, Major_version, Minor_version, Upgrade_date, Is_upgrade) VALUES (1, 5, 0, ' 2017-09-1 3 ', ' N ');

　　　　SQL statements in different databases may be written differently, with the goal of successfully executing the SQL statements that are marked red

Now connect to the database repository you just created will find the user name password error, execute the following SQL statement, create a new user, at this time the user name password is admin

INSERT into R_user (Id_user, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED)

VALUES (1, ' admin ', ' 2be98afc86aa7f2e4cb79ce71da9fa6d4 ', ' Administrator ', ' User manager ', ' 1 ')

Now reconnect the repository you just created, username and password are admin, connection is successful!

Kettle Creating a Database resource library