Case of success
Direct line
Servinformacion participated in this project from its planning, development and implementation, providing the technological and knowledge inputs for the implementation of a solution that would allow processing and exploring the data for Línea Directa.
Challenge
Upload large volumes of historical company information from the SAP HANA On-Premises platform to GCP, and use Google Cloud services to Analyze and Process the uploaded data so that with the resulting information, the company You can obtain insights with which you can answer business questions to overcome current and future challenges in Línea Directa.
Solution
Cloud VPN is used to establish a connection to the SAP On-premises platform, then through Cloud Data Fusion the data is extracted to be inserted into BigQuery. Once the information is found in BigQuery, it is with Spark in Cloud Data Proc, thus generating a Dataset in BigQuery with refined and reliable Data that can be queried using SQL.
Outcome
Count by 2022 with a Data Lake implementing in Google Cloud that centralizes data, is scalable and has a high availability. This centralization allows processing, modeling and present the data in a Sheet to help direct line to define future Catalogs based on the sales history.
Marketer of Products by Fashion Catalog, was born with the purpose of being a business to develop people and that people in turn strengthen the business. It is a company with multiple brands and channels where they are passionate about developing quality garments.
*All rights reserved. This publication is for commercial, informational and illustrative purposes. The content on this portal has the sole purpose of highlighting the success stories developed, implemented, managed and supported by SERVINFORMACIÓN. On the occasion of contracts, purchase orders and other legal instruments entered into with the aforementioned companies. The information published is exclusively intended to describe the contracted service, respecting the commitments of confidentiality, non-disclosure and use of the brand. SERVINFORMACIÓN under no circumstances reveals information of a confidential, sensitive or reserved nature according to the contracted service and in accordance with the regulatory framework of Law 1581 of 2012, Decree 1377 of 2013, and other regulations that regulate the protection of personal data in Colombia. This publication is supported in part by the framework of Law 1150 of 2007, Decree 19 of 2012 and Decree 1082 of 2015 rules that regulate Public Procurement in Colombia and the right of companies to register and publish the experience in a Unique Registry of Proponents (RUP) with the intention of presenting themselves as proponents in the different modalities of public procurement. SERVINFORMACIÓN when publishing the names of the entities and companies using the logo, text and photographs, it should NOT be interpreted that between SERVINFORMACION and the entities there is a de facto partnership, consortium, joint venture, association, shareholding, or joint venture. The logo and brand was taken from the main page of the Entity, without any alteration and for illustrative purposes and for reference only. The only relationship that exists or existed between the entity and company mentioned was the provision of a service. If you consider that we are violating your rights with any publication (text, photography or use of logo), please contact us at the email: servinformacion@servinformacion.com and this publication will be expanded, supported or corrected.
Have a smart location project in mind?
Increase the Productivity of your company and improve your business opportunities
Tell us your idea.
