Kettle resource pool configuration (database repository and file repository)

One "File Resource library Configuration

1. Create a file repository: Click Tools, Resource Library, connect repository menu

Using the file repository does not require a user name and password, and if there is no repository you can click on the "+" in the upper right corner to create a new repository, such as:

The first way is to set up a database repository, this example chooses to use the File resource library, select OK will ask to select the path of the file repository, and set an ID and name to the file repository

2. Create Transformations and Tasks

Like, feel free to create a transform

And then save to the repository, create the task basically the same way;

3. Browse the contents of the repository

If there are two buttons, the first one to open the library's transformation or task, and the second to browse the repository

Browse the repository as follows:

Browse the Library open window cannot directly open the transformation or task, tested, "/" under the conversion and tasks can be opened directly, but the folder below the need to configure the path to open

Ii. Database resource pool configuration

When you open kettle, the Library selection dialog box pops up, you can click the plus sign to create a new library, and if you have already opened kettle, you can connect to the repository after you have disconnected the repository in the Tools-> repository, or you can open the Create Library dialog box.

Clicking the plus sign to create a new library will bring up the following dialog box:

Click "Kettle File Repository" to create a way to store files, this is relatively simple, do not introduce. Click "Kettle File Repository" to create a database storage mode, click OK to pop up later:

Click on the "new" pop-up Database connection configuration, after the configuration has finished clicking "Create or Update", you can execute the SQL to create the repository

<ignore_js_op>

You can click Test to verify that the configuration is correct '

After that, you can view the tables in the database, such as R_transformation,r_user, to connect to the repository can use the default account Admin/admin and then you can create a new transformation in the kettle, save later can be viewed in the database. ‘

Kettle resource pool configuration (database repository and file repository)