We are a leading service provider of Business Intelligence Analytics , reports and dashboard development and cloud support

Peoplesoft crystal reports, dashboards, reports

Reports & Dashboards

Support Services



Reports and Dashboard Development Service

New reports and Dashboard development

We are a leading Service Provider of Business Intelligence (BI) analytical reports and dashboard development and support. We have over 10 years of experience in Planning, Design, Development, Tuning and Support of variety of Business Intelligence tools and reporting solutions. We have in-depth real world expertise in industry leading reporting tools such as OBIEE / OAC (Oracle Analytics Cloud), Cognos, Jasper, QuickSight (Amazon) and Tableau among others.

Project Scope Call
Reports & Dashboard requirement Doc For Approval
Reports Development
Functionality Testing
Data Testing
Client Review
Client Site Deployment
Training, Documentation and Support for 6 months.
Divider Divider

DataTerrain delivers Jaspersoft reporting excellence

Business Intelligence analytics and reporting solutions have become key to business success.  The usage ranges from Sales teams to Finance to HR on daily basis in every step of the business functioning. There is a paradigm shift from just generating automated monthly , yearly reports to driving automation with decision support and transactional analytics in enterprise. TIBCO Jaspersoft has been a leader in business analytics and reporting with its ease of integration with enterprise applications enabled by its suite of  flexible, highly interactive analytics dashboards capabilities.

As a successful service provider and TIBCO partner, DataTerrain has been working with leading corporations to deliver Jaspersoft-based reporting solutions aligned with their business goals. DataTerrain subject matter experts enable corporations to understand trends and gaps to reduce risks with novel, practical, powerful analytics that maximize business outcomes.

Experts from DataTerrainenable organizations to chart their Jaspersoft journey by aligning business goals with a real world proven deployment approach. DataTerrainengineers conduct workshops with business and technical leaders to understand their detailed objectives to develop an architectureand implementation roadmap using Jaspersoft best practices.DataTerrain consultants help organizations prioritize requirements between various teams and provide a roadmap for the must-haves and nice to haves based on ROI(Return on Investment). Some of the major points delivered by DataTerrain’s consultants include –

  • Seamlessly embedding and integrating Jaspersoft reports with custom applications while processing data from multiple sources
  • Custom visualization made pluggable with enhanced data virtualization
  • Enabling the power of multi-dimensional analytics and in-memory analytics
  • Making user friendly Jaspersoft features like drag and drop visual report designer to enable self-service

DataTerrain approach ensures that accumulated organizational knowledge is seamlessly carried forward while allowing users to benefit from the latest features and capabilities offered by Jaspersoft. DataTerrain teams have extensive experience in embedding and integrating Jaspersoft with a variety of bespoke, and cloud-based applications across industries.For transition projects, DataTerrain has a large internal team of experts across the spectrum such as Oracle, SAP, IBM, and more. DataTerrainJaspersoft development team ensures the availability of end-to-end expertise for transitions, reducing delays and issues during the transition. DataTerrain is guided by Zero-defect principles during every step and its methodology has proven to be scalable, handling some of the largest and most complex transitions for global organizations.

Customers can engage in short term or long terms development business analytics needs or support needs. DataTerrain team with many years of customer service experience can delivers reliable support on demand by customers.

The DataTerrain Difference

  • DataTerrainhas established strong referranceble track record for successful value delivery in large, multi-year Jaspersoft implementation engagements.
  • Strong partnership with TIBCO ensuring timely and effective product support and early insights on upcoming features and releases
  • Research-driven proprietary solution accelerators and automation tool to enhance quality and accelerate delivery
  • Highly experienced and trained team with thousands of hours of collective experience providing and delivering on futuristic roadmaps to maximize return on investment
  • A global delivery model with associates from global centersdelivers 24 X 7 project execution and support.

Delivering new OBIEE / OAC (Oracle Analytics Cloud) reports and Dashboards

  • DataTerrain will work closely with business users to understand reporting requirements and follow review / approve processes to derive requirements of new reports and Dashboards.
  • We bring in years of OBIEE / OAC development experience and best practices to build new reports and dashboard to specifications.
  • We provide free support for every single report for a period of one year. We deliver for today and tomorrow.
  • Our onshore/offshore development model enables swift, reliable and cost effective delivery of new reports and dashboards.
  • DataTerrain will perform consistent and reliable quality testing and managing the controlled transition from development to UAT to Production.
  • We recommend and help customers in necessary upgrade or patch requirements for best performance of new reports and dashboard along with extensive documentation.

Delivering Transition automation for PeopleSoft Crystal reports to OBIEE / OAC Reports

PeopleSoft Crystal Reports is nearing end of life and is no longer supported with People tools 8.5.5 and future releases. DataTerrain helps you convert the Crystal reports to BI Publisher which integrates existing PeopleSoft data reporting tools such as PS/Query with familiar tools such as Microsoft Word, and Excel.

BI Publisher provides the following advantages:

  • Allows PeopleSoft users to create customer-ready HTML and PDF documents, such as financial statements, contracts, invoices, and purchase orders utilizing multiple formatting and design options
  • Supports E-Text template which is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI)
  • Merges your design template files with the report data to create a variety of outputs(HTML/Excel/PDF/CSV/XML/MS-Word) to meet a variety of business needs in many languages.

DataTerrain uses an automation engine to convert Crystal report to a BI Publisher which helps in drastically reducing the timeline of transition. Customer needs to provide the .rpt files along with the access to PeopleSoft environment. The PSQuery is modified along with the RTF template and the files are converted to BI Publisher, which can be deployed in PeopleSoft platform.

Delivering OBIEE / OAC Reports from Discoverer reports

Oracle Discoverer was a popular reporting tool for Oracle EBS. However it is no longer a supported product and as a result Oracle will provide no further product enhancements or fix for any software problems. Oracle recommends customers to move to the latest and greatest in BI Technology OBIEE / OAC . OBIEE / OAC also supports the integration with Oracle EBS to use the security and SSO set up in the Oracle EBS.

OBIEE / OAC offers the following advantages:

  • Easy to use, with a lot of visualizations and user friendly GUI.
  • Not Oracle database dependent for meta data and reports, and supports the connectivity to a wide range of data source.
  • Supports better report designing in the form of graphs, charts and forms.
  • Scheduler handles the report delivery in a better way and give appropriate alerts
  • Oracle BI Server handles the query more efficiently and thus the performance is better with OBIEE / OAC

To preserve years of design efforts and make the transition faster DataTerrain built an unique automation tool. As the first step Metadata Transition tool builds and validates Oracle Business Intelligence repository (RPD) from EUL. The Discoverer workbooks extract will then be processed by the transition tool to build the OBIEE / OAC Answers reports. The RPD and reports can be deployed seamlessly in the OBIEE  / OAC environment.

Delivering IBM Cognos 10 reports

  • A programmatic approach to designing and developing highly interactive dashboards that provide advanced functionality including dynamic filtering, score-carding, language translation and Google maps integration.
  • An agile and iterative methodology for end to end delivery of IBM Cognos BI systems.
  • Transition of legacy BI systems to IBM Cognos using Cognos’ Transition Roadmap.
  • Onsite/offshore delivery model provides high ROI.
  • Developing and Integrating Reports with 3rd party Portals and Google Maps.
  • Designing, Developing & Tuning Regular and Time Partitioned Cubes using Transformer and Framework Manager.
  • Cognos Performance Tuning including Report Query Tuning, Cache Usage and Model Tuning.
  • Experience with Cognos Report Transitoin and Upgrades/ Transitions from version 7 to version 8.

SNOWFLAKE and POWER BI Cloud Solutions

Building and maintaining an end to end analytics application is complex, challenging, and expensive at the best of times, not to mention littered with risks and unforeseen issues. With our new cloud data warehouse and analytics solutions, we take care of it for you, so you can focus on leveraging data assets to grow your business.

Please Call for a free session with us now to get started. You’ll be glad you did.

Snowflake Cloud Data Warehouse & Data Pipeline Solutions

Leveraging the world’s best cloud data warehouse technology and taking into account your customization and personalization requirements, our certified data engineers deliver an enterprise-class, cloud-ready, end to end data solution for your reporting, analytics, and data science needs.

PowerBI/Sisense Reporting & Analytics Solutions

Our world-class analytics engineers deliver high-end, professional reports, analytics, and dashboards solutions based on your critical requirements. We focus on a personalized approach that is tailored to your needs, so that your data assets deliver long term value.

Business Requirements & Project Planning Workshops

Our business-conscious consultants work directly with your stakeholders to assess your business needs and analytics requirements. Based on these productive sessions, we document a comprehensive path to achieve positive business outcomes and collaborate closely with your team to put the plan into motion, in a reasonable timeframe that balances time and costs.

Ongoing Maintenance & Support

Based on a streamlined and agile engagement model, we provide ongoing, as-needed support for your business intelligence applications. You can expect timely and effective services for all your ongoing needs.



BI Implementation and Maintenance Services

DataTerrain’s BI expert team has an extensive experience in implementing BI services which demands in depth technology knowledge with proven practices and transformation methodology that enables to deliver a wide range of BI implementation services.

With DataTerrain BI Implementation Services, organizations of all diverse domains achieve access to quick-to-deploy, cost-effective Business Intelligence offerings that can be customized to meet particular business goals. DataTerrain’s Business Intelligence Implementation Services spans a complete spectrum of BI ranging from data management, data warehousing, reporting and analytics. This helps us to make sure the organizations reap the maximum amount of value from their Business Intelligence investments.

BI Implementation Services includes:

  • BI Platforms and Package Implementation
  • Enterprise Data Warehouse design, build and maintain
  • Merging Data from different sources and ERP Application
  • Reporting and Analytics
  • Data Profiling and Cleansing
  • BI Dashboard Services
  • OBIEE / OAC (Oracle Analytics Cloud) Upgrade, Transition
  • BI Performance Tuning

Oracle BI Applications Services

  • Implementation of Pre-Packaged Analytics on Oracle E-Business Suite 11.5.9, 11.5.10, R12
  • ETL extensions and customizations using Informatica / ODI
  • Oracle BI Applications upgrade
  • Upgrade assessment and designing roadmap
  • Minimal down-time and high performance
  • Implementation and user training

HCM and Taleo cloud support

  • Oracle BI Applications upgrade from 7.9.x to Oracle BI Applications
  • Upgrade assessment and designing roadmap
  • End to end delivery of OBIA upgrade
  • Minimal down-time and high performance
  • Implementation and user training


DataTerrain Analytics design, development and maintenance

Our Business Intelligence services help organizations to predict, track and analyze valuable information from a huge amount of diverse data, which helps them to create short-term, medium-term, and long-term priorities and business objectives.

Customer Analytic Scope Call
Metadata Layer Development
Metadata Objects Mapping
Analytics Optimization
Analytics Testing
Analytics Deployments
Customer Training, Documentation and Support for 1 Year
Divider Divider

DataTerrain has a robust automation software engine that converts the metadata files across multiple BI platforms. We support the transition of metadata source files like SAP BO Universe, Discoverer EUL, Cognos FM, OBIEE RPD and Hyperion BRIO.

Once we receive the metadata files in the relevant format (like *.biar, *.univ, *.eex, *.bqy, *.cpf or *.rpd formats), the metadata would be converted to the respective destination formats, preserving the all joins and table structures. The converted metadata would be similar to the source metadata in functionality and support adhoc reports too.


Taleo reports builder beginner course enables you to develop native Reporting with BIP for Taleo Enterprise. It gives you hands-on experience in creating, modifying, and sharing both standard and custom reports. It allows you to turn on the capabilities of BI Publisher and Taleo Performance. Taleo Advanced reports builder course gives you deeper understanding of reporting functionality to create more detailed agents, key performance indicators, scorecards, dashboards briefing books and more.

Oracle HCM Cloud foundation Business Intelligence analytics and reports building course trains you for authoring analysis and how to create, modify and share analyses, graphs and dashboards. We will provide deeper knowledge on how to build reports in Payroll, Workers compensation, Tax and other modules in HCM.

All our courses are simple to understand, instructor-led and highly customizable for your needs.