Kettle Resource Pool Configuration

The role of the resource pool: The repository is used to save the operation steps and related logs, conversions, JOB and other information. Conversion tasks created by the user through the graphical interface can be saved in the repository. The repository can be a variety of common databases where users access resources in the resource pool via username/password, which is the default user name/password admin/admin. The resource pool is not required, and if there is no repository, the user can also save the conversion task in an XML file.
The transform file is ktr as an extension, and the job file is kjb as the extension.

The kettle repository includes a database repository and a file repository, encapsulated on a file and database basis, to implement the Org.pentaho.di.repository.Repository interface.
Kettle Resource Pool Configuration

1. Start Spoon.bat, click +, pop up the 1 window.

2. Select this repository uses a central relational the database to store ETL metadata. Popup 2 window

2. Select this repository uses a central relational the database to store ETL metadata. Popup 2 window

4 Click Test, test whether the configuration is correct, can connect to the resource database. such as 4

5. Click the OK button to save the resource

6. Click Execute to execute the SQL statement to create the table and related information in the database. Click Clear cache after creation is complete.

7. Select the configured repository and log in with admin.

Configure the job, transform, and log information to be saved to the database.

Attention:

1. Click Spoon.bat to flash through, probably because there is no configuration kettle_home environment variable

2. When configuring the resource pool data connection, click Test Error, because the database connection is missing the driver, the corresponding database-driven jar package to the next Kettle directory: Data-integration\libext\jdbc. Reproduce the boot Spoon.bat

2. When configuring the resource pool data connection, click Test Error, because the database connection is missing the driver, the corresponding database-driven jar package to the next Kettle directory: Data-integration\libext\jdbc. Reproduce the boot Spoon.bat

Kettle Resource Pool Configuration