ALIMENTACIÓN

Plataforma de Datos e Ingeniería de Datos

MEA | 6 MESES

Tecnologías clave

SAP ECC & BW

AZURE DATA LAKE

SYNAPSE

DATABRICKS

POWER BI

MODERNIZACIÓN DE LA PLATAFORMA DE DATOS

01
El Reto - Requisitos

El cliente desea migrar los procesos ETL, el servidor SQL para implementar Synapse para integrar todas las diferentes fuentes de datos en un único repositorio, tener todos sus datos guardados y cifrados, tener un repositorio para realizar cualquier transformación e integración de datos y crear modelos analíticos de manera segura y sencilla.

myCloudDoor desarrolla, mantiene y opera una plataforma de datos en Azure basada en Synapse y Databricks que permite la automatización de la ingestión de datos, la transformación, los informes y la explotación. La arquitectura permite una división entre cómputo y almacenamiento, proporcionando una plataforma flexible, escalable y optimizada con la que obtener información de sus datos.

02
La Solución - Beneficios

DATA PLATFORM MODERNIZATION

01
THE CHALLENGE - REQUIREMENTS

The customer wanted to migrate the ETL processes, SQL server to implement Synapse to integrate all the different data sources in one single repository, have all their data saved and encrypted, have a repository to perform any data transformation and integration and create analytical models in a secure and simple way.

02
THE SOLUTION - BENEFITS

myCloudDoor develops, maintains and operates a data platform on Azure based on Synapse and Databricks that allows automating data ingestion, transformation, reporting and exploitation. The architecture allows for a split between computing and storage, providing a flexible, scalable and optimized platform with which to obtain insights from their data.

EL RETO – REQUISITOS
El cliente quería migrar los procesos ETL, SQL server para implantar Synapse para integrar todas las diferentes fuentes de datos en un único repositorio, tener todos sus datos guardados y encriptados, disponer de un repositorio para realizar cualquier transformación e integración de datos y crear modelos analíticos de forma segura y sencilla.

LA SOLUCIÓN – VENTAJAS
myCloudDoor desarrolla, mantiene y opera una plataforma de datos en Azure basada en Synapse y Databricks que permite automatizar la ingestión, transformación, elaboración de informes y explotación de datos. La arquitectura permite dividir la computación y el almacenamiento, proporcionando una plataforma flexible, escalable y optimizada con la que obtener información de sus datos.

name	domain	purpose	expiry	type
thb-revolution-cookiebar	myclouddoor.com	Cookie required to use website options and services	1 month	HTTP
ARRAffinitySameSite	myclouddoor.com	Cookie required to use website options and services	1 day	HTTP
ARRAffinity	myclouddoor.com	ARRAffinity is a cookie used to affinitize a client to an instance of an Azure Web App.	1 day	HTTP
SEARCH_SAMESITE	google.com	SameSite prevents the browser from sending this cookie along with cross-site requests. The main goal is mitigate the risk of cross-origin information leakage. It also provides some protection against cross-site request forgery attacks.	4 months	HTTP
OGPC	google.com	Cookie required to use website options and services	10 days	HTTP
AEC	google.com	Cookie required to use website options and services	12 months	HTTP
__Secure-3PSIDCC	google.com	Cookie required to use website options and services	1 year	HTTP
__Secure-1PSIDCC	google.com	Cookie required to use website options and services	1 year	HTTP
__Secure-1PSID	google.com	Cookie required to use website options and services	2 years	HTTP
__Secure-1PAPISID	google.com	Cookie required to use website options and services	2 years	HTTP

name	domain	purpose	expiry	type
google.com	https://myclouddoor.com	Download certain Google Tools and save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.	2 years	HTTP
SIDCC	google.com	Download certain Google Tools and save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.	2 years	HTTP
SID	google.com	Download certain Google Tools and save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.	2 years	HTTP
OTZ	google.com	Aggregate analysis of website visitors	1 month	HTTP
NID	google.com	This cookies is used to collect website statistics and track conversion rates and Google ad personalisation	7 months	HTTP
HSID	google.com	Download certain Google Tools and save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.	2 years	HTTP
APISID	google.com	Download certain Google Tools and save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.	2 years	HTTP
1P_JAR	google.com	These cookies are set via embedded youtube-videos. They register anonymous statistical data on for example how many times the video is displayed and what settings are used for playback.	1 month	HTTP
IDE	doubleclick.net	This cookie is used for targeting, analyzing and optimisation of ad campaigns in DoubleClick/Google Marketing Suite	1 year	HTTP
DSID	doubleclick.net	This cookie is used for targeting, analyzing and optimisation of ad campaigns in DoubleClick/Google Marketing Suite	9 days	HTTP

name	domain	purpose	expiry	type
SAPISID	google.com	Download certain Google Tools and save certain preferences, for example the number of search results per page or activation of the SafeSearch Filter. Adjusts the ads that appear in Google Search.	2 years	HTTP
_gid	myclouddoor.com	ID used to identify users for 24 hours after last activity	1 day	HTTP
_gat	myclouddoor.com	Used to monitor number of Google Analytics server requests when using Google Tag Manager	1 day	HTTP
_ga	myclouddoor.com	ID used to identify users	2 years	HTTP
__Secure-3PSID	google.com	These cookies are used to deliver more relevant ads for you and your interests.	2 years	HTTP
__Secure-3PAPISID	google.com	This cookies are used to deliver more relevant ads for you and your interests.	2 years	HTTP
UULE	google.com	Cookie associated with the Google Maps service. Allows geolocation from our laboratory in the corresponding section of this website. We adhere to the privacy policy of Google	1 day	HTTP
CONSENT	google.com	Google cookie consent tracker	2 years	HTTP

name	domain	purpose	expiry	type
Azure / Microsoft	account.microsoft.com	https://account.microsoft.com/privacy	12 months	HTTP
DoubleClick/Google Marketing	privacy.google.com	https://privacy.google.com/take-control.html	1 year	HTTP
Google Analytics	privacy.google.com	https://privacy.google.com/take-control.html	1 year	HTTP
Google	privacy.google.com	https://privacy.google.com/take-control.html	1 year	HTTP

Food – Data on Cloud

Manufacturing – Data Platform & Data Engineering

ALIMENTACIÓN

Plataforma de Datos e Ingeniería de Datos

Tecnologías clave

MODERNIZACIÓN DE LA PLATAFORMA DE DATOS

01
El Reto - Requisitos

02
La Solución - Beneficios

DATA PLATFORM MODERNIZATION

01
THE CHALLENGE - REQUIREMENTS

02
THE SOLUTION - BENEFITS

Food – Data on Cloud

Manufacturing – Data Platform & Data Engineering

Manufacturing – Data Platform & Data Engineering

Food – Data on Cloud

ALIMENTACIÓN

Plataforma de Datos e Ingeniería de Datos

Tecnologías clave

MODERNIZACIÓN DE LA PLATAFORMA DE DATOS

01El Reto - Requisitos

02La Solución - Beneficios

DATA PLATFORM MODERNIZATION

01THE CHALLENGE - REQUIREMENTS

02THE SOLUTION - BENEFITS

01
El Reto - Requisitos

02
La Solución - Beneficios

01
THE CHALLENGE - REQUIREMENTS

02
THE SOLUTION - BENEFITS