Project Description

Loading...

Client

Dentaid

Business

Research, development and sale of oral health products

Sector

Heatlth

Objective

Design and creation of Oracle SOA in AWS

Products and services

Oracle SOA Suite, AWS

“Thanks to the implementation of Oracle SOA Suite realized by 3Hold, we were able to deploy a catalog of services in AWS to integrate our ERP with our CRM (Veeva), a catalog that we will be using in future projects.”

Rafael Sarrión

TIC Director

The client

Since 1980, the Dentaid Group has focused on improving the oral health of people through state-of-the-art solutions developed by dentists, dental hygienists and pharmacists. The group is founded on values like innovation, rigorousness, commitment and responsibility through which they achieve their goals and bring oral health to the entire population.

The main components of the group are: Dentaid, which produces chemical solutions (mouthwashes and toothpaste) and sells physical and chemical products; PHB, which sells physical products and chemical solutions; and Medical Devices, responsible for the production of physical products (manual and electric toothbrushes, as well as irrigators).

The clients of Dentaid are clinics, pharmacies, parapharmacies, supermarkets, distributors and wholesalers. Its sales force is based on medical visit teams that achieve the prescription of doctors and teams that visit pharmacies.

The company has a workforce of more than 400 people, and in 2017 it exceeded the threshold of 100 million euros of turnover for the first time in its history.

Dentaid has a factory in Cerdanyola, where its main offices are also located, and another in Llinars del Vallés, where its logistics center is located; both locations are in the province of Barcelona. In addition, in Spain it has subsidaries in Barcelona, Bilbao, Madrid, Oviedo, Seville and Valencia that complete its commercial network.

Thanks to its internationalization plan, it currently has its own subsidiaries in Belgium, France, Germany, Italy, Luxembourg, Holland, Chile, Colombia and Peru and has a large network of sixty-three distributors located in other countries on five continents.

EL RETO

The main motivation to implement an Enterprise Service Bus (ESB) arose because of Dentaid´s Strategic Plan, in which it was decided to create two web platforms: one aimed at creating bonds with its customers (PAP), and the other aimed at electronic commerce between companies (B2B).

Being two web platforms, and having to interact with the client’s back-ends, it made perfect sense for the ESB to be hosted in AWS to be able to communicate ideally with both the Web layer and the information source applications (ERP, CRM, MDM, etc.)

This, together with the need to integrate solutions from other countries into the SOA layer due to international expansion, was a major boost for the idea that both the Oracle SOA Suite platform and the new WEB platforms (PAP and B2B), should reside in AWS.
The client had to create the following application architecture:

The client had to create the following application architecture:

The design made by 3Hold, which will be explained below, was the ideal solution for the applications central layer – the SOA layer. In the case of Dentaid, the SOA layer to be deployed was Oracle SOA Suite.

Project requirements

The client has a small team of system administrators, which is why, one of our goals in the design of the final architecture was that the infrastructure to be created had zero, or very low maintenance.

The client still did not have any experience in AWS environments, so it was also vital that the solution could recover itself automatically in case of a server becomes unavailable.

In addition, the client established a 1 hour for Recovery Time Objective (RTO) and 30 minutes for Recovery Point Objective (RPO) with a service timetable of 24 x 7 x 365. The number of applications that currently interact with the SOA layer are nine: PAP, B2B, PI, BI, VEEVA CRM, SAP ERP, WEB, CMS.
Due to the number of messages to be moved between applications (200,000) and the load derived from that messages’ number, it was decided not to provide it with horizontal or vertical scalability.

The solution

The compiled client’s data and motivations, together with our reasonings, led us to design and implement the following architecture in AWS.

For the Fusion Middleware Application Server, a single instance was used in an Auto Scaling group across several AWS availability zones. The Auto Scalation group will always ensure that there is at least one instance up and running, in whatever area of availability, achieving compliance with the proposed RTO. Moreover, applications access to that instance through an ELB (Elastic Load Balancer) for which an alias was created in Route53 to facilitate access to it through a custom URL.

Elastic File System (EFS) was used to create the shared directories, file sharing through the nfs v.4 protocol in different availability zones simultaneously, without having to have an additional host and paying only for the used storage.

For the Oracle database instance, the AWS RDS service was used with the BYOL (Bring-Your-Own-License) licensing model and in multiple Availability Zones, satisfying also with the RTO and reducing to a minimum the maintenance tasks, backup management, performance monitoring, and so on.
Finally, in order to make EFS backup copies, the AWS Data Pipeline service was used, which makes a daily copy with 7 days’ retention, as well as a fortnight copy with a 2-month retention.

Are you facing the same challenges?

We help you to design a solution that adapts to your business´s needs

    Name (required)

    Position

    Company

    Email (required)

    Phone

    Subject (requerido)

    Do you have an imminent project?
    Noin one monthin three monthsin six monthsin one yearmore than a year

    Project Type:
    CloudSAPCloud & SAPIoTBig DataB2BB2C

    Message (required)

    I´ve read and accept the Privacy Policy