Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(Note: DRAFT in PROGRESS. Liza T. currently Currently in the process of merging new content with this existing content from the established DW Direct Access User Guide. That draft work is being done outside of Confluence, but I’ve added this the basis doc here, as requested. The existing technical content here will be is being revised, deleted from, and added to, etc., using the new data model technical info from Jack Thompson. I have a separate draft of Jack’s new data model user guide content. Jack also needs to create and send me additional technical info, per our review working meeting.)

Introduction

This guide provides an overview of the implementation configuration for establishing a direct access connection (ODBC/JDBC) to the CCC Data Warehouse for authorized California Community Colleges (CCC) districts and colleges.

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

The value of <misScope> can be derived from the prefix of your Data Warehouse Direct user name which is in the format of <misScope>_<firstInitial><lastName> i.e. 000_jdoe, where 000 represents the MIS scope value. An example of the resulting schema for accessing tables within the Application database = dw_apply_read_000.

Application (Data Source)

Database Name

Query Schema Format

CCCApply Application

application

dw_apply_read_<misScope>

CC College Promise Grant

bogfw_application

dw_apply_read_<misScope>

CCC International Application

intl_application

dw_apply_read_<misScope>

Multiple Measures Placement Service (MMPS)

mmps

dw_apply_read_<misScope>

Chancellor's Office Curriculum Inventory (COCI)

coci

dw_coci_read_<misScope>

Course Identification Numbering System (C-ID)

cid

dw_cid_read_<misScope>

Canvas Data 2

canvas2

dw_canvas2_read_<misScope>

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

Note: Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site

...