SoftCart-Data-Platform-Architecture

Environment:

This document introduces you to the data platform architecture of an ecommerce company named SoftCart.

SoftCart uses a hybrid architecture, with some of its databases on premises and some on cloud.

Tools and Technologies:

OLTP database - MySQL NoSql database - MongoDB Production Data warehouse – DB2 on Cloud Staging - Data warehouse – PostgreSQL Big data platform - Hadoop Big data analytics platform – Spark Business Intelligence Dashboard - IBM Cognos Analytics Data Pipelines - Apache Airflow

Process:

SoftCart’s online presence is primarily through its website, which customers access using a variety of devices like laptops, mobiles and tablets.