Our customer a world-class technology services organization that leverages its extensive experience and industry insights to help it’s clients attain their digital goals. With a unique deployment model that emphasizes high-quality local engagements, this client’s network spanned 70 client delivery centers across the US, Canada, and Mexico. The business emphasizes speed, agility, and flexibility with dynamic fit-for-purpose teams brought together with customized, industry-specialized service models to deliver proven solutions to achieve results. BI(Business intelligence) and analytics were key to making rapid decisions to shape new deals and manage the execution of projects. Since Crystal Reports was going out of support, our customer needed to quickly migrate to a new platform and chose Oracle BI Publisher.
The customer wanted no impact on the users during this change and retaining the AS-IS look and feel from Crystal Reports was a critical requirement. The customer chose DataTerrain to complete this migration due to its robust and successful automated approach for migration from Crystal Reports to Oracle BI Publisher. As one of the early movers in building a seamless migration path out of Crystal Reports, DataTerrain’s experience had been refined over numerous challenging projects. DataTerrain’s proprietary tool had demonstrated its ability to accelerate conversion and migration through automation.

Accelerated migration using DataTerrain’s automation tool
DataTerrain’s structured approach for migration from Crystal Reports to Oracle BI Publisher was followed for completing this migration on time and within budget. The major phases of the migration include-
1. Automated analysis and detailed planning–DataTerrain’s tool created an inventory of reports and performed a high-level technical and functional analysis to identify nuances to be addressed, flag potential migration issues, performance bottlenecks, and plan manual interventions. It identified redundancies and potential consolidation options. This information was fed into a detailed project plan which was further refined after a few pilot reports were converted and validated as proof of concept.
2. Automated conversion and validation–The migration tool converted each Crystal Report to a corresponding RTF template and deployed to the PeopleSoft server to be made available as Oracle BI Publisher process types accessible using the application engine in the PeopleSoft environment. Where applicable, people code designed for Crystal Reports was converted and made suitable for the new Oracle BI Publisher environment and the application engine. The time saved through automation was used to customize queries and report features for priority items requested by users. Additional drill-downs and prompts were provided for users to filter based on parameters like input year, region, and department to generate the desired report views. Performance issues were also resolved saving execution time and resources.
3. User validation and rollout – User involvement from the initial planning stage was ensured by both the customer project manager and DataTerrain. This enabled the project team to fast track decisions and act on risks and issues proactively. Users validated the reports in the target testing environment as the RTF templates were deployed. The process scheduler in Oracle BI Publisher was also run during the validation and business user acceptance testing which were followed by sign-off and rollout to production.
The customer team called out two noticeable aspects of this migration project as visible differentiators provided by DataTerrain –
• Accelerated project execution using a global delivery model ensuring that the migration completed before Crystal Reports went out of support. DataTerrain SMEs across the global delivery centers ensured that someone was available round the clock to push forward with project activities
• Value adds while retaining Look and Feel – Additional features like filters and long-pending customizationsled to high user satisfaction and positive feedback.

Customer benefits
Some of the major benefits to the customer following the successful On-Time and within budget migration to Oracle BI Publisher include –
1. Seamless integration with PeopleSoft and reduction in effort to maintain and enhance the new system which retains the original look and feel while working on the latest software version
2. Increased flexibility and reuse due to the separation of data layout, logic, and translation. This simplifies the effort for maintenance and lights-on support
3. With multiple layouts possible for the same dataset, the proliferation of reports is slowed down, keeping the overall application lighter and simpler.
4. The ability of Oracle BI Publisher to handle extensive data improved performance and is proving to be a major productivity gain for the user community.
5. The versatile layout editor has made it possible to deliver outputs in a variety of formats like .doc, .xls, and .pdf. The layout editor provides drag and drop features for users to easily customize and create their own report formats.
6. Integration of data from multiple sources like web services, HTTP XML feeds, and file data sources adds additional options for users to track and report critical business metrics
7. Users can now deliver personalized content to multiple destinations in multiple output formats using scheduling and bursting feature in Oracle BI Publisher
8. Developers of bespoke applications in the client environment are now able to hot-plug these reports using web services or JavaAPIs
Following this migration, the customer has continued to expand its usage of Oracle BI Publisher as a strategic tool to improve its decision making and to meet its growing reporting requirements.