OTHER DATABASE CASE STUDIES
Customer is a leading Personal Data Privacy and Protection provider.
It enables organizations to discover and map all types of data from all enterprise data sources; automatically classify, correlate, and catalogue identity & entity data into profiles; manage and protect enterprise data with advanced data intelligence; and automate data privacy and protection.
It identifies all PII across structured, unstructured, cloud & Big Data.
Customer requested to build a Connector app to integrate their platform with Google BigQuery to scan the data present in the BigQuery for finding the PII information.
BigQuery is a fully-managed data warehouse on RESTful web service that enables scalable, cost-effective and fast analysis of big data working in conjunction with Google Cloud Storage.
Sacumen developed the Connector app to integrate Google BigQuery using C# 8.0 (.NET Core 3.0). The Connector app performs the following actions:
Set up the OAuth consent screen in Cloud Console and get the Client Id and Client Secret to authenticate the API.
Connects to Cloud BigQuery using the ProjectId and the OAuth flow.
Retrieves the data of all the entities from the database.
Gets the requested data within a certain timeline.
Samples the fetched data using predefined sampling techniques.
Formats the received data in the required format and pass it to the customer.