Introducing the Tidal Automation Adapter for BusinessObjects Data Services

The adapter is an SAP solution that uses BusinessObjects Data Services Web Services to provide a seamless integration to Business Objects Data Services in the standard TA screens. This allows Schedulers to connect to BusinessObjects servers and define BusinessObjects Data Services batch jobs as part of TA job definitions.

As a platform independent solution, the adapter can run on any platform where the TA Master runs. The adapter enforces BusinessObjects DS security by authenticating through associations between TA runtime users and BusinessObjects DS users.

Creating a BODS job from TA is highly secure, but as simple as creating any other job. A job definition refers to a Data Services (formally Data Integrator) batch job which has been published as a Web service. Based on defined scheduling criteria, the adapter submits a Data Services job to BusinessObjects Data Services for execution. Once a job has been submitted, the adapter monitors it through completion. The Adapter returns the final completion status (used to control downstream jobs) as well as details associated with the run to the console. Additionally, the Adapter allows you to cancel, hold/resume, abort, and rerun tasks from TA, a feature that provides significantly more control over the environment than afforded by scripting or other non-integrated scheduling solutions.

The BODS Adapter is event-based. It launches processes based on defined calendars and schedules, and uses asynchronous callbacks for monitoring, enabling you to see status changes in real time and to control those processes as they execute. This capability reduces production processing time windows, because the Adapter does not need to wait for a polling interval to pass before reacting to the completion of a BODS task.

The terms BusinessObjects Data Services, BusinessObjects DS, and BODS will be used interchangeably for the remainder of this document.

Multiple BusinessObjects adapters are listed below:

SAP Product

TA Adapters...

 

BusinessObjects (BO)

BusinessObjects BI Platform (BOBIP)

BusinessObjects Data Services (BODS)*

BusinessObjects XI

Yes

Yes

No

BusinessObjects XI 4

No

Yes

No

BusinessObjects Data Services

Yes

No

Yes

* - Documented in this guide. See the BusinessObjects Adapter Guide or BusinessObjects BI Platform Adapter Guide for documentation on those adapters.

Prerequisites

You need to configure your firewall to grant the adapter access to ports 6400 to 6405, 8080, 1948, and 4205. If you override any of these default ports, verify that ports required to communicate with BusinessObjects Data Services are open.

If the associated Web Services host is configured to use SSL for external communication (HTTPS), you must complete the steps as described in detail in Configuring the HTTPS Protocol.

  • Obtain security certificates for all target servers.

  • Export security certificates for all target servers to a local directory.

  • Import security certificates for all target servers into a Java keystore.

Verify that:

  • Web Services are configured.

  • Job Server is configured for each repository containing jobs you want to schedule the adapter is configured to use a connection or runtime user that has Administrative privileges jobs are Web Service enabled.

Refer the TA Compatibility Matrix for a complete list of hardware and software requirements.