Data Source | Data Dictionary | Data Lake (AWS S3) | ETL Method | Frequency of Upload | Data Warehouse | DW Data Warehouse Report Server (Jasper) | College/ District Availability | Notes/ Comments | |||
CCCApply: Application (includes Non-Credit App) | CCCApply Standard/CollegePromise/International App Enterprise Data Dictionary V2 | Completed | AWS Data Pipeline | Once daily | Completed (Redshift) | Completed | CCC Data 1.4.1 (Aug. 14) | ||||
CCCApply: International Application | CCCApply Standard/CollegePromise/International App Enterprise Data Dictionary V2 | Completed | AWS Data Pipeline | Once daily | Completed (Redshift) | Completed | CCC Data 1.4.1 (Aug. 14) | ||||
CCCApply: College Promise | CCCApply Standard/CollegePromise/International App Enterprise Data Dictionary V2 | Completed | AWS Data Pipeline | Once daily | Completed (Redshift) | Completed | CCC Data 1.4.1 (Aug. 14) | ||||
MyPath | Completed | AWS Kinesis Firehose | Once daily | Completed (Redshift) | Completed | ||||||
Multiple Measures Placement Service (MMPS) | Completed | CCC SuperGlue | Once daily | Completed (Redshift) | Completed | CCC Data 1.4.1 (Aug. 14) | Placement recommendation | ||||
COCI | Completed | AWS Data Pipeline | Once daily | In Progress Q4 2019/20(CCC Data 1.6) | In Progress | CCC Data 1.6 | |||||
C-ID | Completed | AWS Data Pipeline | Once daily | In Progress Q4 2019/20(CCC Data 1.6) | In Progress | CCC Data 1.6 | |||||
Canvas | Completed | CCC SuperGlueCanvas Data Domains 2017 V1 | Completed | Once daily | Completed (Redshift Spectrum) | In Progress | CCC Data 1.6 | Individual colleges Canvas data added to existing data pipeline at request of college | |||
MIS | Completed | AWS Data Pipeline | Once daily | Completed (Redshift Spectrum) | NAPending CCCCO authorization | Data Governance putting permission in place to enable MIS data to be shared from DW (and connected to DW Report Server) | |||||
Launchboard | Completed | AWS Data Pipeline | Once daily | Completed (Redshift Spectrum) | NAIn Progress | Not shared outside of support for CVC/OEI at this time | |||||
CalPass+ | Pending MOU |
Page Comparison
Manage space
Manage content
Integrations