kettle---用户手册(3:创建一个数据库链接)
2013-05-17 20:48 很大很老实 阅读(479) 评论(0) 编辑 收藏 举报本章包括以下内容:
- 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