DAS Infrastructure Architecture
AWS Topology
Three EC2 instances and two RDS MySQL instances. Source: Lucidchart diagram reviewed during SSIS session. Note: no inter-node arrows existed in the original diagram — relationships inferred from SSIS job logic.
graph TD
subgraph AWS["AWS VPC"]
subgraph EC2_BHS["3BHS001 · r7l.2xlarge · 10.254.210.10"]
Auth["Auth"]
Autos["Automobiles"]
ClientDB["ClientDB"]
Lift["Lift"]
BirdBath["BirdBath (legacy)"]
end
subgraph EC2_SQL["SQL01 · r6i.4xlarge · 10.254.210.28"]
ActivityLog["ActivityLog"]
DmsWH["DmsWarehouse"]
DigiBun["DigitalBundle (legacy)"]
Inventory["Inventory"]
Tracking["Tracking"]
end
subgraph EC2_ETL["ETL01 · r5a.8xlarge · 10.254.210.32"]
EDW_S["EDW_Staging"]
EDW_T["EDW_Target"]
SSISDB["SSISDB"]
end
subgraph RDS1["RDS · db.m6g.2xlarge"]
Analytics["Analytics (MySQL)"]
end
subgraph RDS2["RDS · db.m6g.2xlarge"]
Mautic["Analytics-Mautic (MySQL)"]
end
end
Instance Inventory
ETL01
EC2
Primary ETL server. Runs SSIS, hosts the data warehouse staging and target databases. This is the critical path for all downstream reporting.
EDW_Staging
EDW_Target
SSISDB
3BHS001
EC2
Application-facing databases. BirdBath and Lift are legacy — modified cautiously, as their blast radius (downstream dependencies) isn't yet mapped.
Auth
Automobiles
ClientDB
BirdBath
Lift
SQL01
EC2
DMS data ingestion target. DigitalBundle is legacy and likely unused, pending dependency audit.
ActivityLog
DmsWarehouse
Inventory
Tracking
DigitalBundle
Analytics RDS
RDS MySQL
Primary MySQL RDS. Feeds into DWRPT views.
Analytics
Mautic RDS
RDS MySQL
Mautic open-source email/segmentation platform. Decoupled from main SSIS pipeline — feeds directly to 3Birds portal.
Analytics-Mautic
Key Observations
- › No documented inter-node relationships — the original Lucidchart diagram showed instances with no arrows. Dependencies exist only in SSIS job logic.
- › 12-year-old codebase — multiple ownership changes. BirdBath, DigitalBundle, and Lift appear unused but are retained because their downstream dependencies (blast radius) aren't yet mapped.
- › SFTP ingestion is dual-sided — sometimes DAS hosts the SFTP (customer pushes), sometimes the customer hosts it (DAS pulls). AWS monitors SFTP and triggers SSIS on new file arrival.
- › Mautic is decoupled — email/segmentation runs on its own RDS, feeds the portal independently of the main SSIS ETL pipeline.
Source Captures
Screencaps extracted from the session recording by Planopticon. The Lucidchart diagram was shown live during the SSIS review. Click to view full resolution.
