Introduction
This guide provides an overview of the implementation configuration for establishing a direct access connection (ODBC/JDBC) to the CCC Data Warehouse for authorized California Community Colleges (CCC) districts and colleges.
...
With the drive selected, a sample endpoint will autofill in the URL field. This endpoint needs to be modified, and several other fields need to be filled out. See the example below.
...
The important essential fields to configure are as follows:
Name: The name for this the connector that you will reference later to access this database again. This is for your use only, so make it clearly descriptive for the database you are accessing. will be accessing. Identifying the environment in the name is highly recommended. (For example, if you are going to query the COCI DB, something like `DWH-COCI` might be appropriate. Identifying the environment in the name is highly recommended.)
URL: Where to reach the database. Edit the auto-filled string in this field with the custom endpoint (example shown below).
...
| 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 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. |
...
Note: CCCTC College Staff Support is available to assist with issues connecting to the CCC Data Warehouse.
ES works will work with colleges to validate initial data queries.
Using provided user documentation (this user guide), the college configures their BI tool to connect to the Data Warehouse.
College will confirm The college confirms local connection and successful login, as well as perform and also performs optional data validation activities.
Online documentation is available to support data access validation activities for Researchers.
...
| panelIconId | atlassian-check_mark |
|---|---|
| panelIcon | :check_mark: |
| bgColor | #F4F5F7 |
...
researchers.
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
...