What You Will Learn
Data is one of an organization's most important assets. If an enterprise can turn its data into timely and trusted information, it can use that information to rapidly uncover new markets, attract and retain customers, reduce operating costs, decrease time to market, and make smarter strategic decisions. In short, the informed use of data can expand a company's ability to navigate markets.
Combining Informatica's world-class data integration platform with Cisco® Tidal Enterprise Scheduler helps organizations gain a competitive advantage in today's global information economy by providing relevant and trustworthy information to support their business decisions.
Combining Cisco and Informatica Products Can Deliver Superior Data Output
The data that supplies a company's business intelligence systems comes from a variety of internal and external sources. The Informatica data integration solution is designed to transform this data into information that is accurate and actionable by applying processes such as extraction, cleaning, transformation, integration, and loading into data repositories. How do users manage each of these of steps, with their multitude of connections, interdependencies, and sources that include dozens of applications and databases? This is the role of Cisco Tidal Enterprise Scheduler. The enterprise scheduler manages the complex flow of enterprise data into the Informatica system and ultimately delivers it to the appropriate business intelligence reporting tools. When used by business leaders, this trusted information promotes enterprise success.
Companies seek to make fuller use of data because doing so can help them thrive. Informatica and Cisco Tidal Enterprise Scheduler help them to achieve that objective.
Maintaining Quality Information
The challenges faced by IT operational staff in maintaining high-quality business intelligence information can be insurmountable without the right tools for the job. Complex data pathways and their associated components can break, dependencies may not be met, and systems may go offline. Without visibility into each of these processes, reports will be incorrect, or late, or both. Cisco Tidal Enterprise Scheduler and Informatica software work together to deliver mission-critical data to the right place at the right time, for all Informatica extract, transform, load (ETL) pathways.
Challenge: Managing Complex ETL Processes in the Enterprise
The information provided by a business intelligence system is only as good as the data that goes into it. Out-of-date and inaccurate data delivers unreliable intelligence. Many problems occur when the ETL process is handled by an assortment of scripting and custom coding that delivers inaccurate data to the Informatica software. Because there is no way to monitor and control end-to-end execution of the process, there is no way to guarantee the accuracy of the data. Cisco Tidal Enterprise Scheduler creates an automated data workflow for Informatica PowerCenter environments as part of a cross-platform, cross-application process orchestration solution.
How Cisco Tidal Enterprise Scheduler Manages Informatica Workflows
Cisco Tidal Enterprise Scheduler integrates with the Informatica PowerCenter server using vendor-approved APIs. Through these interfaces, the enterprise scheduler communicates with Informatica PowerCenter to define, run, and monitor workflows. IT staff can schedule, monitor, and manage Informatica PowerCenter workflows from the Cisco Tidal Enterprise Scheduler console through comprehensive scheduling features that include detailed calendaring, events management, and access to enterprise-wide dependencies.
Each Cisco Tidal Enterprise Scheduler job definition encapsulates workflows loaded from the Informatica PowerCenter repository and permits parameter value overrides. Then, based on defined scheduling criteria, the enterprise scheduler submits a workflow to the Informatica PowerCenter integration service. After a workflow instance has been submitted, Cisco Tidal Enterprise Scheduler monitors all workflow steps and interactions until completion.
Benefits and Features
Combining Informatica data integration with the Cisco end-to-end job scheduling solution, with its built-in integration with business intelligence reporting software, makes it possible to coordinate data collection, ETL, and reporting processes. Enterprises can immediately achieve the following benefits:
• Dramatically raise the reliability and quality of business intelligence reports
• Improve IT's use of time and resources, allowing IT operations teams to deliver better service
• Make strategic business decisions that are based on reliable, timely data
Informatica and Cisco software features work together to do the following:
• Control enterprise workflows by defining, launching, and monitoring any Informatica service request
• Connect Informatica software to other application platforms, databases, and other Informatica instances with unlimited dependencies, providing a unified view of the entire workflow
• Eliminate the need for scripting to integrate Informatica workflows
• Provide Informatica processes with advanced error control and failure notification for granular data accuracy
• Capture FTP files from outside the firewall, including data from internal or external cloud-based services, software as a service (SaaS) vendors, and external partners
• Create standard Informatica data collection and ETL process templates
System Requirements
Although planning is straightforward, system requirements can vary by enterprise, depending on the environment and type of coverage needed. For specific requirements information, contact a product expert. Online information is available through Cisco Knowledge Services. Cisco Tidal Enterprise Scheduler and its adapters can be installed and deployed by users or by Cisco Services.
About Cisco Tidal Enterprise Scheduler
Cisco Tidal Enterprise Scheduler promotes efficiency by centralizing workflow automation and providing a single view of cross-enterprise job scheduling events. This powerful yet easy-to-use solution helps organizations assemble complex batch job and business process schedules that span the enterprise. The enterprise scheduler's capability to closely monitor scheduled jobs, automatically detect problems, and define actions to aid in recovery can greatly enhance business process performance.
With the broad coverage provided by Cisco Tidal Enterprise Scheduler, IT operations teams can effectively schedule processes that encompass a wide range of databases, systems, and applications. They can also easily incorporate and manage new applications as they come online, which helps improve the operation of mission-critical business processes as the enterprise expands and evolves.
Companies in a variety of industries rely on Cisco Tidal Enterprise Scheduler to keep their daily operations running smoothly. Cisco enterprise job scheduling software, combined with Cisco performance management solutions, can deliver greater levels of automation and optimization to the data center than conventional scheduling and performance management solutions.
For More Information
To learn more about Cisco products and services, please visit http://www.cisco.com.