About Shared Data Warehouse
The Shared Data Warehouse (SDW) provides a database environment where standardized, shared, cross-functional contracting data is available to the DOD and its vendors to improve the procurement of supplies, services, and contract payments necessary to maintain the military readiness of the Armed Services.
The SDW infrastructure supports a streamlined, unified procurement and contract payment system that provides:
       A single view of Mocas contract data.
       Timely response to customer information
       Improved visibility of contract deliverables.
       Reductions in DFAS invoice corrections.
       Data imports to other DOD applications.
The dynamic demands of information hungry customers have driven SDW growth as a delivery service for accurate and timely information.
SDW Concept of Operations
The Shared Data Warehouse receives real time, 24x7 contract transactions from the MOCAS (Mechanization of Contract Administration System) system. Customers can easily query contract data by using reporting tools such as Cognos Impromptu or through Web Reports found on the SDW Homepage (http://www.sdw.dcma.mil/).
SDW is available 24x7 with a few exceptions
        During a daily 10 minute blackout at 0600
Eastern Time
        During a quarterly weekend, reload of the
        Infrequent scheduled downtime for
maintenance or upgrades.
Questions concerning access can be forwarded to the DCMA IT Service Center at 1-888-576-3262.
SDW Background
Since its deployment in 1996, the Shared Data Warehouse (SDW) has provided 24x7, critical decision-making information for DOD procurement and payment efforts.
The initial concept of a shared database was briefed in March 1994 to the Procurement CIM Council. As a result, a proof of concept was designed by DSDC-T to explicitly prove that the volume of Mocas contract data could be consolidated into a database on a single machine without any degradation in the transaction throughput performance. The proof of concept not only demonstrated the viability of shareable data, but also tested the performance limits of the potential database servers. Transactions matching the volume and intensity of the current production system were processed against the large volume of procurement data.
A final Shared Procurement Database Proof of Concept report was published February 15, 1995. Success was declared when the simulation showed that the same number of network users could access the database and the number of transactions significantly exceeded the transactions processed by the current system. The Procurement CIM Council and Program Management Offices (PMO) recognized the potential benefits of SDW and committed to its development. The post-prototype SDW development project began as collaboration by DOD technicians and contractors. System development was completed in late 1996.
MOCAS (Mechanization of Contract Administration Services) is an integrated system that maintains Contract Management and Contract Payment information used by DCMA and DFAS. The system has three distinct partitions identified as MOCL (West) and MOCG and MOCH (East). The MOCAS System facilitates input of contract transactions by Purchasing Offices (PO), Inventory Control Points (ICP), Field Contract Administration Activities (FCAA), and Finance and Accounting (FA) Offices.
MOCAS Data Model
About Mocas Data Share (formerly DIL)
In May 2002, DCMA initiated an effort to share MOCAS data with selected contractors for the purpose of assisting in resolution/avoidance of payment problems and contract closeout. DCMA-IT Columbus developed a series of extract programs to provide specified data to individual contractors. The initial effort was limited to the following DIL contractors:
       Booz-Allen, Hamilton, Inc.
       Lockheed Martin
       Northrop Grumman
The results of this pilot proved beneficial to DCMA, DFAS and the participating contractors. The program was expanded to include additional contractors and was renamed Mocas Data Sharing. DCMA-IT Columbus developed a web-based application to allow contractors to request specific contract data for retrieval.