Versions Compared

Key

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

...

Item

Notes

1

Update on CCC Data 2.0 release

CCC Data 2.0 Pilot:

  • Deployed to Pilot

  • Several colleges involved and able to complete Pilot testing

  • Very successful pilot

    • results were good the feedback was excellent

    • Testing helped support implementation process

Pilot Activities:

  • Testing did include colleges installing a custom vpn working in coordination with with our team

    • vpn is used to secure the data so that the data warehouse is only accessed when using a direct connection, over site to site vpn

  • Pilot colleges connected either using Tableau or Power BI

  • Pilot testing also included colleges running direct sequel direct queries using MySQL Workbench

  • We were not able to test colleges connect tables from the data warehouse to a local data warehouse as external tables, pilot colleges IT did not have bandwidth to support

    • As we continue to roll out direct connection, we look forward to engaging colleges to test and document this process

CCC Data 2.0 Production:

  • Deployed to Production

  • Adoption of DW direct connect

    • 15 colleges working with our Enabling Services group and are in various stages of going live on direct connection to the Data Warehouse

    • 96 colleges using the report server

Difference between DW Report Server and DW Direct Connect

Question/Answers:

  1. Dulce Delgadillo (She/Her): Once connected can CCCTC provide guidance on how to query

  2. Dustin Tamashiro: Helpful to see upfront on documentation what type of sequel language is compatible

2

Overview of the upcoming CCC Data 2.1 release

CCC Data 2.1

  • New data sources in DW segmented by MIS code & made available to CCC’s through DW Report Server (DWRS) and direct  DW access:

    • Canvas (as opted-in to by individual colleges)

    • MyPath

    • COCI

  • New data sources in DL & made available to CCCCO

    • Nova 

    • Launchboard 

Adoption of 2.1

  • When we released we will be providing instructions on how to initiate implementation process and begin coordination with our Enabling services group

Question/Answers:

  1. Dulce Delgadillo (She/Her): Is the Canvas data by institution or district?

    • Denice Inciong: We have it by colleges but our district has access for connections to our SIS. But, the owners for us are the colleges.

    • Mark Cohen: What data comes across as based on the API key 

    • John Sills: Any district colleges that have their own instance they're all set up at the district level and those API keys are generated the district level so getting it set up, I think, initially would probably require a district type decision.

3

Discussion on a proposed survey for feedback on how colleges are accessing and using CCC Data Warehouse resources.

We currently have 96 colleges that are engaging in some level with with the data warehouse survey will help to better understand:

  • How they are connecting to the DW?

  • How they would like to connect to DW?

  • What data sources they're using?

  • What they're doing with the data?

  • What applications are they connecting when using direct connection?

Gathering feedback from advisory group to determine best approach on how to engage research community

4

Questions and Feedback

  1. Dulce Delgadillo (She/Her): Non credit regional group may be a forum where we can include in the agenda once survey is ready to be shared

Announcement

  1. Alex Jackl: Have submitted the data access policy, policy for dictating what access is appropriate to what data, will be reviewed again by general counsel, will be shared with group once reviewed and approved by legal

5

...