Pentaho Kettle管理员操作与资源管理详述（2013年版）

需积分: 9 86 浏览量更新于2024-07-23 收藏 361KB PDF 举报

"Kettle管理员手册是一份全面指南，针对Pentaho Business Analytics Suite 5.0 GA和Pentaho Data Integration 5.0 GA版本提供了深入的管理员操作和资源管理教程。发布日期为2013年8月22日，版权归属于Pentaho Corporation，所有内容未经书面许可不得复制。这份文档旨在帮助用户理解和执行Kettle的各种管理工作，包括但不限于服务器配置、数据集成流程设计、性能监控和故障排查。首先，管理员章节详细介绍了如何管理和维护Kettle的DI Server，包括安装、配置、启动和停止服务，以及如何处理服务器级别的权限管理和安全设置。这部分内容对于确保系统稳定运行和数据安全性至关重要。其次，文档提供了丰富的帮助和支持资源。如果在阅读过程中遇到问题，用户可以联系Pentaho的技术支持代表，通过客户服务门户http://support.pentaho.com提交问题。购买额外的支持或寻求专业指导时，应联系销售团队或发送电子邮件至sales@pentaho.com。此外，手册还推荐了官方的培训课程，以便进一步提升管理员的专业技能，网址为http://www.pentaho.com/training。在法律方面，作者在编写此文档时已尽最大努力保证内容的准确性和程序的有效性。这些努力包括理论研究、实践测试以及验证各种方法的有效性。然而，用户在实际应用中需要自行承担使用风险，因为文档提供的信息可能会随着软件更新而有所变化。因此，用户在操作时应结合最新的官方文档和版本更新进行。这份Kettle管理员手册为Pentaho平台的运维人员提供了一个宝贵的参考资源，帮助他们高效、安全地管理数据集成环境。无论是在日常维护还是应对技术挑战时，它都是不可或缺的工具。"

| Specify Data Connections for the DI Server | 9

Section Name What to Do

Database Name Enter the name of the database to which you are

connecting. If you are using a ODBC connection, enter

the Data Source Name (DSN) in this field.

Port Number Enter the TCP/IP port number if it is different from the

default.

User name Optionally, type the user name used to connect to the

database.

Password Optionally, type the password used to connect to the

database.

2. Click Test.

A confirmation message displays if Spoon is able to establish a connection with the target database.

3. Click OK to save your entries and exit the Database Connection dialog box.

4. From within the View tab, right-click on the connection and select Share from the list that appears.

This shares the connection with your users. They will be able to select the shared connection.

From within the View tab, click Explore to open the Database Explorer for an existing connection. This shows you

the schemas and tables inside the connection.

Add Database-Specific Options

Add database-specific options by adding parameters to the generated URL.

1. From within the Database Connection dialog box, select Options.

2. Select the first available row in the parameter table.

3. Choose the database type and enter a valid parameter name and its corresponding value.

Note: For more database-specific configuration help, click Help. A new browser opens and displays

additional information about configuring the JDBC connection for the currently selected database type.

4. Click OK to save your entries.

Advanced Configuration of Database Connections

The Advanced option in the Database Connection dialog box allows you to configure properties that are, for most

part, associated with how SQL is generated. These options allow you to set a standard across all of your SQL tools,

ETL tools and design tools. All database table names and column names are always upper case or lower case no

matter what users do in the tools.

Feature Description

Supports boolean data types Instructs PDI to use native boolean data types if

supported by the database.

Quote all in database Enables the databases to use a case-sensitive tablename

(for example MySQL is case-sensitive on Linux but not

case sensitive on Windows). If you quote the identifiers,

the databases will use a case sensitive tablename.

Force all to lower case Enables all identifiers to lower case.

Force all to upper case Enables all identifiers to upper case.

Preferred schema name... Enter the preferred schema name (for example,

MYSCHEMA).

Enter SQL name... Enter the SQL statement used to initialize a connection.

Pentaho has implemented a database-specific quoting system that allows you to use any name or character acceptable

to the supported databases' naming conventions.

Pentaho Data Integration contains a list of reserved words for most of the supported databases. To ensure that quoting

behaves correctly, Pentaho has implemented a strict separation between the schema (user/owner) of a table and

| Specify Data Connections for the DI Server | 10

the table name itself. Doing otherwise makes it impossible to quote tables or fields with one or more periods in them

correctly. Placing periods in table and field names is common practice in some ERP systems (for example, fields such

as "V.A.T.")

To avoid quoting-related errors, a rule stops the Pentaho Data Integration from performing quoting activity when there is

a start or end quote in the table name or schema. This allows you to specify the quoting mechanism yourself.

Define Connection Pooling

Instead of having a connection open for each individual step in a transformation, you can set up a connection pool and

define options like the initial pool size, maximum pool size, and connection pool parameters. For example, you might

start with a pool of ten or fifteen connections, and as you run jobs or transformations, the unused connections drop off.

Pooling helps control database access, especially if you have transformations that contain many steps and that require

a large number of connections. Pooling can also be implemented when your database licensing restricts the number of

active concurrent connections.

This table shows descriptions of the pooling options.

Feature Description

Enable connection pooling Enables connection pooling

Pool Size Sets the initial size of the connection pool; sets the

maximum number of connections in the connection pool

Parameters Allows you to define additional custom pool parameters;

click Restore Defaults when appropriate

Description Allows you to add a description for your parameters

1. Select Enable Connection Pooling.

2. Type the initial pool size in the Initial: area and the maximum pool size in the Maximum: area.

3. Select the parameters you need from within the Parameters: area.

A Description of the parameter appears in the Description: area when you select a check box.

4. Click OK to save your selections and close the Database Connection dialog box.

Connect to Clusters

This option allows you to enable clustering for the database connection and create connections to the data partitions.

To create a new data partition, enter a Partition ID and the Host Name, Port, Database, User Name, and Password

for connecting to the partition.

Modify Connections

This table contains information about other database-related connection tasks you can perform.

Task Description

Edit a Connection Right-click on the connection name and select Edit.

Duplicate a Connection Right-click on the connection name and select Duplicate.

Copy to a Clipboard Allows you to copy the XML defining the step to the

clipboard. You can then paste this step into another

transformation. Double-click on the connection name in

the tree or right-click on the connection name and select

Copy to Clipboard.

Delete a Connection Double-click on the connection name in the tree or right-

click on the connection name and select Delete.

SQL Editor To execute SQL command against an existing

connection, right-click on the connection name and select

SQL Editor.

Clear the Database Cache To speed up connections Pentaho Data Integration uses

a database cache. When the information in the cache no

| Specify Data Connections for the DI Server | 11

Task Description

longer represents the layout of the database, right-click on

the connection in the tree and select Clear DB Cache....

This command is commonly used when databases tables

have been changed, created or deleted.

Share a Connection Rather than redefining a connection each time you create

a job or transformation on your local device, right-click

and select Share to share the connection information

among jobs and transformations.

Exploring the Database Double-click on the connection name in the tree or right-

click on the connection name and select Explore.

Show dependencies Right-click a connection name and select Show

dependencies to see all of the transformations and jobs

that use this database connection.

Define JNDI Connections for the DI Server

Pentaho has supplied a way of configuring a JNDI connection for "local" Pentaho Data Integration use so that you

do not have an application server continuously running during the development and testing of transformations. To

configure, edit the properties file called jdbc.properties located at ...\data-integration-server\pentaho-

solutions\system\simple-jndi.

Note: It is important that the information stored in jdbc.properties mirrors the content of your application server

data sources.

Define OCI Connections for the DI Server

Once you have chosen to use the OCI access protocol, here are configuration and maintenance tasks you can perform.

• Add Drivers

• Create OCI Connections

• Add Database-Specific Connections

• Advanced Configuration of Database Connections

• Define Connection Pooling

• Connect to Clusters

• Modify Connections

When you are done, please go on to the next stop on the Guide Post graphic.

Add Drivers

The DI Server and workstations need the appropriate driver to connect to the database that stores your data. Your

database administrator, Chief Intelligence Officer, or IT manager should be able to provide the appropriate driver. If not,

you can download drivers from your database vendor's website. See the Supported Technologies to ensure that your

database and its driver are supported by Pentaho.

Note: If you are using a Microsoft SQL Server (MSSQL), you might need to use an alternative, non-vendor-

supported driver called JTDS. Contact Pentaho support to ensure that you are adding the correct driver.

Installing Drivers

Once you have the correct driver, copy it to these directories.

DI Server: /pentaho/server/data-integration-server/tomcat/webapps/pentaho-di/WEB-INF/lib/

Spoon: data-integration/lib

You must restart Spoon for the driver to take effect.

剩余52页未读，继续阅读

yanerfei1229

粉丝: 0
资源: 6

Pentaho Kettle管理员操作与资源管理详述（2013年版）

Kettle完整操作手册

kettle（学习手册、中文手册、Kettle使用培训文档）

kettle用户手册

Kettle的使用基础手册.docx

基于kettle的数据集成平台用户手册.pdf

kettle资源.zip

ETL安装部署手册.docx

奇安信-帮助手册R9.2.pdf

Kettle 3.0用户手册：任务条目与数据库连接详解

Kettle 3.2中文教程：ETL工具库管理与核心对象详解

最新资源