Tidal Workload Automation Adapter for Cognos
IT operations that focus on the automation of business processes involve integrating a wide range of custom and enterprise applications and the infrastructure on which they run, often with complex interdependencies. In such environments, IT typically uses job scheduling tools to control batch and on demand event processing, which are vital to the success of a range of business operations from sales to manufacturing to financial management.
For the past decade, Tidal Workload Automation has been defining standards for job scheduling usability, scalability, and breadth of coverage. The role of Tidal Workload Automation is to make connectivity, control, and visibility of diverse technologies accessible directly through the Tidal Workload Automation user interface. The breadth of coverage these adapters provide simplifies end-to-end scheduling of processes across the enterprise.
Tidal Workload Automation Adapter for Cognos
Tidal Workload Automation for Cognos allows users to schedule relevant Cognos jobs in the context of all other enterprise jobs. It puts stored reports and configuration items automatically into the UI so users can then define Cognos jobs via point-and-click functionality without the need for custom scripting. As a platform-independent solution, the adapter can run on any OS platform where Tidal Workload Automation master runs.
Improving Data Integration and Business Intelligence (BI) through Greater Workload Automation
Cognos Business Intelligence delivers a complete range of BI capabilities: reporting, analysis, dashboard management, and scorecard creation. Cognos users can author, share, and use reports that draw on data across many sources to make better business decisions. But without effective workload automation, data that supports Cognos Business Intelligence reporting may not arrive at the right place at the right time. In addition, poor visibility can make it difficult to see where processing bottlenecks exist. As a result, when process integration between data integration; data warehouse; extract, transform, and load operations (ETL); and BI reporting functionality is less than optimal, business decisions can be negatively impacted.
Tidal Workload Automation Adapter for Cognos enables the definition of workloads that keep data flowing smoothly between source systems and the data warehouse. This powerful solution then coordinates and triggers the running of reports in the correct order and with the correct data to meet business reporting service level agreements (SLAs). With this adapter, users can load, define, launch, and monitor tasks in a Cognos environment, while Tidal Workload Automation manages the moving parts in a BI infrastructure in the right order and delivers them at the right time to the right person. The result is saved time, reduced errors, and the ability to create ad hoc reports in an environment that normally requires considerable planning and a significant level of control over service level management.
Features and Benefits
Using Tidal Workload Automation Adapter for Cognos can dramatically simplify the process of scheduling, tracking, and managing all BI workloads regardless of the number of dependencies, systems, and applications involved. This adapter, in combination with Tidal Workload Automation, offers the following capabilities:
Complex Dependency Management – BI operations staff can create job definitions that manage the most complex Cognos dependency and runtime requirements.
Centralized View and Control – Tidal Workload Automation enables users to develop process streams and manage the information flow from a centralized console, thereby providing greater control over all aspects of a Cognos job environment, including its relationship to all other enterprise jobs.
Cognos Security Enforcement – The adapter enforces Cognos security policies by authenticating with Cognos through associations between Tidal Workload Automation runtime users and Cognos security settings. Creating a Cognos job from Tidal Workload Automation is highly secure and as simple as creating any other Enterprise Scheduler job.
Complete Cognos Job Tracking – A Tidal Workload Automation job definition for Cognos refers to report- and-query data that is retrieved from the Cognos content store. The job definition can be augmented with format, print, save, and e-mail disposition options, as well as parameter value overrides that can refer to enterprise-wide scheduling variables. Once a job has submitted a task to the Cognos environment, the adapter monitors the process until it is completed. It then returns the final completion status, as well as details associated with the job run, to Tidal Workload Automation. This information can then be used to trigger downstream jobs or other dependent workloads.
High Visibility and Fine Control – Tidal Workload Automation Adapter for Cognos enables users to cancel, abort, or rerun tasks from Tidal Workload Automation, a feature that provides better control over the scheduling environment than that afforded by scripting or other non-integrated solutions.
Tidal Workload Automation Adapter for Cognos users can leverage all the workload definition flexibility provided by Tidal Workload Automation. They can use this comprehensive solution to merge BI system and enterprise resource planning (ERP) application processes into a cohesive, centrally managed job stream, which also provides error detection, automated remediation, and alerts management.
As an example, users can define a process flow that confirms the receipt of data from a business partner. On arrival, this data triggers appropriate ERP processes, which upon completion drives the execution of data warehouse loading, downstream reporting, and online analytical processing (OLAP) cube generation.
Because the Cognos request set is defined like any other Tidal Workload Automation job, users can take full advantage of job, file, and variable dependencies; calendars; event and email notifications; and all other Tidal Workload Automation capabilities to manage Cognos scheduling in the context of the enterprise.
- Leverages the Cognos BI web services application program interface (API) for a tighter agentless integration between Tidal Workload Automation and Cognos report and query execution than possible through scripting alone
- Packages all implementation details in the interface that connects Tidal Workload Automation to Cognos
- Provides a content browser that locates reports and queries to schedule and that can be restricted to specific packages and/or folders
- Enables any report or query parameter to be set dynamically using Tidal Workload Automation variables, including calculated dates
- Controls formats, such as hypertext mark-up language/portable document format (HTML/PDF), as well as disposition and destination through extensive output options
- Enforces Cognos user and role security associated with Tidal Workload Automation runtime users
- Provides security through the use of industry-standard lightweight data access protocol (LDAP) and Active Directory integration
- Increases visibility and enables users to understand business process workloads in real time, easily audit them, and document what has occurred, helping to reduce production processing time windows