Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
This guide provides an implementation configuration overview for establishing a direct access connection (ODBC/JDBC) to the CCC Data Warehouse for authorized CCC colleges and districts. |
...
Source Data Set | CCCCO Access | College Access | Requires Opt-In for inclusion | Introduced in Release Version | |||
---|---|---|---|---|---|---|---|
DW Direct | DW | DW Direct | DW | ||||
CCCApply Standard Application |
|
|
|
| CCC Data 2.0 | ||
CCCApply Noncredit Application |
|
|
|
| CCC Data 2.0 | ||
CCCApply International Application |
|
|
|
| CCC Data 2.0 | ||
California California College Promise Grant Application |
|
|
|
| CCC Data 2.0 | ||
Decrypted LGBTQ Data (and Report) |
|
|
|
| CCC Data 2.0 | ||
Multiple Measures Placement Service (MMPS) |
|
|
|
| CCC Data 2.0 | ||
MyPath |
|
|
| CCC Data 2.6 | |||
COCI: Chancellor's Office Curriculum Inventory |
|
|
|
| CCC Data 2.1 | ||
C-ID: Course ID Numbering System |
|
|
| CCC Data 2.1 | |||
Canvas Data 2 (Opt-in) |
|
|
|
|
| CCC Data 2.6 | |
CO-MIS |
|
|
|
| CCC Data 2.1 | ||
NOVA |
|
|
|
| CCC Data 2.1 | ||
Launchboard |
|
|
|
| |||
CTEOS |
|
|
| CCC Data 2.1 |
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
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 would represent their 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 | canvas2_rs_<misScope> |
Info |
---|
Note: Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...