(Note: DRAFT in PROGRESS. Currently in the process of merging new content with this existing content from the DW Direct Access User Guide. That draft work is being done outside of Confluence, but I’ve added the basis doc here. Existing technical content is being revised, deleted from, and added to, using new technical info from Jack. I have a separate draft of Jack’s new data model user guide content. Jack also needs to create and send me additional technical info, per our working meeting.)
...
For authorized researchers at CCC institutions who want to connect local applications to data sources within CCC Data, the CCCTC supports direct access connection to the CCC Data Warehouse as an alternate or additional option to the CCC Data Warehouse (Jaspersoft) Report Server. Local applications at CCC colleges /or districts may include an analytics or business intelligence application such as Tableau or Power BI.
...
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. |
...