The latest version of HIPPO has just gone on general release and it is packed with new and unique features to manage, optimize and control your Informatica environment. In the run up to Christmas I’m going to choose twelve of my favorite new benefits.
So, for the first day of Christmas, let’s start with something special for the DBA in your life! Version 3 of HIPPO has a unique feature which enables a DBA to trace an individual execution of a SQL statement, in seconds, all the way back from the database to the Session and Workflow that is responsible for it. And why will your DBA rate this their best Christmas gift ever? Well DBAs see Informatica from the database end. It isn’t straightforward to find the Session owners of long-running SQL statements initiated by Informatica processes, or worse still, orphan SQL executions spawned by long-cancelled Sessions. So they have a tough call to make: made all the harder when they cannot identify the responsible Session, Project or Developer. And what about tuning advice? Your DBA wants to be pro-active; they can see how the SQL can be improved but whom should they call? Now they can simply open HIPPO, copy and paste the SQL from their Management console straight into HIPPO’s Search screen and the responsible workflow and session are returned. Armed with this information from HIPPO, a call is made and a decision taken about the SQL process. The result – one happy DBA!
Check back tomorrow for number 2 in the series!
Footnote: it is a tradition in many parts of the world to celebrate the twelve days of Christmas and we have a Christmas carol here in the UK that associates each of the twelve days with a gift. I acknowledge that the twelve days of Christmas occur after Christmas and not before but I hope that you will allow me a little poetic license here!