Skip to content
Zenta
Menu

Success story.

Automated Data Ingestion in GCP

A healthcare conglomerate had APIs, spreadsheets, and logs that took days to consolidate for analysis, delaying strategic decisions.

Image for the Automated Data Ingestion in GCP case

We take on any challenge

At Zenta there are no obstacles we cannot overcome.

  • Challenge

    Design an automated workflow that aggregates data from various sources into GCP every hour, ensuring quality and availability.

  • Solution

    We configured Apigee to consume APIs and Cloud Functions for parsing spreadsheets and logs, storing everything in BigQuery; we orchestrated triggers with Cloud Scheduler and reported errors via Pub/Sub.

Results from our management

  • Data available in <1 h after generation.

  • 0% manual spreadsheet loading.

  • +25% speed in executive reports.