Tidal™ Enterprise Adapter for Oracle® E-Business Suite

Download the PDF version of this document

Oracle® E-Business Suite™ allows organizations to implement many processes key to a successful business. Despite the power and flexibility of even the most widely deployed E-Business application, many organizations must make the strategic decision to retain legacy applications and non-Oracle platforms. With Tidal Enterprise Adapter™ for Oracle E-Business Suite, organizations can now consolidate and combine the processing of legacy applications with Oracle applications under one automation solution and one common interface, throughout the enterprise.

Introducing a More Advanced Solution
The Enterprise Adapter for Oracle E-Business Suite expands and extends your E-Business schedules to other platforms, applications and even other instances of Oracle E-Business, giving you a greater ROI on your Oracle investment. With the Enterprise Adapter for Oracle E-Business Suite, Tidal Software provides a deeper integrated and advanced scheduling functionality than the native Oracle scheduler, Concurrent Manager™.

Key Benefits

• Leverages existing technology and expands Oracle E-Business Suite investments to create a comprehensive enterprise scheduler
• Connects Oracle E-Business Suite to other platforms and other applications with unlimited dependencies for Oracle Requests and Report Sets
• Consolidates Oracle E-Business Suite scheduling under one enterprise-wide console scheduler
• Supplements training and operational support to one scheduling environment
• Provides richer, more advanced scheduling functions than the native Oracle E-Business scheduler for greater efficiency and productivity

Key Features

• Delivers real-time status of Oracle jobs with real-time interaction
• Supports multiple Oracle E-Business Suite environments
• Features user defined, filtered, real-time Windows-Explorer style view of past, present and future Oracle jobs
• Supports parameter substitution for E-Business Suite processes
• Provides multiple types of business calendars for scheduling reports
• Offers choices to View, report and alert personnel based on various report job statuses
• Monitors files that are used as event triggers for the initiation of report run requests
• Utilizes queue and priority management for all run requests
• Centralizes security and control for operations and scheduled run requests with Web and Windows interface
• Processes job control such as old/resume/delete for all Oracle E-Business Suite report jobs
• Enhances rerun functionality to overcome common database lockout errors
• Synchronizes monitoring of all Oracle E-Business Suite report run requests
• Enables extensive logging of all output information from Oracle E-Business Suite report runs
• Captures and displays error messages on report runs
• Allows for more informative error messages and logging from the Scheduler functions

How it Works
Installed on the Oracle E-Business Forms Server, the Enterprise Adapter creates Request Sets of E-Business Suite jobs. To help prevent errors, the adapter comes with lists of Requests and Report Sets. The adapter automatically brings up the Oracle form used to request jobs and define parameters, such as "To" and "From" dates for report data or account numbers for an accounting statement. Tidal Enterprise Scheduler™ variables can be used so that once created, the report form does not have to be accessed repeatedly to enter new parameters if, for instance, a report needs to run each week or each month.

Dependencies can be set; priorities and queues can be allocated and any abnormal behavior is reported in the Tidal console for user notification and intervention

By leveraging the Concurrent Manager, Tidal Enterprise Scheduler can support all Oracle process types including Oracle Reports, HOST programs, PL/SQL Stored Procedures, Java Stored Procedures, Java Concurrent Programs and SQL*Plus. Because the familiar Oracle request form is used, reports have the same names and syntax as they do in Oracle E-Business Suite. Users can be up and scheduling Oracle jobs in a matter of minutes. Tidal Enterprise Scheduler and Oracle work as one integrated solution. Non-Oracle users can input Oracle processes and run the Oracle Concurrent Manager using the same Enterprise Scheduler interface used across multiple environments..

Security
Security between the Enterprise Adapter and Oracle E-Business Suite includes:

• Validation of username and password against the Oracle E-Business database user during job definition and submission
• Validation of username and password against the Oracle E-Business Suite database user during job definition and submission
• Confirmation of user responsibility rights before a run request is submitted
• Password encryption when invoking Oracle E-Business Suite forms, exposing only the scrambled password string
• Enhanced security feature that allows add and edit capabilities

Call Tidal Software for more information, to see a demo or to receive a free evaluation of Enterprise Adapter for Oracle E-Business Suite

1-877-55-Tidal
sales@tidalsoftware.com