Introduction
...
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 required) |
|
|
| ||
CO-MIS |
| ||||
NOVA |
| ||||
Launchboard |
| ||||
CTEOS |
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
...
Participants, Roles, and Responsibilities
Participant | Is responsible for… |
---|---|
College/District Researcher |
|
Enabling Services (ES) College Relationship Manager (CEM) |
|
ES Implementation Configuration Engineer (ICE) |
|
College/District IT/Network Admin |
|
ES Implementation Configuration Engineer (ICE) |
|
ES Support Services |
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
IMPORTANT: Colleges and districts that use their own analytics/BI applications are responsible for their own support in using those tools. |
...
This section is designed for authorized colleges who want to gain access to the CC CCC Data Warehouse Redshift cluster databases. AWS Redshift is a secure, cloud-based data warehouse service used for collecting and storing large-scale data sets and enables users to analyze data using various BI tools.
...
Complete VPN Configuration & Log In from Internal Network: Log in and connection to the Redshift cluster must originate from your local network.
Account Login Credentials: Obtain your account credentials (username and password) and the database endpoint (DNS), provided by your ES implementation team.
Database Connection Strings & Schemas: Ensure the database names, connection strings, and schema roles are correct to access specific databases (see Table B: Application Database Names below).)
Remote Connection: If you are working remotely and the district has authorized it, you will need to establish a connection to the district’s internal network using a separate VPN client that the district has provided for this purpose.
...
Download the Amazon Redshift JDBC driver version 2.0 to enable SQL Workbench to communicate with Redshift. Below is the zip file to download.:
...
With the drive selected, a sample endpoint will autofill in the URL field that will need . This endpoint needs to be modified, and several other fields will need to be filled out. See the example below.
...
The important fields to configure are as follows:
Name: The name for this connector that you will reference later when you want to access this database again. This is for your use only, so make it descriptive enough to where you understand clearly which DB clearly descriptive for the database you are accessing. For example, if you are going to query the COCI DB, something like `DWH-COCI` might be appropriate. Signifying Identifying the environment in this the name is highly recommended.
URL: Where to reach the database. Edit the auto-filled string here in this field with your the custom endpoint (example shown below).
Environment | Endpoint | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Production | jdbc:redshift://dwh-prod.ccctechcenter.org:5439/{{database}} Ex: jdbc:redshift://dwh-prod.ccctechcenter.org:5439/canvas2
|
Where “database” is the name of
|
Username: the The PostgreSQL username you are using to login.
Password: the The password for the username above.
Place a checkmark in the Autocommit box (as shown in the example below.)
...
Click `Test` Test in the lower right to verify you have connected successfully. Then click OK.
...
Table B: Application Database Names and Schema Formats
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 represents the 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> |
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Note: Data dictionaries for the above data sources are available on the CCC Data Warehouse documentation site. |
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Troubleshooting: If the IMPORTANT: For troubleshooting, if the connection test fails, the two most common fixes are as follows:
| ||||||
Panel | ||||||
| ||||||
Next Step: Validate your connection and data access
|
...
Data Access Validation & Testing
...
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.
...
panelIconId | atlassian-info |
---|---|
panelIcon | :info: |
bgColor | #F4F5F7 |
Note: CCCTC College Staff Support is available to assist with issues connecting to the CCC Data Warehouse.
ES works with college colleges to validate initial data queries.
Using provided user documentation (this user guide), college configures BI tool to connect to the Data Warehouse.
College will confirm local connection and successful login, as well as perform optional data validation activities.
Online documentation is available to support data access validation activities for Researchers.
...