Introduction
...
At the prompt asking you to configure the driver, select ‘Yes,’ as shown below.'
...
The Manage Drivers menu will appear. Click the Folder icon and navigate to the directory that contains the driver package that you recently unzipped, as shown below.
...
With the drive selected, a sample endpoint will autofill in the URL field. This endpoint needs to be modified, and several other fields need to be filled outcompleted. See the example below.
...
The essential fields to configure are as follows:
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, something like 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).
...
Place a checkmark in the Autocommit box (, as shown in the example below.)
...
Click Test in the lower right to verify you have connected successfully. Then click OK.
...
| 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. |
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
IMPORTANT: For troubleshooting , if the connection test fails, the two most common fixes are as follows:
|
...
If a local data warehouse is available, configure a CCC Data Warehouse table as an “external table” 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.
...
Using provided user documentation (such as this user guide), the college configures their BI tool to connect to the Data Warehouse.
The college confirms local connection and successful login, and also performs optional data validation activities.
Online documentation is available to support data access validation activities for researchers.
Work with your ES ICE (engineer) to confirm access validation and query tests. Discuss any unfinished implementation steps before hand-off to ES Support.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Important: Colleges must be “live” live with the basic DW Direct Connect service in order to implement Canvas Data 2 Direct Connect access. If your college has not yet configured site-to-site VPN access with the CCC Data Warehouse, please contact Enabling Services to get started. |
...
After the database connection is validated, you will be given the following prompt that will allow you to entry enter SQL Queries.
...
A tab labeled Database Explorer displays more information about the database that your user has access to. Table names can be found herethere, as well as some additional basic additional information about the DB.
...
Finally, you You can also run SQL against objects your DB user has access to.
...
To get a row count of a table you can , run the following query:
| Code Block | ||
|---|---|---|
| ||
select count(*) from dw_apply_read_523.contact; |
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
To Get and Share Help: 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. |
...