{"id":22543,"date":"2023-12-29T12:29:33","date_gmt":"2023-12-29T12:29:33","guid":{"rendered":"http:\/\/myclouddoor.com\/portfolio-item\/food-data-on-cloud-copy\/"},"modified":"2024-08-12T12:17:53","modified_gmt":"2024-08-12T11:17:53","slug":"food-data-platform-data-engineering","status":"publish","type":"portfolio","link":"https:\/\/myclouddoor.es\/en\/portfolio-item\/food-data-platform-data-engineering\/","title":{"rendered":"Food &#8211; Data Platform &amp; Data Engineering"},"content":{"rendered":"\n<p>THE CHALLENGE &#8211; REQUIREMENTS<br>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.<\/p>\n\n\n\n<p>THE SOLUTION &#8211; BENEFITS<br>myCloudDoor develops, maintains and operates a data platform on Azure based on Synapse and Databricks that allows automating data ingestion, transformation, reporting and exploitation.&nbsp;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.<\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>THE CHALLENGE &#8211; REQUIREMENTSThe customer wanted to migrate the ETL processes, SQL server to implement Synapse to integrate all the different data sources in one single<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":5,"featured_media":22537,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"portfolio-types":[233],"class_list":["post-22543","portfolio","type-portfolio","status-publish","has-post-thumbnail","hentry","portfolio-types-use-cases"],"_links":{"self":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/portfolio\/22543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/comments?post=22543"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/media\/22537"}],"wp:attachment":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/media?parent=22543"}],"wp:term":[{"taxonomy":"portfolio-types","embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/portfolio-types?post=22543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}