kettle---用户手册（3：创建一个数据库链接）

本章包括以下内容：

• Creating a New Database Connection
• Editing a Connection
• Duplicating a Connection
• Copying to a Clipboard
• Deleting a Connection
• Executing SQL Commands on a Connection
• Clearing the Database Cache Option
• Quoting
• Database Usage Grid
• Configuring JNDI Connections
• Unsupported Databases

第一步：创建一个数据库连接，

图形操作界面如下：

 

出来的对话框，包括以下内容：

1)General

Feature	Description
Connection Name	Uniquely identifies a connection across transformations and jobs
Connection Type	Type of database you are connecting to (for example, MySQL, Oracle, and so on)
Method of access	This will be either Native (JDBC), ODBC, or OCI. Available access types depend on the type of database you are connecting to
Server host name	Defines the host name of the server on which the database resides. You can also specify the host by IP-address
Database name	Identifies the database name you want to connect to. In case of ODBC, specify the DSN name here
Port number	Sets the TCP/IP port number
Username	Optionally specifies the user name to connect to the database
Password	Optionally specifies the password to connect to the database

累死，配置连接到sql2008，发现是tcp/ip协议禁用；sql browser没有运行，还是对sql不熟悉啊。

2）Advanced

3）options

4）pooling

是否启用连接池。

5）clustering