| 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