Our client, a financial services company based in Chile, had a variety of ETL processes that were executed manually and decentrally. This made it difficult to track and control the data. In addition, some data was not adequately protected.
- Limited visibility of ETL processes: It was difficult to track and manage ETL processes, as they were executed manually and in a decentralized manner.
- Lack of a standardized approach: There was no standardized approach to running ETL processes, making it difficult to comply with rules and regulations.
- Insufficient data protection: Some data was not adequately protected, exposing the company to security risks.
CleverIt proposed to implement Google Cloud Platform Data Fusion Governance. Data Fusion Governance is a service that provides a centralized platform for managing ETL processes. This time, CleverIT's implementation of Data Fusion Governance had the following benefits for the customer:
- Improved visibility: Data Fusion Governance provides a centralized view of all ETL processes. This allows the customer to see what processes are running, when they are running and what data they are processing.
- Improved governance: Data Fusion Governance provides controls to ensure that ETL processes run securely and consistently.
- Improved data protection: Data Fusion Governance provides integrated security features that help protect company data.
- Cost reduction: Data Fusion Governance uses transient instances to execute ETL processes, which can help reduce costs.
- CleverIT implemented Data Fusion Governance in three environments: development, test and production.
- CleverIt used transient instances to run ETL processes, helping to save nearly $3,600 per Data Fusion instance.
- CleverIT provided training to customer teams on how to use Data Fusion Governance.
CleverIt is committed to helping its customers take advantage of technology to improve their businesses. The implementation of Data Fusion Governance is an example of how CleverIT can help companies improve the visibility, governance and protection of their data.