pdi 8.2（kettle）在linux运行时图形界面中资源库中各菜单为灰色

最新推荐文章于 2022-05-07 16:39:21 发布

原创最新推荐文章于 2022-05-07 16:39:21 发布 · 3k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#kettle #pdi #资源库

ETL 专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍如何在Kettle中配置连接至MySQL数据库仓库的过程，包括设置repositories.xml文件，删除缓存并重启Spoon，实现Kettle与MySQL的无缝对接。

2018/12/26 11:10:24 - Spoon - Connected to metastore : file_etl_repository, added to delegating metastore
2018/12/26 11:10:25 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
2018/12/26 11:18:04 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml
2018/12/26 11:18:44 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml

1、将repositories.xml放入 .kettle 目录下面，文件内容如下：

<?xml version="1.0" encoding="UTF-8"?>
<repositories>
  <connection>
    <name>mysql_repository</name>
    <server>192.168.1.112</server>
    <type>MYSQL</type>
    <access>Native</access>
    <database>mysql_repository</database>
    <port>3306</port>
    <username>mysqluser</username>
    <password>Encrypted 2be98afc86aa7b681bd48fc238ac7f990</password>
    <servername/>
    <data_tablespace/>
    <index_tablespace/>
    <attributes>
      <attribute><code>EXTRA_OPTION_MYSQL.characterEncoding</code><attribute>UTF-8</attribute></attribute>
      <attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
      <attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
      <attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>
      <attribute><code>PORT_NUMBER</code><attribute>3306</attribute></attribute>
      <attribute><code>PRESERVE_RESERVED_WORD_CASE</code><attribute>Y</attribute></attribute>
      <attribute><code>QUOTE_ALL_FIELDS</code><attribute>N</attribute></attribute>
      <attribute><code>STREAM_RESULTS</code><attribute>Y</attribute></attribute>
      <attribute><code>SUPPORTS_BOOLEAN_DATA_TYPE</code><attribute>Y</attribute></attribute>
      <attribute><code>SUPPORTS_TIMESTAMP_DATA_TYPE</code><attribute>Y</attribute></attribute>
      <attribute><code>USE_POOLING</code><attribute>N</attribute></attribute>
    </attributes>
  </connection>

  <repository>  
    <id>KettleFileRepository</id>
    <name>file_repository</name>
    <description>File repository</description>
    <is_default>true</is_default>
    <base_directory>/opt/kettle</base_directory>
    <read_only>N</read_only>
    <hides_hidden_files>N</hides_hidden_files>
  </repository>  

   </repositories>

2、删除目录/opt/data-integration/system/karaf/caches/spoon下面的data-1