Implementation

The frontend UI is implemented with Angular and backend using NestJS

Frontend is hosted in Firebase Hosting and backend in Google Cloud. Data is stored in Cloud SQL

Salesforce events are stored to Google BigQuery for easy analysis and aggregation

Backend

Backend service APIs are implemented in NodeJS using NestJS framework.

All APIs are protected with an id token sent from the frontend. Integrity and authenticity of the token is verified in the backend and the users uid is retrieved.

Backend NodeJS service is running in Google Kubernetes. Database is accessed via Cloud SQL proxy which is running in Google Kubernetes as a sideloaded Docker image.

All communications from NodeJS backend service to database are authorized, encrypted and secured