SAP BusinessObjectives Adapter

Pre-built DW / ETL / BI SAP BusinessObjectives 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

Tidal Workload Automation Adapter for SAP BusinessObjects is an interface between Workload Automation and the SAP BusinessObjects business intelligence (BI) platform where users can define, launch, and monitor SAP BusinessObjects tasks and job steps within a workload automation environment. The combination of Tidal Workload Automation and the adapter for SAP BusinessObjects offers superior functionality and process granularity over native SAP scheduling tools.

By incorporating Tidal Workload Automation Adapter for SAP BusinessObjects into enterprise-wide job scheduling environments, organizations can add complex scheduling functions to their BI solutions,   while consolidating their environment via a single pane of glass. The adapter offers complete graphical user interface (GUI) job definition capabilities, the ability to set complex, system-wide dependencies, and custom calendar creation without the need to use multiple tools or cumbersome scripting methods which must be managed throughout their entire lifecycle.

Tidal Workload Automation provides virtually unlimited flexibility in developing and defining SAP BusinessObjects processing steps, giving IT staff the ability to create complex job streams that utilize the adapter to merge any BI, extract, transform, and load (ETL), and data warehouse processes.

The Challenges of Scheduling Data Flows for SAP BusinessObjects BI Environments

SAP BusinessObjects BI is a powerful software suite designed to allow business managers to access, format, analyze, navigate, and share all types of information. SAP BusinessObjects solutions enable data discovery, delivery, and management, as well as query, reporting, and sophisticated numeric and text data analysis capabilities.

Without effective process automation, running the tasks needed to support BI operations may not occur correctly or in the correct order. With many moving parts, such as job steps and data transformation tasks, workflows can break down, and poor environmental monitoring can leave operations staff in the dark about what part of a process failed and why. As a result, when process interactions between ETL,  services and BI reporting functionality are less than optimal, business operations and strategic decision- making can be negatively impacted.

How the Adapter Works

Tidal Workload Automation Adapter for SAP BusinessObjects is powered by an agentless application program interface (API)-level integration developed using the native SAP BusinessObjects software developer’s kit (SDK) to embed SAP BusinessObjects functionality into Workload Automation. It allows users to connect to SAP BusinessObjects servers and define jobs using standard Workload Automation dialog screens. Because SAP BusinessObjects jobs are defined like any other Workload Automation job, users can leverage job, file, and variable dependencies, calendars, events, monitoring, and error notifications. In addition, they can benefit from detailed runtime error detection, alerts, and automated remediation.

Users can create and schedule jobs in Tidal Workload Automation to perform tasks in a variety of SAP BusinessObjects applications, including Crystal Reports, SAP BusinessObjects Web Intelligence, Desktop Intelligence, Data Services, Data Integrator, and XBRL Publishing. The adapter also queries SAP BusinessObjects InfoStore to access folders and objects, which then can be brought into the automated scheduling environment with full variable and parameter support. Based on defined scheduling criteria, the adapter submits a SAP BusinessObjects task to run through the native job scheduling service.

The adapter enforces SAP BusinessObjects security rules by authenticating user access through associations between Workload Automation runtime users and SAP BusinessObjects users. Creating a SAP BusinessObjects job in Workload Automation is highly secure and is as simple as creating any other job.

Once a job has been submitted, Tidal Workload Automation Adapter for SAP BusinessObjects monitors the workflow through to completion. It returns the final completion status—which then can be used to

control downstream jobs and details associated with the workflow—to the central console. In addition, it allows users to cancel, hold/resume, abort, and rerun tasks from Tidal Workload Automation. This feature provides significantly more control over the environment than offered by scripting or other nonintegrated scheduling solutions.

Features and Benefits

The adapter extends Workload Automation to incorporate the SAP BusinessObjects information and access that staff requires to schedule jobs through the Workload Automation interface. It simplifies scheduling and respects the integrity and security of the SAP BusinessObjects environment.

Tidal Workload Automation Adapter for SAP BusinessObjects, with Workload Automation, delivers standardized, centralized, and scriptless scheduling for both simple and complex processes, as well as thorough tracking and alerting. These capabilities increase efficiency, reduce errors, and support enterprise objectives, enabling IT staff to focus on innovation and strategic initiatives. Specific capabilities include:

Robust Event Monitoring and Alert Notifications – Tidal Workload Automation Adapter for SAP BusinessObjects is eventbased. It launches processes based on defined calendars, schedules, or event triggers and provides thorough monitoring, enabling users to see status changes in real time and to control those processes as they execute.

The adapter notifies users via email or other alerting mechanisms when new content from reports or SAP BusinessObjects Web Intelligence is available. When a job is complete, output can be attached or, for greater security, can be referenced through a hyperlink, requiring that users present credentials before being able to access information. Trace logs give IT staff the ability to determine where an execution failed, whether execution steps occurred in the expected order, and which parts of the execution took the most time to run.

Seamless Support for Ad Hoc and Scheduled Jobs – Business managers frequently make ad hoc BI requests that must be run immediately. Gradually, these jobs are reused and fall into predictable patterns. For efficiency, they should be organized into calendars or schedules. With Tidal Workload Automation and the Adapter for SAP BusinessObjects, these ad hoc jobs can be easily transitioned into standard production runs, eliminating manual intervention in the scheduling process. In addition, because this solution offers a single point of control for all enterprise-wide job scheduled and processes, it simplifies adherence to prescribed policies and allows IT operations staff to seamlessly incorporate SAP BusinessObjects workflows into established schedule updates.

Enterprise-wide Coverage – Tidal Workload Automation and the Adapter for SAP BusinessObjects support cross- application, cross-platform job dependencies, enabling integration of a wide variety of SAP jobs into other data flows.

Single Web-portal Interface – The solution offers a single point of control for company-wide job scheduling through its portable, browser-based interface. It delivers robust and scalable scheduling functionality, including integrated job definitions and seamless handling of events, dependencies, resources, calendars, and output. It also provides exception-based control and role-based security. In addition, its intuitive graphical interface requires no scripting. Ultimately, this solution can accelerate ROI by increasing efficiency, as well as reducing errors and issues, through better automation and process visibility.

Tidal/SAP Partner Integration

Workload Automation is part of the SAP BusinessObjects Partner program, the only job scheduling solution to have earned this close relationship with SAP BusinessObjects.