At a Glance
Industry Wine and beverage production and global distribution (operations, sales, and finance reporting)
Organization An Australian global winemaking and distribution company
Migration SAP Crystal Reports → Oracle BI Publisher
Challenge Crystal Reports end-of-support risk, performance bottlenecks, and report sprawl across 150 business-critical reports
Scope 150 reports converted over 6 months, from automated inventory to production go-live
Approach Automated migration using DataTerrain's proprietary Crystal Reports to Oracle conversion tools, with business-user validation

AN AUSTRALIAN GLOBAL WINEMAKING AND DISTRIBUTION COMPANY

Migrating SAP Crystal Reports to Oracle BI Publisher for an Australian Global Winemaking and Distribution Company

Customer Background

A Global Wine Business Reporting on SAP Crystal Reports

Producing and distributing wine across global markets, the company relies on accurate business intelligence for production, sales, distribution, and financial decisions. Its operations, sales, and finance teams needed timely, reliable reporting.

With SAP Crystal Reports reaching end of support, the company migrated to Oracle BI Publisher to build an efficient, user-friendly reporting environment aligned with its industry needs. A Crystal Reports-to-Oracle BI Publisher migration lets organizations keep familiar report structures while gaining flexibility, scalability, and tighter integration with Oracle solutions. The company selected DataTerrain, an expert in automated BI migration, to convert 150 Crystal Reports within six months using a proven, structured methodology.

Customer Storeis
The Challenge

Moving Multiple Reports Without Disrupting Daily Operations

Several factors drove the decision to migrate:

End-of-support risk:

SAP Crystal Reports was reaching end of support, creating risks around security, stability, and long-term vendor dependence.

Global reporting demands

Teams across production, sales, and distribution needed reliable BI and analytics to make rapid, data-driven decisions.

Performance bottlenecks

Resource-heavy reports slowed execution as data volumes grew across the business.

Report sprawl

many similar reports increased maintenance and support effort, calling for consolidation before the move to Oracle.

Tight timeline

150 business-critical reports had to be converted and validated within six months without disrupting daily operations.

User continuity

Business users expected the same report layouts they relied on in Crystal Reports, with added filtering and analysis features.

Our Approach

A Three-Phase, Automation-Led Migration

DataTerrain delivered the migration in three phases, using its proprietary automation tools as the core migration engine.

1
Automated Inventory and Analysis

DataTerrain's proprietary tool automatically inventoried and analyzed all Crystal Reports, producing a comprehensive report list and a high-level technical overview. It flagged resource-intensive reports for performance optimization and identified similar reports for consolidation to reduce maintenance in the new Oracle environment.

2
Conversion to Oracle BI Publisher

Automated migration tools converted each Crystal Report into an Oracle BI Publisher RTF template that replicated the AS-IS look and feel, then deployed it on the Oracle server for seamless end-user access. DataTerrain also added user filters such as year, region, and department, along with new drill-downs, so users could tailor their data views.

3
Validation and User Acceptance

Business users validated the converted reports and tested new features throughout the project. Close collaboration kept report formats familiar, minimized disruption, and ensured every report met requirements before moving to production.

Technology landscape

From Crystal Reports Files to BI Publisher Templates and Data Models

Migrated From SAP Crystal Reports (.rpt files)
Migrated To Oracle BI Publisher RTF templates
Migrated From Embedded data logic and layout
Migrated To Separate data models and layout templates
Migrated From Static report parameters
Migrated To Dynamic filters and drill-downs (year, region, department)
Migrated From Crystal export options
Migrated To Multiple output formats (.xls, .pdf, .doc)
Migrated From Legacy security structure
Migrated To Embedded, customizable security controls
Business Impact

Outcomes That Mattered to the Business

150 Reports Migrated

All 150 Crystal Reports were converted to Oracle BI Publisher in six months.

AS-IS Look and Feel

Converted reports replicate the layouts business users already knew, minimizing disruption.

Faster Performance

Oracle BI Publisher handles large data volumes, delivering faster report execution for daily operations and decision-making.

Greater Flexibility

Separating data, layout, and logic makes updates easier, and Oracle's layout editor enables real-time customization across output formats.

Secure, Scalable Reporting

Embedded custom security and seamless Oracle integration simplify maintenance and support future growth.

24x7 Global Delivery

A global delivery team supported the project around the clock.

Bottom Line

Why Choose DataTerrain

Through an automated SAP Crystal Reports-to-Oracle BI Publisher migration, DataTerrain moved 150 reports for an Australian global winemaking and distribution company to a faster, more flexible, and secure Oracle reporting platform in six months, with familiar layouts and minimal user disruption. With 17+ years and 400+ clients, DataTerrain uses automated BI migration tools to ensure accuracy, reduce risk, and deliver a smooth transition.

legacy reports conversion connect with us
"DataTerrain moved all 150 of our Crystal Reports to Oracle BI Publisher in six months, and the converted reports kept the layouts our teams already knew. Reports now run faster on large data volumes, and we have added filters and drill-downs, with the flexibility and security we need as we grow." Head of Business Intelligence
Australian Global Winemaking and Distribution Company