Data Source | Data Dictionary | Data Lake (AWS S3) | ETL Method | Frequency of Upload | Data Warehouse | DW Report Server (Jasper) | 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 | |
CCCApply: International Application | Completed | AWS Data Pipeline | Once daily | Completed (Redshift) | Completed | ||
CCCApply: College Promise | Completed | AWS Data Pipeline | Once daily | Completed (Redshift) | Completed | ||
MyPath | Completed | AWS Kinesis Firehose | Once daily | Completed (Redshift) | Completed | ||
Multiple Measures Placement Service (MMPS) | Completed | CCC SuperGlue | Once daily | Completed (Redshift) | Completed | Placement recommendation | |
COCI | Completed | AWS Data Pipeline | Once daily | In Progress Q4 2019/20 | In Progress | ||
C-ID | Completed | AWS Data Pipeline | Once daily | In Progress Q4 2019/20 | In Progress | ||
Canvas | Completed | CCC SuperGlue | Once daily | Completed (Redshift Spectrum) | In Progress | Individual colleges Canvas data added to existing data pipeline at request of college | |
MIS | Completed | AWS Data Pipeline | Once daily | Completed (Redshift Spectrum) | NA | 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) | NA | Not shared outside of support for CVC/OEI at this time | |
CalPass+ | Pending MOU |
Manage space
Manage content
Integrations