Essential information for Commonwealth of Massachusetts departments on MMARS Information Delivery, and the Commonwealth Information Warehouse (CIW). Please contact the Solution Desk for information on running a Warehouse Starter Query in Access 2010.
The Commonwealth Information Warehouse (CIW) brings together a subset of the financial, budgetary, human resources, payroll, and time reporting information maintained in dedicated and separate systems by individual agencies. CIW provides access to integrated, common data that supports timely, well-informed business decisions to authorized users through a centralized and integrated repository. The pages linked below are available inside state government only.
VISIT THE CIW
The Commonwealth Information Warehouse has moved to the AWS Redshift environment as of February 18, 2022. The Netezza (CIW_Prod) environment will no longer be available. This change will affect all CIW users and the Service Desks which support the CIW.
- Please use the AWS Redshift environment for any CIW queries/reports.
- Refresh existing linked tables/views to AWS Redshift (if you have not already done so).
You will no longer be able to connect to the Netezza CIW_Prod environment.
For any CIW problems, please contact the Executive Office of Technology Services and Security (EOTSS) End User Support at 844-435-7629 or [email protected].
The Office of the Comptroller offers CIW resources and training for state employees. The links to the CTR Intranet below are available inside state government only.
Class Presentation
CIW Navigation Guide Access 2016 – MMARS Data
Class Presentation
Navigation Guide - Access 2016
Class Presentation
Report Building Navigation Guide – Access 2016
Navigation Guide - CIW Report Building with Excel 2016
Report Building Navigation Guide – Access 2016
Class Presentation
Reports for MMARS/LCM Listings
VIEW EXCELDocument profiles provide an overview of MMARS documents, including the document name, and code, function, workflow and supporting documentation. The profiles include a definition of each document section and field description. [MAGNet access or VPN required].
VIEW ON CTR INTRANETThe EOTSS online viewing system user interface
VISIT MOBIUSVIEWPull link tables from the Commonwealth Information Warehouse by running queries, or which reports to look up in MobiusView to identify any type of entry in MMARS. (PowerDMS login required).
