DPAS SCR: 02067

• SCR Number
  02067
• Title
  SQL Server Message Bus Transport
• DPAS Module
  Enterprise
• Reporting Organization
  Leidos
• State
  New
• History
  08/21/2024
• Description
  Change Request: Process Improvement

   

  Description:

  Our current messaging architecture requires RabbitMQ as a message bus for communications across DPAS.  RabbitMQ being a Free and Open Source Software (FOSS) requires additional measures to be approved or configured in some environments including on-site installations.  This presents challenges to implementing DPAS in those locations.

   

  Recommended:

  Implement the SQL Server message bus transport and add configurations to allow SQL Server to be used as the message bus over RabbitMQ.  Though, RabbitMQ is the superior option, some locations don't require the throughput to justify the implementation costs.  The SQL Server implementation is sufficient for these smaller locations and is already an approved portion of DPAS.

   

  Mission Critical:

  https://docs.particular.net/transports/sql/

   

  Benefits:

  This will reduce the regulatory requirements and overall time spent in implementing DPAS for smaller locations leading to an easier installation.

   

  Frequency: Hourly

   

  Users:

  This affects most stand-alone DPAS instances.