This website is using cookies. More details
Data Warehouse migration case study

European Commission – Data Warehouse Migration

European Commission is running a data warehouse applicaton which fetches data from about 25 data sources

Learn more about :

About the customer

The European Commission (EC) is the executive branch of the European Union, responsible for proposing legislation, implementing decisions, upholding the EU treaties and managing the day-to-day business of the EU.

European Commission

About the project

European Commission is using Denodo platform for their Data Warehouse solution, which is running 24/7 on dedicated hardware and licenced through a yearly fee.

ARHS Spikeseed Cloud Team was requested to designed a cloud-native architecture to migrate Denodo to AWS, with the following objectives :

  • 01. Migrate Denodo without any impact on performances

  • 02. Design a cost effective architecture using AWS cloud-native architecture

  • 03. Follow security best practices to ensure data security

Project Solution

ARHS Spikeseed designed a cloud-native architecture providing on demand access to Denodo, following state-of-the-art solutions and best practices, namely:

  • 01.

    AWS Lambda as the serverless controller for Denodo and notifications

  • 02.

    Amazon Simple Storage Service for storing service files

  • 03.

    Amazon Simple Email Service for sending customized emails

  • 04.

    AWS Relational Database Services to manage the Data Warehouse

  • 05.

    AWS Identity and Access Management for permission management

  • 06.

    AWS Elastic Cloud Compute and AWS Marketplace as on demand provider for Denodo

Project Results

  • 01.

    Solution migrated to the cloud

  • 02.

    On demand availability of Denodo

  • 03.

    Cost effective licence fee on an hourly basis (with significant savings)

  • 04.

    Managed and secure data access