Kettle Configuration Resource Library

Kettle is an open-source ETL tool designed to transform data through a graphical interface. Well-designed files are divided into two categories, one is trans, and the other is job, which can be stored in the file system.

can also be stored in a database.

If you are storing to a database, you can create a configuration repository.

Configuration steps

Open the design tool Spoon.bat

Click the plus sign

Click Create or update

Here we need to adjust the SQL statement

INSERT into R_user (Id_user, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (1, ' admin ', ' 2be98afc86aa7f2e4cb79ce71da9fa6d4 ', ' Administrator ', ' User manager ', 1);

INSERT into R_user (Id_user, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (2, ' guest ', ' 2be98afc86aa7f2e4cb79ce77cb97bcce ', ' Guest account ', ' read-only Guest account ', 1;

Enabled is the original character type, the database is shaping, need to make the next adjustment.

INSERT into R_version (id_version, Major_version, Minor_version, Upgrade_date, Is_upgrade) VALUES (1,5,0, ' 2016/11/10 22:39:37.967 ', 0);

Is_upgrade originally was ' N ' modified to 0.

After the SQL is executed.

Here the admin's initial password is admin.

You can see that the resource connection has been created.

Kettle Configuration Resource Library