We had the opportunity to talk with many PowerCenter users at Informatica World in Las Vegas in May and they shared a lot of information about their IT Automation requirements, at the application and enterprise level, and how it could be improved. Application vendors, as we have previously addressed in our earlier posting, focus their resources (money and time) in developing the core capabilities of their products rather than enhancing their solutions with a robust automation system necessary to address today’s business and operational requirements.
PowerCenter, as presented by Informatica, offers industry leadership in “…converting raw data into information to drive analysis…” which is consistent with the premise that too often the vendors of these critical applications require their users to identify alternative approaches to address the automation tools included by the vendor.
PMCMD Automation: Boundaries Identified
To automate PowerCenter workflows many attendees indicated that they use PMCMD, the command line utility for managing the automation of ETL workflows included with PowerCenter, to perform the basic tasks of manipulating, starting, stopping and scheduling workflows, tasks and sessions. However, the expressed concern was that in order to address today’s changing business and operational requirements, they often supplemented PMCMD with custom script creation to fill the voids. They also clearly understood that scripting ratcheted up the complexity level of their IT environments not to mention the increased costs when using limited but expensive senior development resources to build and then maintain these scripts.
The Downside to Custom Scripts
Custom script generation requires senior level resources to build a script that augments what PMCMD can’t readily provide when more sophisticated capabilities are needed. Once the custom script is written, the time and effort moves to testing and debugging which takes significant time as well as significantly impacting associated costs. Over time, the requirements change and scripts have to be maintained. If the developer has changed positions or left the firm it becomes problematic to identify individuals who want to step in, take responsibility for script modification and ongoing testing. Costs go up and limited “expensive” resources are consumed and focused on maintenance rather than on developing new processes to meet IT and business requirements.
Simplifying “End-to-End” Workflow Creation
At Informatica World, we heard and discussed how the use of an enterprise automation solution using pre-packaged integrations with critical third-party applications, like PowerCenter, could simplify and automate existing and new workflows and expand them into “end to end” workflows that could be used to generate analytics after the data had been integrated.
A sampling of the limitations with PMCMD that users shared and asked about were:
- Complex event scheduling
- Dynamically setting parameters at run time
- Instantiating workflows sourced in and across multiple folders
- Constraints to wait for files being closed before starting workflows
- Building “end to end” workflows that pass data and manage dependencies across non-PowerCenter systems
- And more…
One such discussion was a user who presented the following issue:
Q: “We continuously provide vendors [or Customers] with files using SFTP but the files are not fully populated and our vendors need to sort through the various files that were sent pre-maturely with PowerCenter, what are our options other than scripting?”
A: Knowing that workflows could be held until files were closed, or workflows triggered when files were created made the point that complexity need not be a requirement for PowerCenter workflows.
“Out of the Box” Capabilities
The prebuilt integrations, for solutions like PowerCenter, within enterprise scheduling and automation solutions such as ActiveBatch® allow ETL developers to streamline the passing of data that ensures more accurate and reliable workload execution without having to hardcode complex workflow logic, schedules and dependencies. The automation capabilities of enterprise grade solutions must reduce or eliminate scripting while offering enhanced “out of the box” capabilities, such as:
– File constraints
– Lifecycle management
– Change management
IT Automation Designed for Change
With an increasing rate of change demanding faster implementation cycles, accommodating changing requirements and little or no budget growth today’s IT automation solutions must provide the answer on how to do more with less.
PowerCenter users were enthusiastic and supportive of the need for improving IT Agility to automate new and existing workflows without requiring PMCMD and custom scripting while reducing their costs. If you are a PowerCenter user and are struggling to streamline your ETL and data warehousing processes due to limited capabilities found in application specific tools, we would like to hear from you. Please take a moment to share your comments or requirements for removing complexity from PowerCenter automation below.