Shulou(Shulou.com)06/02 Report--

This article to share with you is about the open source kettle scheduling and management platform kettle-manager deployment is what kind of, Xiaobian think quite practical, so share with you to learn, I hope you can read this article after some gains, not much to say, follow Xiaobian to see it.

1, mainly for deployment release version installation support windows and liunx system

2. I downloaded it locally using V0.4.0

Then download version 4.0 of the Extreme Experience.

3. Decompress the two compressed packages to configure the resource library and system library

There are two main types of system databases and resource libraries for configuring release versions: mysql and oracle.

I use mysql to find the sql script executed by mysql, script path: kettle-manager\doc\sql\mysql

Create two new users in my mysql database, one kettle resource database and one km system database

kettle.sql and myNote.sql are repositories execute these two sql scripts under ketlle user

After execution, there will be new tables and two view tables

km.sql Execute km.sql script under km user

4. Configure two environmental variables

This time, we use the version of kettle5.4 in the integrated installation package downloaded above, because it will use the jar package in ext-lib.

path =kettle-manager0.4.0 integration package\kettle-manager\data-integration

Configure the environment variable KETTLE_JNDI_ROOT=F:\webkettle\kettle-manager0.4.0 Integration package\kettle-manager\data-integration\simple-jndi

Configure the environment variable KETTLE_HOME=F:\webkettle\kettle-manager0.4.0 Integration package\kettle-manager\data-integration

5. Start the integrated kettle 5.4 Connect the kettle repository created above

path =kettle-manager0.4.0 integration package\kettle-manager\data-integration

Check whether the repository connection is successful.

6. Copy the configuration file of Kettle5.4 to Kettle-Manager project

Replace jdbc.properties in kettle-manager

7. Modify the configuration file under the kettle-manager project default file

jdbc.config is the main file used, jdbc.config_mysql is mysql as the configuration case template of the system library and resource library, jdbc.config_oracle is oracle as the configuration case template of the system library and resource library, this time I use mysql, so modify the jdbc.config_mysql configuration template, modify the jdbc.config_mysql main file named jdbc.config.bak, modify the name jdbc.config main file of mysql,

8. Start Kettle-Manager

cmd doc page inside the execution of km.bat The following figure represents the successful configuration, there are some command parameters say name

Star km.bat-info Display configuration information The following information My kettle refers to kettle7

The following diagram does not successfully check that your environment variables are not set or have problems with their settings.

Configuration loaded successfully. Start execution km.bat -start.

Welcome appears. Launch complete.

Error The following is your repository and system repository configuration may not be paired up, the solution is to check your two data source configurations.

9. Landing interface

Enter address: http://localhost:82/Account: admin Password: 000000

The reason why I had an error on the page at that time was because myNote.sql was executed to km users, and the kettle repository was not executed.

10. Replace the kettle version

modify environment variables

The above is what the deployment of open source kettle scheduling and management platform kettle-manager is like. Xiaobian believes that some knowledge points may be seen or used in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.