Manufacturing

Integración de Datos en Data Lake y SAP

ESPAÑA

Tecnologías clave

INDUSTRIA

DATA LAKE

SAP ECC

SAP BW

DATABRICKS

INTEGRACIÓN DE DATOS EN DATA LAKE Y SAP

01
El Reto - Requisitos

El cliente busca construir una plataforma de datos responsable de obtener información de diferentes fuentes relacionadas con finanzas y RRHH (como SAP ECC, SAP BW, entre otros), organizando y preparando los datos; además de consumir y visualizar la información.

myCloudDoor desarrolla, mantiene y opera una plataforma de datos en Azure basada en Data Lake (almacenamiento de datos), Azure Data Factory (ingestión por lotes), Azure Databricks (transformación de datos) y Power BI (reportes de datos). Además, se han utilizado las herramientas Debezium y Kafka para realizar la ingestión en tiempo real desde SAP ECC.

02
La Solución - Beneficios

03
El Resultado

El cliente ahora puede visualizar, analizar y controlar los datos financieros y de RRHH más actualizados en una única herramienta de reportes.

CLOUD ANALYTICAL COST MANAGEMENT TOOL

01
THE CHALLENGE - REQUIREMENTS

The client needs to improve the intercompany management of all the costs associated with its Cloud infrastructure (Azure, AWS and Private). The processes associated with invoicing are manual and with many errors, a lot of time and money is wasted in this management.

02
THE SOLUTION - BENEFITS

myCloudDoor develops, and deploy an application based on Azure services like Azure Functions, WebApps and Power BI Embedded.  
myCloudDoor develops an analytical data model that automatically integrates usage / consumption information from public (Azure / AWS) and private clouds.

03
THE RESULT

Our costumer has a tool to control the cost management of the different clouds of the Banco Santander. The intercompany billing process is automated, consumption prediction processes are implemented, and the use of cloud resources is optimized, improving the company's OPEX.

01
El Reto – Requisitos
El cliente busca construir una plataforma de datos responsable de obtener información de diferentes fuentes relacionadas con finanzas y RRHH (como SAP ECC, SAP BW, entre otros), organizando y preparando los datos; además de consumir y visualizar la información.
02
La Solución – Beneficios
myCloudDoor desarrolla, mantiene y opera una plataforma de datos en Azure basada en Data Lake (almacenamiento de datos), Azure Data Factory (ingestión por lotes), Azure Databricks (transformación de datos) y Power BI (reportes de datos). Además, se han utilizado las herramientas Debezium y Kafka para realizar la ingestión en tiempo real desde SAP ECC.
03
El Resultado
El cliente ahora puede visualizar, analizar y controlar los datos financieros y de RRHH más actualizados en una única herramienta de reportes.

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

Retail – Optimización de Machine & Deep Learning

Farmacéutica – Segmentación de Clientes

Manufacturing

Integración de Datos en Data Lake y SAP

Tecnologías clave

INTEGRACIÓN DE DATOS EN DATA LAKE Y SAP

01
El Reto - Requisitos

02
La Solución - Beneficios

03
El Resultado

CLOUD ANALYTICAL COST MANAGEMENT TOOL

01
THE CHALLENGE - REQUIREMENTS

02
THE SOLUTION - BENEFITS

03
THE RESULT

Retail – Optimización de Machine & Deep Learning

Farmacéutica – Segmentación de Clientes

Farmacéutica – Segmentación de Clientes

Retail – Optimización de Machine & Deep Learning

Manufacturing

Integración de Datos en Data Lake y SAP

Tecnologías clave

INTEGRACIÓN DE DATOS EN DATA LAKE Y SAP

01El Reto - Requisitos

02La Solución - Beneficios

03El Resultado

CLOUD ANALYTICAL COST MANAGEMENT TOOL

01THE CHALLENGE - REQUIREMENTS

02THE SOLUTION - BENEFITS

03THE RESULT

01
El Reto - Requisitos

02
La Solución - Beneficios

03
El Resultado

01
THE CHALLENGE - REQUIREMENTS

02
THE SOLUTION - BENEFITS

03
THE RESULT