Elements of SSOARS


For the Social Security Online Accounting and
Reporting System (SSOARS), the Social
Security Administration uses Oracle
Financials and the Oracle database
management system with the General Ledger,
Accounts Payable, Accounts Receivable and
Purchasing modules.

Servers and storage

Software resides on clustered servers from
Sun Microsystems running Solaris. The system
uses Sun Cluster software for high availability
and database failover, Oracle Real
Application Clusters for sharing resources
between nodes, and load-balancing software
from Alteon Networks. EMC direct-access
storage devices supply about 500G of production
storage. Veritas Volume Manager from
Symantec manages the disk drives, and
Veritas File System is used to speed access
and recovery times. Control-M software from
BMC Software handles scheduling.

Disaster recovery

SSA uses a disk-to-disk-to-tape backup system
to ensure that no more than one day's
data is ever lost in a disaster. It uses EMC
TimeFinder software to create Business
Contingency Volume backups twice daily '
before and after batch processing. After the
primary and secondary volumes are synchronized,
split and mounted onto a backup server,
the secondary volume is copied to tape using
Veritas Net Backup and Media Server. Daily
and monthly backups are stored off-site.


Business Objects' Crystal Reports software is
used to create a graphical user interface for
reports on the SSA Web portal.


SSOARS links with the agency's purchasing
system, Compusearch Software Systems'
Prism-Procurement. It also links to the government's
Travel Manager system and the Central
Contractor Registration database.


  • business meeting (Monkey Business Images/Shutterstock.com)

    Civic tech volunteers help states with legacy systems

    As COVID-19 exposed vulnerabilities in state and local government IT systems, the newly formed U.S. Digital Response stepped in to help. Its successes offer insight into existing barriers and the future of the civic tech movement.

  • data analytics (Shutterstock.com)

    More visible data helps drive DOD decision-making

    CDOs in the Defense Department are opening up their data to take advantage of artificial intelligence and machine learning tools that help surface insights and improve decision-making.

Stay Connected