Modify connections from PDI

Access other database-related connection tasks in PDI by right-clicking on the connection name in the View tab of the Explorer pane, as shown below:

Other database-related tasks

The following table describes these tasks:

Task	Description
Duplicate	Duplicate the database connection. The duplicate will not be created unless you specify a different Connection Name in the Database Connection dialog box when it appears.
Copy to clipboard	Copy the XML defining the step to the clipboard.
SQL Editor	Execute SQL commands against an existing connection within the SQL Editor. See the Pentaho Data Integration document for details on the SQL Editor.
Clear DB Cache	Clear out the database cache used by PDI to speed up connections. This command is commonly used when databases tables have been changed, created, or deleted (when the information in the cache no longer represents the layout of the database).
Share	Share the connection information among transformations and jobs.
Explore	Use the Database Explorer to explore the schemas and tables of your connected database. See the Pentaho Data Integration document for details on the Database Explorer.
Show dependences	Show all of the transformations and jobs that use this database connection.