Oracle to Greenplum
Partner
March 6, 2020
Reply [MTA, STAR: REY] is specialized in the design and implementation of solutions based on new communication channels and digital media.
Composed of a network model of highly specialized companies, Reply supports the main European industrial groups belonging to the Telco & Media, Industry and Services, Banks and Insurance and Public Administration sectors in the definition and development of business models enabled by the new Big paradigms Data, Cloud Computing, Digital Media and the Internet of Objects. Reply's services include: Consulting, System Integration and Digital Services.
For twenty years Reply supports its customers in the development of Business Analytics systems of varying complexity, taking care of the entire information life cycle, from the analysis of raw data up to the strategic indicators conveyed by innovative calculation and representation tools.
In the last few years, in every industrial sector, awareness has increased in the vast possibilities deriving from the exploitation of big data, through analytics models able to exploit the potential of the new NoSql technologies. Reply, combining technological expertise in data analysis / modeling and process reengineering, has facilitated the process of approaching its customers to the big data theme, encouraging the activation of a real and concrete path of cultural change and introducing a new approach to the issue of data management, whether internal to the company or deriving from external agents.
We have performed a migration project for one of the Automotive leader companies in the world. The project included migration of our client’s database from Oracle to Pivotal Greenplum (based on PostgreSQL). The scope of this project migration included conversion of eigth Oracle instances (3 Datawarehouses and 5 Datamarts), with thousands of tables, views, procedures, functions, external interfaces and ingestion scripts.
This huge work has been resolved successfully with the precious help of the tool Ispirer MnMTK and several customizations and adaptations to our needs, carried out by the Ispirer technical specialists. The main challenge of this project was the high complexity of business logic written in the Oracle stored procedures using some particular Oracle features.
After a year of hard work the project has finished successfully. Ispirer has been a reliable and highly qualified partner, and their technical specialists made customizations in a timely fashion and very accurate way.