The DataTerrain Automation

Developed by our world-class engineering team over a ten-year period and experienced by over 250 customers primarily in United States, the DataTerrain Automation is the unique state-of-the-art centerpiece (automation tool) of the DataTerrain report conversion service.

Performs an Apples to Apples Conversion

The DataTerrain Automation (automation tool) extracts report information from a current reporting source, then converts and publishes your reports to the desired target BI reporting system. Once complete, users can use their new reports in the new BI reporting system.

The DataTerrain Automation converts reports from any reporting source (e.g., to name a few WEBI to OBIEE / BI Publisher / OAC (Oracle Analytics Cloud), Crystal reports to OBIEE / OAC , BRIO to OBIEE  or BI Publisher or OAC, Discoverer to OBIEE / OAC , Actuate to OBIEE / OAC , Crystal reports to Jasper, Cognos to OBIEE / OAC , Webi to Cognos) to work in any BI reporting destination system . Since the conversion is largely automated, the majority of all conversions occur at lightning speed of technology, bringing enormous cost and time savings for customers otherwise facing grueling manual conversion efforts.

The DataTerrain Automation performs extraction, conversion, and output generation phases at lightning speed using internal, built-in proprietary intelligence. Depending on the individual reporting source circumstances, the DataTerrain Automation converts 80-100% of any report, and performance fixes on the fly. The DataTerrain Automation generates intelligent log files that precisely define the conversion elements in the reports and metadata files for future analysis. Our customers reap the savings that the DataTerrain Automation harvests because automation consistently beats manual conversion efforts. We have demonstrated this time and again to hundreds of customers world wide.

Once automated conversion is complete, our team applies the DataTerrain Automation’s multilayer testing scripts both to test the layout and dataset results before delivering reports to our customers. Our team of experienced BI reporting experts built and perfected the DataTerrain Automation as they converted BI reports for hundreds of industry leading customers

BI Reports Conversion Process

DataTerrain Conversion Service

Our 5 step process is quite simple and secure

1. Customers identify business reports that they would like to convert to newer technology of their choice.
2. Customer uploads the report files (WITHOUT DATA) to DataTerrain secure server.
3. DataTerrain team uses unique DataTerrain Automation tool which converts the reports to target in minutes.
4. DataTerrain applies performance fixes based on need.
5. DataTerrain team validates the reports for layouts and sample data or real data based on customer’s request and produces fully usable reports in the target technology.

We follow Industry standards change management methods and apply project management tools to manage every project. Our technical project managers will ensure on-time delivery and complete client satisfaction with the results.

Metadata Files Conversion

OBIEE repository or OAC (Oracle Analytics Cloud) (RPD) contains the Metadata of the BI Server and has three layers. Physical Layer represents the actual tables and columns of a database/data source. It has join definitions including primary/foreign keys and complex joins. Business Model Layer – This is where business logic stored and Presentation Layer to organize content for users in a way that is most meaningful. DataTerrain Automation can transport all the three layers flawlessly.

Business Objects Universe file is the Metadata/semantic layer of SAP business objects reporting environment. It allows the user to interact and retrieve the required data without having to know the complexities of their database or the data structure. The universe mainly consists of objects (dimensions and measures), classes and relationship definition (Joins) between classes. The universe file has a graphical representation to define the relationships between the classes, and thus it is easy to understand. The Desktop Intelligence reporting and Web Intelligence reporting tools will use the universe to create new reports, just by drag drop of columns, filters, conditions, etc. from universe file. DataTerrain Automation can transport all the elements of universe file to OBIEE / OAC (Oracle Analytics Cloud) RPD or IBM Cognos.

IBM COGNOS FRAMEWORK – Framework Manager, is a metadata modeling tool for IBM Cognos BI content, which you can use to create a common business model. The Framework Manager model consists of three layers- Database layer, Logical layer, and Presentation layer. The physical, or database, the layer contains a database query subject for every table in the physical data model. The logical layer contains query subjects that draw data from the database query subjects and present it in a more consumable format. The presentation layer is to organize content for users in a way that is most meaningful. DataTerrain Automation system can transport all the content to OBIEE / OAC (Oracle Analytics Cloud) RPD file.

Complexity metrics and Fixed price model

We all agree NOT all the reports are same. Every single report varies in complexity level, for example, the number of formulas, complex layouts, etc.used in the reports demand more extensive testing and validation. DataTerrain has devised a complexity metrics and will provide before project assessment. We primarily have four complexity levels – Simple, Medium, complex and ultra-complex. Typically from our years of experience in conversion automation, we have not seen any project having ultra-complex report more than 1 to 2% in the total size of the project. The majority of reports fall in simple and medium complexity levels in our experience with sporadic exceptions in the real world. Each complexity level has pricing attached to it and we provide substantial volume discounts on our list pricing.

Why reports Conversion?

  • Moving from legacy to new technology
  • Preserving years of efforts spent on reports designs
  • Continuing business critical reports
  • Consolidating into corporate wide single reporting architecture
  • Driven by Total cost of ownership of reporting infrastructure
  • New data warehouse or new business needs

More About DataTerrain BI Conversion Project

DataTerrain’s conversion-as-a-service program is a service that includes the use of our breakthrough DataTerrain Automation tool. The service project consists of the following:

Project Startup

DataTerrain works with you to craft out a roadmap and a conversion plan. We will create a complete inventory of all current reports that you have identified as part of conversion plan. We take advantage of this opportunity to remove obsolete reports and re-architect or standardize reports to make them more usable, improve their performance or introduce functional changes to make existing reports available to a broader audience. Bottom line, we make sure you get the most out of your investment. Also, we address the security aspect of the reporting and metadata.

The DataTerrain team works closely with its clients to ensure smooth startup

  • Assignment of a project manager to our client
  • Orient client to the project – how we work together, communication protocols, change management tools , setting expectations, etc
  • Learn and adapt to specific client needs
  • Initial classification of reports as Small, Medium, or Complex
  • Refined estimates of project cost and timeline from report classification
  • Mutual agreement on project costs and timelines
  • Detailed project plan

Project Management

A DataTerrain project manager works closely with a client project manager to coordinate all aspects of the ongoing project and to ensure client satisfaction. The DataTerrain team executes report conversion using the DataTerrain Automation and provides fully converted, tested and immediately usable reports for clients.


  • We are relied by customers to convert just one report or several hundred reports. We are there for any need in BI reporting conversion requirement.
  • We make sure customers are satisfied with performance of reports.
  • DataTerrain trains customers along the completed reports conversion cycle and making customers independent.

Delivering Automation and Business Intelligence reports at your fingertips!