Spoon: What ETLs are using this connection?

by Andrew Cave
August 26, 2017
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.

More blog posts

Information Security and the BizCubed Ways and Values

We’ve blogged previously about the BizCubed Ways and Values.  Many companies have versions of this – they may call them values, guiding principles or another phrase.  While many in large organisations struggle to see them as more than “corporate buzzwords”, we rely on them heavily and incorporate them daily.

read more

BizCubed’s Journey to ISO27001 Certification

A year ago, we blogged about Data Security as a Practice. Since then, we have continued the practices we talked about there, integrating it even further into our daily practice, and incorporating new processes and aspects into our existing cadence.

read more