| 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. |
...
| 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. |
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Next Step: Work with your ES ICE engineer to confirm access validation and query tests. Discuss any unfinished implementation steps before hand-off to ES Support. |
...
Canvas Data 2 with DW Direct Connect Service
Colleges may request to access their Canvas Data 2 (CD2) data through the CCC Data Warehouse via direct access connection (ODBC/JDBC). The ability to access CD2 data will require the college Canvas Administrator to generate and pass their Canvas Data 2 API credentials to the CCCTC Enabling Services Implementation Engineer as part of the configuration process. Once received and implemented, the data pipeline will be configured to pass your CD2 data to the CCC Data Warehouse. Following that initial pass, the data will be updated nightly.
...