European Commission – Data Warehouse Migration
European Commission is running a data warehouse applicaton which fetches data from about 25 data sources
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.
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