ETL / ODS Database #

• Data Architecture
• ETL Schema CSV

Database Dataflow Diagram #

flowchart TD subgraph prod["(Production Environment)"] VBMS[[VBMS]] -.- Caseflow_App[Caseflow Rails App] BGS[[BGS]] -.- Caseflow_App Caseflow_App -.- VACOLS[("VACOLS
transactional DB
(Oracle)")] Caseflow_App -- Rails --> Caseflow[("Caseflow
transactional DB
(Postgres)")] end style Replicas fill:#ddd,stroke:#333,stroke-width:2px subgraph Replicas[" "] style Replicas_label fill:#ddd,stroke:#ddd,font-size:10px,font-weight: bold Replicas_label["(Replicas)"] VACOLS -- DMS --> VACOLS_replica[("VACOLS copy
(Oracle)")] Caseflow -- Pg --> Caseflow_replica[("Caseflow replica
(RDS Postgres)")] Caseflow -- "Rails (ETL)" --> ODS[("ODS
(RDS Postgres)")] end style Metabase fill:#0ff,stroke:#333,stroke-width:2px Replicas -.-> Metabase{{Metabase}} style Redshift fill:pink,stroke:#333,stroke-width:2px subgraph Redshift[" "] style Redshift_label fill:pink,stroke:pink,stroke-width:2px Redshift_label["(Redshift)"] RS_CF_replica(('public')) RS_ODS(('ods')) RS_VACOLS_replica(('vacols')) end Caseflow -- DMS --> RS_CF_replica ODS -- DMS --> RS_ODS VACOLS_replica -- DMS --> RS_VACOLS_replica style Tableau fill:#f9f,stroke:#333,stroke-width:2px Redshift -.-> Tableau{{Tableau}}