Adapter for IBM Cognos

Support IBM’s cloud-based business intelligence and analytics solution.
Announcement icon

Gartner® Market Guide: Service Orchestration & Automation Platforms

Read Report

Schedule Cognos Jobs In the Context of Enterprise Workflows

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.

More About This Adapter

Deeper Dive

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
  • 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

Where We Run

The Cloud

Tidal’s enterprise-wide automation platform transcends the inherent limitations associated with standalone point products or native cloud schedulers. We can automate and orchestrate cross-application workloads and enterprise-wide business processes that traverse multiple clouds and hybrid environments – all from a single-pane-of-glass view.


Tidal helps you optimize the value and performance of your legacy infrastructure while opening new opportunities to leverage next-gen applications and workflows. From pure on-prem to hybrid on-prem and cloud engagements – the answer is Tidal.

  • CentOS
  • Linux Kernel 2.6.18 & above
  • Linux PPC
  • Microsoft Windows
  • Microsoft Windows Server
  • Open VMS
  • Oracle Cloud
  • Oracle Enterprise Linux
  • Red Hat Enterprise Server
  • Suse Enterprise
  • Tandem NSK
  • Ubuntu
  • UNIX
  • HPUX (PA-RISC, Itanium)
  • Solaris (Sparc, X86)
  • AIX
  • OS/400 iSeries
  • z/Linux
  • z/OS