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 |
---|
Introduced in Release Version
DW Direct | DW | DW Direct | DW | |
CCCApply Standard Application |
|
|
|
CCCApply Noncredit Application |
|
|
|
|
CCC Data 2.0
CCCApply International Application |
|
|
|
California College Promise Grant Application |
|
|
|
Decrypted LGBTQ Data (and Report) |
|
|
|
|
CCC Data 2.0
Multiple Measures Placement Service (MMPS) |
|
|
|
|
CCC Data 2.0
MyPath |
|
|
|
COCI: Chancellor's Office Curriculum Inventory |
|
|
|
|
CCC Data 2.1
C-ID: Course ID Numbering System |
|
|
|
|
Canvas Data 2 |
(Opt-in) |
|
|
|
|
|
CCC Data 2.1
CO-MIS |
|
|
|
CCC Data 2.1
NOVA |
|
|
|
| |
Launchboard |
|
|
|
|
CCC Data 2.1
CTEOS |
|
|
|
|
CCC Data 2.1
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
Upon request from an authorized individual at a college or district office (often the Dean overseeing Institutional Research), one or more members of the CCCTC Enabling Services team will work directly with your college IT group to configure a custom site-to-site VPN based on your system, and establish secure direct access connection to the CCC Data Warehouse from your college (or district). Following the successful implementation and query validations, the ES Support team will be able to provide post-implementation (Live) support through the CCCTechnology.info support channel.
...
Participant | Is responsible for… |
---|---|
College / District Researcher |
|
Enabling Services (ES) College Relationship Manager (CRMCEM) |
|
ES Implementation Configuration Engineer (ICE) |
|
College / District IT/Network Admin |
|
ES Implementation Configuration Engineer (ICE) |
|
ES Support Services |
|
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
First Step: An authorized individual sends a request to your ES College Relationship Experience Manager (CRMCEM) to implement a direct access connection (ODBC/JDBC) to the CCC Data Warehouse. |
...
The first step in establishing a direct access connection is for an authorized individual at the college or district (typically the Vice Chancellor or Dean overseeing Institutional Research) to make a request directly to the CRM CEM assigned to your college. Upon approval, your CRM CEM will initiate the implementation process by passing the required information to the ES implementation team to get started on your custom VPN and account credentials.
Please identify and provide the following information to your CRMCEM:
Primary Researcher Contact: Name and email address of the Researcher who will be responsible for the account login credentials.
Primary IT/Network Admin Contact: Name and email address of the IT/Network Admin contact who will work with ES to establish the site-to-site VPN connection.
System Configuration Information: Firewall make, model, and version, and IP information.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Start with Your CRMCEM: The initial request should be made to your College Relationship Manager. If you do not know who your CRM CEM is, send an email to crms@ccctechcenter cems@ccctechcenter.org. |
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Next Step: ES ICE engineer works with your primary IT contact(s) to facilitate the configuration of the VPN and establish the account credentials. |
...
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. |
...
If a local data warehouse is available, configure a CCC Data Warehouse table as an “external table” in the local database source. This supports data within the CCC Data Warehouse to be connected to your local data warehouse without the need to copy data to the local machine or district server.
Info |
---|
CCCTC Enabling Services College Staff Support is available to assist with issues connecting to the CCC Data Warehouse. |
...
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 Relationship Experience Manager (CRMCEM) 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 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)site-to-site VPN access with the CCC Data Warehouse, please contact Enabling Services to get started. |
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.
...
A. Not at this time. If this is needed, please discuss with your CRMCEM.
Q: My IT department does not want to create a site-to-site VPN, can I just have an individual VPN connection?
...