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 | ||||||
---|---|---|---|---|---|---|
| ||||||
Secure access to CCC Data is provided to institutional researchers, college and district administrators, and other decision - makers across at the California Community Colleges, district offices, and the Chancellor’s Office, where these critical data may be used to support instructional and institutional decision-making aligned with the Chancellor's Office Vision for Success2030. |
...
Contents
Table of Contents | ||
---|---|---|
|
...
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 |
|
|
|
|
CCC Data 2.0
CCCApply Noncredit Application |
|
|
|
CCCApply International Application |
|
|
|
California College Promise Grant Application |
|
|
|
|
CCC Data 2.0
Decrypted LGBTQ Data (and Report) |
|
|
|
Multiple Measures Placement Service (MMPS) |
|
|
|
|
CCC Data 2.0
MyPath |
|
|
|
|
CCC Data 2.6
COCI: Chancellor's Office Curriculum Inventory |
|
|
|
C-ID: Course ID Numbering System |
|
|
|
|
Canvas Data 2 |
(Opt-in) |
|
|
|
|
|
CCC Data 2.1
CO-MIS |
|
|
|
|
CCC Data 2.1
NOVA |
|
|
|
CCC Data 2.1
Launchboard |
|
|
|
| |
CTEOS |
|
|
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
Environment | Endpoint | ||
---|---|---|---|
Production | jdbc:redshift://dwh-prod.ccctechcenter.org:5439/{{database}} Ex: jdbc:redshift://dwh-prod.ccctechcenter.org:5439/canvascanvas2
|
...
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_ |
read_<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 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 nightlyper a configured schedule.
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. |
...
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.
...