• Access to data in the Data Warehouse is based upon user authorization from each of the University host systems. Views will be created on appropriate tables in the Data Warehouse that reflect this authorization. To request access to data, an online authorization form must be submitted at:
  https://www.ais.columbia.edu/ais/nff/ais_id_form1.html

DESKTOP AND DEPARTMENTAL REPORTING

The CUIT Data Warehouse is a set of databases containing data extracted from such University administrative systems as:

Potential users of Enterprise Business Intelligence Solutions data must demonstrate that they possess the following three qualifications:

Instructions for Query Tool Access:

How to use ODBC to connect MS Access to Columbia University's Data Warehouse on Sybase:

POLICIES AND BEST PRACTICES 

DATA WAREHOUSE POLICIES

ENTERPRISE REPORTING

Enterprise Reporting is defined as reporting on Columbia University's information assets that are needed by most or all departments across the University. 

REQUESTING ACCESS TO REPORTS AND DATA   

Web Access to Data Warehouse Reports