Yes I work in government and its a pain to have other agencies centralize or agree on things. There are many different systems, many are old, some are not even electronic. Expecting them to all work together is foolish. Expecting departments with different agendas, control, policies, rules and politics to all kumbaya is wishful thinking.
We are getting better over time but its not just some simple fix. I thought you would understand that.
My forte for over 30 years was Systems Analysis, Systems Integration, Database Design and Application Programming, Database Replication, and Database Administration.
One project I worked was the scheduling of all Pacific Fleet Naval Vessels. We set up automated replication of MS Excel 5.0 to MS Excel 6.0 spreadsheets, automated macros to populate that data into MS Sql Server in Hawaii, California, Virginia. We then replicated that to Oracle servers at Hawaii, California, Virginia, DC, England and Italy.
Four data formats/repositories, 2 sets of geographically separated relational databases, and it worked.
Oh, yeah -- that's just ONE example of data sharing between a variety of government agencies including the Pentagon.
Just stop.