Versions Compared

Old Version 80

changes.mady.by.user Liza Tont

Saved on

compared with

New Version 81

changes.mady.by.user Liza Tont

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

...

Table A: Data Availability Chart

Source Data Set

CCCCO Access

College Access

Requires Opt-In for inclusion

DW Direct
Connection

DW
Report Server

DW Direct
Connection

DW
Report Server

CCCApply Standard Application

(tick)

(tick)

(tick)

(tick)

CCCApply Noncredit Application

(tick)

(tick)

(tick)

(tick)

CCCApply International Application

(tick)

(tick)

(tick)

(tick)

California College Promise Grant Application

(tick)

(tick)

(tick)

(tick)

Decrypted LGBTQ Data (and Report)

(tick)

(tick)

(tick)

(tick)

Multiple Measures Placement Service (MMPS)

(tick)

(tick)

(tick)

(tick)

MyPath

(tick)

(tick)

(tick)

(tick)

COCI: Chancellor's Office Curriculum Inventory

(tick)

(tick)

(tick)

(tick)

C-ID: Course ID Numbering System

(tick)

(tick)

(tick)

(tick)

Canvas Data 2 (Opt-in required)

(tick)

(tick)

(tick)

CO-MIS

(tick)

NOVA

(tick)

Launchboard

(tick)

CTEOS

(tick)

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

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

  • Sends request for direct access connection to the assigned ES College Experience Manager (CEM)

  • Identifies the primary IT and researcher contacts

  • Vets the user(s) and confirms authorization of requested scope

Enabling Services (ES) College Relationship Manager (CEM)

  • Handles the incoming request for direct access connection and initiates ES processes

ES Implementation Configuration Engineer (ICE)

  • Communicates directly with college primary IT/network contact and provides access to online documentation

  • Oversees the implementation project, tracks tasks, and communicates status updates

College/District IT/Network Admin

  • Ensures ICE engineer has required system configuration information to support the project (see details below)

  • Works directly with ICE engineer to implement site-to-site VPN, connection to the database, and account login

  • Provides support to local researchers working remotely so they can connect to the VPN

ES Implementation Configuration Engineer (ICE)

  • Facilitates configuration of custom VPN and tunnel based on college system information

  • Creates service account and provides secure login credentials to authorized user(s)

  • Supports IT contact with connection and initial query testing

  • Provides implementation status updates and, upon completion of implementation, turns over “live” account to ES Support as needed

ES Support Services

  • Facilitates resolution of issues for post-implementation (live) support needs from college primary contacts

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#F4F5F7

IMPORTANT: Colleges and districts that use their own analytics/BI applications are responsible for their own support in using those tools.

...

  • Name: The name for 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 will be accessing. Identifying the environment in the name is highly recommended. (For example, if you are going to query the COCI DB, a name such as `DWH-COCI` might be appropriate.)

  • URL: Where to reach the database. Edit the auto-filled string in this field with 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

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#F4F5F7

IMPORTANT: Replace {{database}} with the specific Database Name shown in Table B below for the database to which you are trying to connect.

  • Username: The PostgreSQL username you are using to login.

  • Password: The password for the username above. 

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

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
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

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.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#F4F5F7

Note: CCCTC College Staff Support is available to assist with issues connecting to the CCC Data Warehouse.  

ES will work with colleges to validate initial data queries.

...

A: While the login credentials are intended to serve as a Service Account for the connection of local applications to the CCC Data Warehouse, individual accounts may be requested for authorized users where this is needed.LT: The following link does not work; connect to the correct page and copy link.

More Information: See the CCC Data Warehouse - Frequently Asked Questions for more information and frequently asked questions.

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#F4F5F7

To Get Help and Share HelpInfo: After successful implementation, if you need help using the CCC Data Warehouse, access the CCCTechnology.info support channel. In that forum, you can get help from the ES Support team. In addition, you can discuss use of the CCC Data Warehouse with other colleges and districts.

...