...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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. |
...
For authorized Researchers at CCC institutions who want to connect local applications to data sources within CCC Data, the CCC Tech Center (CCCTC) now supports direct access connection to the CCC Data Warehouse as an alternate or additional option to the CCC Data Warehouse (Jaspersoft) Report Server. Local applications may include an analytics or business intelligence application such as Tableau or Power BI.
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Reminder: Direct access is an alternate or additional option to the CCC Data Warehouse Report Server for authorized CCC institutional researchers. |
...
Note |
---|
Colleges and districts using their own analytics/BI applications are responsible for their own support in the use of these tools. |
...
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
First Step: An authorized individual sends a request to your ES College Relationship Manager (CRM) to implement a direct access connection (ODBC/JDBC) to the CCC Data Warehouse. |
...
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 CRM: The initial request should be made to your College Relationship Manager. If you do not know who your CRM is, send an email to crms@ccctechcenter.org. |
Tip |
---|
Next Step: ES ICE engineer works with your primary IT contact(s) to facilitate the configuration of the VPN and establish the account credentials. |
...
In order to access the (Redshift) databases, a service account will be established based on the scope of your authorized access (MIS scope). Your ES ICE engineer will provide the account login credentials (username and password), as well as the database endpoint (DNS) and schemas roles (also provided in this document), to your primary IT contact through secure transmission.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Note that the login credentials are a Service Account, while they are issued to an individual they are intended to be used to connect applications (such as Tableau) to the CCC Data Warehouse. Protecting these credentials is the responsibility of the college. |
Scope of Access
Authorized access to the CCC Data Warehouse for colleges and districts using direct access connection (ODBC/JDBC) is permitted through secure login credentials to your local network VPN.
...
Table B: Application Database Names
Info |
---|
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. |
...