Skip navigation
Contact Us

Additional Information

SleepSavers : Smart Workflow Restart Tool

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.

Attributes:
Price: Free
Action:


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.


  • Migration between environments is simplified. The command line remains constant. Environmental differences are embodied in the Python wrapper.
  • The script is flexible and can be modified for additional functionality.
  • Email notifications containing the exact error messages can be implemented, enabling support staff to diagnose and remedy any issues that arise and determine the best course of action.


Screenshots:


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.





SleepersSimple
SleepersAdvanced
Current Version: 1.0
Release Date: January 1, 2009
System Requirements: Informatica Product Requirements:
  • Microsoft Windows 2000/XP/Vista/7
  • Python Version 2.4 and above, pyodbc module
  • PowerCenter 8.1 and later


Support Options:
Email: support@software-by-design.com
Web Support: http://www.software-by-design.com/support.html

Please email us with any questions or to find out how we can help your organization create supportable and extensible Python scripts designed to make daily IT tasks easier and more efficient.

Why do we give these scripts away for free?

To get our foot in the door to your organization. Hopefully the simplicity of the design will intrigue you to investigate some of our other solutions or challenge us with your specific requirements.

We look forward to the opportunity to collaborate with your organization to create other elegant, supportable, extensible Python scripts to efficiently produce rapid solutions for your daily IT tasks.

Email us with your design problems and allow us the opportunity to resolve them for you.
Comments (0)