Spoon: What ETLs are using this connection?

The week before last I delivered the Pentaho DI1000 training to a group to our North Sydney office and I got asked a question that (it turned out) had an easy answer. And as with a lot of things, I hadn’t read it, somebody had told me.

The question was: When I’m using a shared database connection, what other ETLs are using it too?

While connected to the repository, and with a transformation open, change to the ‘View’ tab in the Explorer panel (on the left)

Bring up the context-menu on the database connection (I’m using the built-in Agile connection here)

Choose ‘Show dependencies’ and the list of ETLS in the repository that are using it appear.