Tidal™ Enterprise Adapter for Crystal Enterprise

Download the PDF version of this document

The Crystal Enterprise™ solution has allowed you the implementation of analytical reports that have increased your business acumen and intelligence. Now, you can harness both the sequence and timing of those Crystal reports to larger workflows and events throughout your enterprise with Tidal Solution Connector™ for Crystal Enterprise. Custom made by Tidal Consulting Services for an organization's unique needs, Tidal Solution Connector for Crystal Enterprise is the interface between Tidal Enterprise Scheduler™ and Crystal Enterprise. Together, they provide organizations with robust scheduling functionality including cross-platform, cross-application dependency support, real-time interaction and centralized control.

Get More Bang For Your Buck
Tidal Software's Solution Connector for Crystal Enterprise expands and extends your Crystal schedules to other platforms, other applications and other events for greater ROI from your Crystal implementation. Tidal Software brings the automation, manageability and reliability of the leading enterprise application automation solution to this leading web-based business intelligence application. With the addition of Tidal Enterprise Scheduler to your Crystal Enterprise environment, you can now easily manage your report schedules and maintain a centralized level of control over your reporting needs.

Key Benefits

• Leverages existing technology and expands Crystal Enterprise investments to create a complete enterprise solution
• Connects Crystal Enterprise to other platforms, other business applications and other Crystal Enterprise instances with unlimited dependencies for broader integrated work flows
• Consolidates Crystal Enterprise application automation under one corporate-wide console with one staff and one set of internal procedures
• Reduces training and operational support to one application automation environment
• Provides richer, more advanced scheduling features than the native Crystal Enterprise job scheduler for greater efficiency and productivity

Key Features

• Cross-application and cross-platformdependency support, allowing external dependencies to and from Crystal Reports for more productive workflows
• Unlimited file dependencies allowed for report runs
• Real-time status of Crystal jobs with real-time interaction
• Support for multiple Crystal Enterprise environments
• Multiple types of business calendars for scheduling reports
• Ability to view reports and alert personnel based on various report job statuses
• Capacity to monitor files that are used as event triggers for the initiation of report run requests
• Queue and priority management for all report run requests
• Centralized security and control for operations and scheduled report run requests from a Web or Windows interface
• Job control such as hold/resume/delete for all Crystal Enterprise report jobs, managed from the Tidal Enterprise Scheduler console
• Enhanced rerun functionality to overcome common database lockout errors
• Synchronous monitoring of all Crystal Enterprise report run requests
• Advanced feature enabling Crystal Enterprise to report data source user names and password updates on the fly. New user names and passwords can be changed as part of report job submission from the Tidal Enterprise Scheduler. This feature complements typical company security policies where data source passwords must be changed periodically.
• Extensive logging of all output information from Crystal Enterprise report runs
• Capture and display of error messages on report runs. More informative error messages and logging from the Scheduler functions
• The ability to train, administer and use just one scheduling solution

Security between the Solution Connector and Crystal Enterprise includes:

• Validation of user name and password against the APS server prior to job submission
• Validation of publish and "schedule" rights before a report run request is executed
• Password encryption, exposing only the scrambled password string
• Enhanced security feature that allows the enforcing of a report run request by only the Crystal Enterprise report owner

How It Works
The Tidal Solution Connector for Crystal Enterprise provides true API level integration to Crystal report sequences. All the integration points are JAVA based to provide platform independence of the Solution Connector; this allows support for all Crystal Enterprise environments. The Tidal Solution Connector can be installed on any machine where a Tidal Enterprise Agent resides. This machine must be able to ping the Crystal Enterprise server.

The Tidal Solution Connector for Crystal Enterprise defines, launches and monitors Crystal Enterprise report job requests on a Crystal Enterprise server. The security policies, report and environment information defined in Crystal Enterprise is used to identify the specifics about each report run request initiated from Tidal Enterprise Scheduler. Upon submission of each report run request, Tidal Enterprise Scheduler monitors the execution of each request and maintains connectivity to Crystal Enterprise to continuously update users.

Unlike the native scheduler within Crystal which reports only ended status, the solution connector enables Crystal Enterprise users to manage report run requests from the Tidal Enterprise Scheduler in real-time so that interaction can occur if a problem arises.

Because it is not unusual for Crystal report to pull voluminous data and run for hours, this interactive, real-time capability is a powerful benefit. With the solution connector, Crystal jobs that are running abnormally long or halted can be corrected before productive hours are lost.

Call Tidal Software for more information or to see a demo.

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