Accessibility Statement Skip Navigation
  • Why PRWeb
  • How It Works
  • Who Uses It
  • Pricing
  • Login
  • GDPR
  • Create a Free Account
Return to PRWeb homepage
  • News
  • Resources
  • Contact
When typing in this field, a list of search results will appear and be automatically updated as you type.

Searching for your content...

No results found. Please change your search terms and try again.
  • News in Focus
      • Browse News Releases

      • All News Releases
      • Multimedia Gallery

      • All Multimedia
      • All Photos
      • All Videos
  • Business & Money
      • Auto & Transportation

      • Aerospace, Defense
      • Air Freight
      • Airlines & Aviation
      • Automotive
      • Maritime & Shipbuilding
      • Railroads and Intermodal Transportation
      • Supply Chain/Logistics
      • Transportation, Trucking & Railroad
      • Travel
      • Trucking and Road Transportation
      • View All Auto & Transportation

      • Business Technology

      • Blockchain
      • Broadcast Tech
      • Computer & Electronics
      • Computer Hardware
      • Computer Software
      • Data Analytics
      • Electronic Commerce
      • Electronic Components
      • Electronic Design Automation
      • Financial Technology
      • High Tech Security
      • Internet Technology
      • Nanotechnology
      • Networks
      • Peripherals
      • Semiconductors
      • View All Business Technology

      • Entertain­ment & Media

      • Advertising
      • Art
      • Books
      • Entertainment
      • Film and Motion Picture
      • Magazines
      • Music
      • Publishing & Information Services
      • Radio & Podcast
      • Television
      • View All Entertain­ment & Media

      • Financial Services & Investing

      • Accounting News & Issues
      • Acquisitions, Mergers and Takeovers
      • Banking & Financial Services
      • Bankruptcy
      • Bond & Stock Ratings
      • Conference Call Announcements
      • Contracts
      • Cryptocurrency
      • Dividends
      • Earnings
      • Earnings Forecasts & Projections
      • Financing Agreements
      • Insurance
      • Investments Opinions
      • Joint Ventures
      • Mutual Funds
      • Private Placement
      • Real Estate
      • Restructuring & Recapitalization
      • Sales Reports
      • Shareholder Activism
      • Shareholder Meetings
      • Stock Offering
      • Stock Split
      • Venture Capital
      • View All Financial Services & Investing

      • General Business

      • Awards
      • Commercial Real Estate
      • Corporate Expansion
      • Earnings
      • Environmental, Social and Governance (ESG)
      • Human Resource & Workforce Management
      • Licensing
      • New Products & Services
      • Obituaries
      • Outsourcing Businesses
      • Overseas Real Estate (non-US)
      • Personnel Announcements
      • Real Estate Transactions
      • Residential Real Estate
      • Small Business Services
      • Socially Responsible Investing
      • Surveys, Polls and Research
      • Trade Show News
      • View All General Business

  • Science & Tech
      • Consumer Technology

      • Artificial Intelligence
      • Blockchain
      • Cloud Computing/Internet of Things
      • Computer Electronics
      • Computer Hardware
      • Computer Software
      • Consumer Electronics
      • Cryptocurrency
      • Data Analytics
      • Electronic Commerce
      • Electronic Gaming
      • Financial Technology
      • Mobile Entertainment
      • Multimedia & Internet
      • Peripherals
      • Social Media
      • STEM (Science, Tech, Engineering, Math)
      • Supply Chain/Logistics
      • Wireless Communications
      • View All Consumer Technology

      • Energy & Natural Resources

      • Alternative Energies
      • Chemical
      • Electrical Utilities
      • Gas
      • General Manufacturing
      • Mining
      • Mining & Metals
      • Oil & Energy
      • Oil and Gas Discoveries
      • Utilities
      • Water Utilities
      • View All Energy & Natural Resources

      • Environ­ment

      • Conservation & Recycling
      • Environmental Issues
      • Environmental Policy
      • Environmental Products & Services
      • Green Technology
      • Natural Disasters
      • View All Environ­ment

      • Heavy Industry & Manufacturing

      • Aerospace & Defense
      • Agriculture
      • Chemical
      • Construction & Building
      • General Manufacturing
      • HVAC (Heating, Ventilation and Air-Conditioning)
      • Machinery
      • Machine Tools, Metalworking and Metallurgy
      • Mining
      • Mining & Metals
      • Paper, Forest Products & Containers
      • Precious Metals
      • Textiles
      • Tobacco
      • View All Heavy Industry & Manufacturing

      • Telecomm­unications

      • Carriers and Services
      • Mobile Entertainment
      • Networks
      • Peripherals
      • Telecommunications Equipment
      • Telecommunications Industry
      • VoIP (Voice over Internet Protocol)
      • Wireless Communications
      • View All Telecomm­unications

  • Lifestyle & Health
      • Consumer Products & Retail

      • Animals & Pets
      • Beers, Wines and Spirits
      • Beverages
      • Bridal Services
      • Cannabis
      • Cosmetics and Personal Care
      • Fashion
      • Food & Beverages
      • Furniture and Furnishings
      • Home Improvement
      • Household, Consumer & Cosmetics
      • Household Products
      • Jewelry
      • Non-Alcoholic Beverages
      • Office Products
      • Organic Food
      • Product Recalls
      • Restaurants
      • Retail
      • Supermarkets
      • Toys
      • View All Consumer Products & Retail

      • Entertain­ment & Media

      • Advertising
      • Art
      • Books
      • Entertainment
      • Film and Motion Picture
      • Magazines
      • Music
      • Publishing & Information Services
      • Radio & Podcast
      • Television
      • View All Entertain­ment & Media

      • Health

      • Biometrics
      • Biotechnology
      • Clinical Trials & Medical Discoveries
      • Dentistry
      • FDA Approval
      • Fitness/Wellness
      • Health Care & Hospitals
      • Health Insurance
      • Infection Control
      • International Medical Approval
      • Medical Equipment
      • Medical Pharmaceuticals
      • Mental Health
      • Pharmaceuticals
      • Supplementary Medicine
      • View All Health

      • Sports

      • General Sports
      • Outdoors, Camping & Hiking
      • Sporting Events
      • Sports Equipment & Accessories
      • View All Sports

      • Travel

      • Amusement Parks and Tourist Attractions
      • Gambling & Casinos
      • Hotels and Resorts
      • Leisure & Tourism
      • Outdoors, Camping & Hiking
      • Passenger Aviation
      • Travel Industry
      • View All Travel

  • Policy & Public Interest
      • Policy & Public Interest

      • Advocacy Group Opinion
      • Animal Welfare
      • Congressional & Presidential Campaigns
      • Corporate Social Responsibility
      • Domestic Policy
      • Economic News, Trends, Analysis
      • Education
      • Environmental
      • European Government
      • FDA Approval
      • Federal and State Legislation
      • Federal Executive Branch & Agency
      • Foreign Policy & International Affairs
      • Homeland Security
      • Labor & Union
      • Legal Issues
      • Natural Disasters
      • Not For Profit
      • Patent Law
      • Public Safety
      • Trade Policy
      • U.S. State Policy
      • View All Policy & Public Interest

  • People & Culture
      • People & Culture

      • Aboriginal, First Nations & Native American
      • African American
      • Asian American
      • Children
      • Diversity, Equity & Inclusion
      • Hispanic
      • Lesbian, Gay & Bisexual
      • Men's Interest
      • People with Disabilities
      • Religion
      • Senior Citizens
      • Veterans
      • Women
      • View All People & Culture

  • Hamburger menu
  • Cision PRWeb provides efficient communication tools to continuously engage with target audiences across multiple online channels
  • Create a Free Account
    • ALL CONTACT INFO
    • Contact Us


      11AM ET Sunday – 8PM ET Friday

  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR
  • News in Focus
    • Browse All News
    • Multimedia Gallery
  • Business & Money
    • Auto & Transportation
    • Business Technology
    • Entertain­ment & Media
    • Financial Services & Investing
    • General Business
  • Science & Tech
    • Consumer Technology
    • Energy & Natural Resources
    • Environ­ment
    • Heavy Industry & Manufacturing
    • Telecomm­unications
  • Lifestyle & Health
    • Consumer Products & Retail
    • Entertain­ment & Media
    • Health
    • Sports
    • Travel
  • Policy & Public Interest
  • People & Culture
    • People & Culture
  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR
  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR
  • Send a Release
  • Sign up
  • Log in
  • Resources
  • RSS
  • GDPR

Open-Source Analytics Optimized for World Leader in Marine Logistics - DataTerrain Delivers on Initial Engagement

DataTerrain's engagement with BIRT reporting and analytics solution is new, challenging, and creative - in addition to our automated report migration services. The client, who provides comprehensive terminal operating systems for marine and intermodal terminal operators around the world, required changing technology from Oracle Reports to BIRT (an open-source software).


News provided by

DataTerrain Inc

Aug 06, 2020, 13:00 ET

Share this article

Share toX

Share this article

Share toX


PALO ALTO, Calif., Aug. 6, 2020 /PRNewswire-PRWeb/ -- DataTerrain's engagement with BIRT reporting and analytics solution is new, challenging, and creative - in addition to our automated report migration services. The client, who provides comprehensive terminal operating systems for marine and intermodal terminal operators around the world, required changing technology from Oracle Reports to BIRT (an open-source software).

DataTerrain's first extensive open source engagement demanded an ability to modify and extend the existing reporting features to suit customer requirements. BIRT has an active user community, which is very helpful in providing inputs and techniques for any client that is planning to consider BIRT. The ease of modifying with Java code and adapting with the latest visual products are highlights of the project. The goal of BIRT/OPENTEXT reporting is to provide a technology platform for creating data visualizations and reports that can be embedded into applications of all kinds, especially those built with Java and J2EE. The client chose this platform specifically for its agility, and the open-source nature of the software proved invaluable throughout our project.

All of the custom solutions fit well for the client's needs and follow best practices in the Business intelligence arena. The new reports and dashboards have been deployed in the live environment and used by daily business folks.

Post this

This project consisted of 4 phases and was completed over ten months per the client's availability and requirements. DataTerrain's team consisted of technically well-proven developers, QA Analysts, and a project manager, adhering to their usual delivery model of stringent project management and planning at the beginning of the project. All stakeholders were involved from various client teams to set the expectations, including expected delivery deadlines for each business unit. DataTerrain worked across time zones, ensuring efficient work and accessibility to our team throughout the process. Development time was also reduced by way of a collocated QA Analyst, who provided immediate feedback throughout the project lifecycle.

The primary accomplishments of working with this client aligned precisely with their goals from the outset of the project. Not only were 200 reports and dashboards migrated and converted from legacy Oracle Reports server to BIRT/OPENTEXT, but also pixel-perfect reports were created, consisting of multiple pages within each report. Size and overflow were adjusted related to HTML, PDF, and Excel formats, rendering each based on the output of the specific report. Achieving this pixel-perfect conversion hinged on the team's ability to customize the query tool in the DataTerrain automation system to replicate a hierarchy identical to that of Oracle Reports, the platform the client's team had been using. To further maintain this consistency (and easy accessibility for members of the client's staff), the conversion tool was customized to meet the client's specific visualization requirements, such as header, footer, font style, and so on.

Within these converted and migrated reports, the DataTerrain team handled filter expressions at the query level to improve performance, used JavaScript to aggregate essential information in stored procedure output columns, and created dynamic Session IDs for users per the client's specific requirements.

Beyond the migration, conversion, and customization of these reports, the DataTerrain developers encountered some shortcomings of the chosen BIRT/OPENTEXT platform. Still, because of its open-source nature, the team was able to create multiple custom solutions to achieve the client's desired results within their selected reporting platform. These custom solutions were both large and small and were essential to creating the pixel-perfect conversion across reporting systems.

These agile custom solutions include:

  • A solution for nested crosstab fields, allowing lists or data items to be added outside the crosstab and giving each added list or item the appropriate master-detail (parent-child) relationship.
  • A creative solution to substitute the legacy Oracle Reports Insert Statement function into BIRT/OPENTEXT / OpenText.
  • Fine-tuning BIRT/OPENTEXT to support running aggregation systems found in legacy Oracle Reports
  • A solution in BIRT/OPENTEXT for supporting horizontal tables (unavailable in the base software)

Open-source BIRT/OPENTEXT architecture and the deep pool of knowledge in the development team was used to adjust existing BIRT/OPENTEXT functionality to meet the needs of the client, and create a method of reporting that was both familiar to users and met all of the client's specifications.

All of the custom solutions fit well for the client's needs and follow best practices in the Business intelligence arena. The new reports and dashboards have been deployed in the live environment and used by daily business folks. This shows DataTerrain's ability to take an open-source and customize it to a large business need.

This project required great attention to the unique needs of the marine and intermodal terminal industry, as well as the methodologies employed by this particular company. Working closely with the client's leadership team allowed the project manager, QA Analysts, and developers to gain an in-depth understanding of report usage and visual elements. The insights gained helped to build functionalities that would allow the client to not only maintain their current level of Business Intelligence and data management but also to achieve new levels of consistency and success through an updated, customized reporting system.

Open Source comes with a challenging question of sustainable support availability. BIRT has an active user community, and DataTerrain has the skills, knowledge, and experience to create individualized reporting systems, Business Intelligence management systems, and beyond. DataTerrain can be reached for help with businesses large or small, at [email protected].

SOURCE DataTerrain Inc

Modal title

Contact PRWeb

  • 11AM ET Sunday – 8PM ET Friday
  • Contact Us

About PRWeb

  • About PRWeb
  • Partners
  • Partnership Programs
  • Editorial Guidelines
  • Resources

Why PRWeb

  • Why PRWeb
  • How It Works
  • Who Uses It
  • Pricing

Accounts

  • Create a Free Account
  • Log in
  • Contact Us

Do not sell or share my personal information:

  • Submit via [email protected] 
  • Call Privacy toll-free: 877-297-8921

Contact Cision

Products

About

My Services
  • All News Releases
  • Online Member Center
  • ProfNet
Cision Distribution Helpline
888-776-0942
  • Legal
  • Site Map
  • RSS
  • Cookie Settings
Copyright © 2025 Cision US Inc.