Database Dataflow

digraph G {
  compound=true;
  concentrate=true;
  subgraph cluster_0 {
      label="Production Environment"
      node [fontcolor=blue, color=blue]
      VBMS, BGS -> Caseflow_App [dir="none", style="dashed"]
      Caseflow_App [shape="rect", label="Caseflow Rails App"]
      Caseflow_App -> Caseflow, VACOLS [taillabel = "Ruby",labeldistance=2]
  }
  
  // { VACOLS, VBMS, BGS } -> Caseflow [dir="none", style="dashed"]
  
  subgraph cluster_1 {
    color = lightgray;
    style = filled;
    // node [color=red, fontcolor=red, shape=box ]
    replica [label="Caseflow replica\ntransactional DB (Postgres)"]
    VACOLS_replica [label="VACOLS copy\nDB (Oracle)"]
    ODS [label="ODS/ETL"];
    { rank=same; replica, ODS, VACOLS_replica }
    Replicas [width=3, shape=box, color=lightgray];
    replica -> Replicas [style=invis];
  }
  
  Caseflow [label="Caseflow\ntransactional DB\n(Postgres)"]
  VACOLS [label="VACOLS\ntransactional DB\n(Oracle)"]
    
  Caseflow -> replica [taillabel = "Pg",labeldistance=3];
  VACOLS -> VACOLS_replica [taillabel = "DMS"];
  Caseflow -> ODS [taillabel = "Ruby",labeldistance=3];

  Metabase [shape="house", style=filled, fillcolor=cyan]
  Replicas -> Metabase [ltail=cluster_1, dir="none", style="dashed"];
  
  subgraph cluster_2 {
    // label = "Redshift";
    fontcolor=red 
    color = pink;
    style = filled;
    node [color=red, fontcolor=red, shape=box ]
    RS_CF_replica [label="'public'"];
    RS_ODS  [label="'ods'"];
    RS_VACOLS_replica [label="'vacols'"];
    { rank=same; RS_CF_replica, RS_ODS, RS_VACOLS_replica }
    Redshift [width=3, shape=box, color=pink];
    RS_ODS -> Redshift [style=invis];
  }
  
  Caseflow -> RS_CF_replica [headlabel = "DMS",labeldistance=2];
  ODS -> RS_ODS [headlabel = "DMS",labeldistance=2];
  VACOLS_replica -> RS_VACOLS_replica [headlabel = "DMS",labeldistance=2];
  
  Tableau [shape="house", style=filled, fillcolor=orchid1]
  Redshift -> Tableau [ltail=cluster_2, dir="none", style="dashed"];
  
  // newrank = true;
//   subgraph cluster_3 {
//       node [shape=box, color=darkgreen]
//       edge [arrowhead=lvee,color=darkgreen];
//       DM [label="Jupyter notebook", shape="none"]
//       color = chartreuse2;
//       style = filled;
//   }
  
//   {   
//     edge [color=darkgreen, arrowhead=normal];
//     { replica, ODS, VACOLS_replica } -> DM [lhead=cluster_3, dir="none", style="dashed"];
//   } 
}