SleepSavers is a set of Python wrapper scripts designed to intelligently start and—if failure is detected—restart Informatica workflows to avoid nuisance production support and night time wake up calls for simple connectivity issues.
SleepSavers is a set of Python wrapper scripts designed to intelligently start and-if failure is detected-restart Informatica workflows to avoid nuisance production support and night time wake up calls for simple connectivity issues.
A simple, understandable set of Python scripts to encapsulate the run time variables of the Informatica workflow command line. The scripts dynamically build the command line to execute Informatica workflows.
The simple script will exit after successful or multiple attempts to restart a "restartable" Informatica workflow if it fails. As a result, it provides a degree of high availability to overcome connectivity issues.
The advanced script performs similar functionality, but adds a degree of intelligence by interrogating the Informatica repository in order to determine the nature of any possible error condition and restart based on pre-defined business rules.
You can download this block as part of the PowerCenter : Useful Script files bundle.
Click image for a larger view
Execute Informatica dynamically by supplying folder and workflow. Encapsulate business logic in Python script.
Informatica dynamically creates and executes the command line.
The screen below simulates the automatic restart of an Informatica workflow. In this case, workflow was intentionally aborted and the Python script automatically restarted the workflow. Eliminate the need for the night time support staff to discover nuisance “connection broken” restarts.
|System Requirements:||Informatica Product Requirements:|