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.
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
SoftCart’s online presence is primarily through its website, which customers access using a variety of devices like laptops, mobiles and tablets.