| 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. |
...
Table A: Data Availability Chart
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 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 |
|
|
|
| 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. |
...
| 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 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 Canvas 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 Canvas CD2 data to the CCC Data Warehouse. Following that initial pass, the data will be updated nightly.
To get started, please send an email requesting Canvas DW Data 2 Data Warehouse Direct Connect access for your college to your College Experience Manager (CEM) at CCCTC Enabling Services.
| Note |
|---|
Required: Colleges must be “live” with the basic DW Direct Connect service in order to implement Canvas DW Data 2 Direct Connect access. If your college has not yet configured site-to-site VPN access with the CCC Data Warehouse, please contact Enabling Services to get started. |
| Info |
|---|
Learn more about the Canvas DW Data 2 Direct Connect service, including the college preparatory requirements before and during the implementation process: Obtaining Your Canvas Data API Access Credentials (for the CCC Data Warehouse) /wiki/spaces/ES/pages/3172564993. |
...
Making Queries
After the database connection is validated, you will be given the following prompt that will allow you to entry SQL Queries.
...