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. |
...
CCCApply: Application (Credit and Non-Credit App)
CCCApply: International Application
California College Promise Grant Application
Multiple Measures Placement Service (MMPS)
MyPath Data
Canvas Data (Opt-in required)
Chancellors Office Curriculum Inventory (COCI)
Course Identification Numbering System (C-ID)
NOVA (CCCCO Only)
Launchboard (CCCCO Only)
MIS (CCCCO Only)
CTEOS (CCCCO Only)
Table A: Data Availability Chart
Source Data Set | CCCCO Access | College Access | Requires Opt-In for inclusion | ||
---|---|---|---|---|---|
DW Direct | DW | DW Direct | DW | ||
CCCApply Standard Application |
|
|
|
| |
CCCApply Noncredit Application |
|
|
|
| |
CCCApply International Application |
|
|
|
| |
California College Promise Grant Application |
|
|
|
| |
Decrypted LGBTQ Data (and Report) |
|
|
|
| ||||
Multiple Measures Placement Service (MMPS) |
|
|
|
| |
MyPath |
|
|
|
| |
COCI: Chancellor's Office Curriculum Inventory |
|
|
|
| |
C-ID: Course ID Numbering System |
|
|
|
| |
Canvas Data 2 (Opt-in) |
|
|
|
|
|
CO-MIS |
|
|
|
| |
NOVA |
|
|
|
| |
Launchboard |
|
|
|
| |
CTEOS |
|
|
|
|
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 | dw_canvas2_rsread_<misScope> |
Info |
---|
Note: Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
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 nightlyper a configured schedule.
To get started, please send an email requesting Canvas Data 2 Data Warehouse Direct Connect access for your college to your College Experience Manager (CEM) at CCCTC Enabling Services.
...
Info |
---|
Learn more about the Canvas Data 2 Direct Connect service, including the college preparatory requirements before and during the implementation process: /wiki/spaces/ES/pages/3172564993. |
...
Accessing In-Progress Application Data in the CCC Data Warehouse
The CCCApply “in_progress_applications” table is available in the Data Warehouse via Direct Connect Access to make it easier for researchers to perform quick queries without having to include the joins manually for every query.
See Accessing In-Progress Application Data in the CCC Data Warehouse for tables and query information.
...
Making Queries
After the database connection is validated, you will be given the following prompt that will allow you to entry SQL Queries.
...