| 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)
...
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. |
...
| 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 | canvas | canvas_rs_<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. |
...
To get started, please send an email requesting Canvas DW 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 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). |
...
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?
...