References

Ropardo IS: Porting BI from Oracle to PostgreSQL

  • About Ropardo S.R.L.:

    Ropardo is an IT group with solid turnover and over 50 skilled employees. Innovation, Quality, On-time Delivery have been our constant objectives.
    Our main expertise is in: software development, implementation of complex software solutions and maintenance of software/IT systems.
    We provide the following in various industries: app and system development, business apps – ERP / CRM, web apps and e-business / eCommerce, software reengineering, software testing, maintenance and support.
    Further info at: www.ropardo.ro

LEVEL of SERVICES

SOFTWARE CONSULTING

Requirements management
System analysis
Risk analysis
Process management

SOFTWARE DEVELOPMENT

Software implementation

SOFTWARE SERVICES

Maintenance
Software tuning
User training

TESTING / QUALITY

Load/Performance testing

STANDARDIZED ITMS SERVICES

Change management
Problem management
Incident management
Release management

  • Outsourcing to Ropardo

    • Quality custom software development
    • End -user satisfaction
    • Short time to market
    • Quantifiable value
    • Guaranteed performance level
    • Reduced and controlled costs
    • Managed risks
    • Good value-for-money
    • Flexibility

“Information is provided whenever asked for in a consistent, precise and integrated manner!”

The project

A complete Business Intelligence Suite – Ropardo: IS – is a Java application using Oracle as the backend database. As a BI solution, Ropardo: IS is covering the following main processes: it extracts enterprise data from various data sources, transforms the raw data into its own data warehouse and provides comprehensible business information in form of reports and charts, allowing detailed business analysis.
The extension of the company asked for better organization and performing IT systems.

Challenge

Ropardo AG, headquartered in Germany was looking to improve its B.I software, that is to make it run on top of PostgreSQL database, freeing it from being tied up to a single database product. Ropardo S.R.L, having pre-qualified resources, with strong Oracle, PostgreSQL and Java skills, was challenged to accomplish this task, in a fast and cost-effective manner.

  • Migration of the Oracle backend database to PostgreSQL. The database migration involved about two hundred tables and views, and several PL/SQL complex functions. There were many technical issues like Syntax Differences, Data Types equivalence, Date/Time Processing, Built-in Functions, Null Values handled differently, Window/Analytical functions, PL/SQL vs. PL/pgSQL Differences, etc. Because no feasible solution for an automated migration was available, the team members had to perform a manual database migration, relying on their strong Oracle and PostgreSQL skills. Ropardo team had to make sure that the resulting PostgreSQL database was equivalent, and thus expecting no impact to the frontend applications.

  • Porting the Ropardo: IS Java modules. This was a smooth process, the team being well prepared in all of the technologies involved. Obviously, support for Oracle was not dropped, instead a mechanism to select the proper SQL dialect for Oracle or PGSQL was implemented.

  • Very important were the testing and deployment phases. They were necessary to ensure that the behavior of the resulting B.I. system, running on top of PostgreSQL, was identical to the original system.

Functionalities

  • detailed economic analyses at all company levels through KPI standard indicators and its own indicators
  • drill-down function to display in-depth data
  • analysis of deflective elements to identify weak points faster
  • rapid determination of products with more or less success and the difference between them
  • ad-hoc reports and warning reports
  • automated generation of standard reports
  • multi-dimensional analysis of current commercial activities with up-to-date figures, turnover evolution and values of the previous year
  • definition of individual limit values and planning figures serving to warning messages
  • open import interface facilitates data take over from various sources
is3 Ad-hoc report
is2 Standard Report Monitor

Benefits

  • efficient migration ensuring application and data integrity.

  • functional and look-and-feel equivalence with the original system.

  • open source database backend as an alternative to Oracle.

  • improved availability and scalability of the application

euniv

Download case study

Download EN

 

By continuing to use the site, you agree to the use of cookies. More information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close