IBM Cognos Adapter

Pre-built DW / ETL / BI IBM Cognos Adapter from Tidal

Quest Webinar

Sept. 12th Webinar – Getting More From Your Oracle ERP

Whether you’re running JDE, PeopleSoft, EBS, or other Oracle applications, your ERP connects with critical applications and systems. Join this Quest-sponsored webinar and learn from experts how they use Tidal Automation™ to get the most from their ERP in multi-system environments.

Register Now

Adapter Overview

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.

Usage Scenario

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.

Features Summary