The Challenge

Enhance the User Experience, Streamline Data Management

CIMA’s website was originally built to be static. Any change, even simple content, required a complex
deployment cycle.

The monolithic database architecture was too slow for modern user expectations, completely reloading site content with every user request.

While complying with the security and regulatory demands of their industry, CIMA needed to dynamically integrate data from Socrata, a third party API.

Our Approach

A Fresh Approach to Database Architecture

The Edrans solution prioritized agility. A multi-layer database architecture changed how the user interfaced with CIMA data. The data access layer (DAL) improved agility, reducing the time spent incorporating new metrics from days to minutes.

Edrans also created a data gateway between the CIMA and Socrata databases. Using a Unesco API, Edrans established a local cache of data, accelerating its delivery to the end user.

To decouple informational updates from platform development, Edrans used Drupal’s open source content management system (CMS), enabling publication of new content in real time, without the involvement of the development team.

The Technical Story

To create an efficient, stable workflow that can manage a large amount of data, we implemented microservices using SQS to consume data from a variety of third-party APIs. The results are stored

in the AWS DynamoDB NoSQL database.
Node.js microservices running on Docker in AWS Elastic Container Services (ECS) expose the data to the website.

The Results

Continuous, Efficient Improvement

Today, the CIMA user experience is greatly improved and the development team focuses on new features, not content updates.

The agile, multi-layer architecture makes it easier to add or improve specific modules without disrupting website performance. Workflows allow the content team to update content and respond faster to changing business priorities.

Technologies used

AWS EC2, AWS S3, Node.JS, Ember.JS 2.0, Redis, Drupal

Other success stories

In 2012, Edrans led the implementation project for the new IT infrastructure built to normalize the payment process at Lastminute, one of the biggest online travel agencies in Europe, to allow its platform to comply with the requirements of the PCI DSS (Payment Card Industry Data Security Standard).

Karumi is an international code and training consultancy. Their clients maintain long-term relationships with Karumi for the development and ongoing innovation of mobile and enterprise applications.

In 2014 Edrans implemented a series of improvements, which allowed to increase the efficiency in the management of the infrastructure for the BID ConnectAmericas social network.