Using Access with QQube | CLEARIFY

Using QQube with Microsoft Access

Each QQube Subject is already configured for any version of Access 2013 or above.  The underlying tables are already linked, and the relationships are already established.  (In a data warehouse, there is only one way to attach the underlying tables).  All you need to do is open one of the examples, and refresh the links (see the last picture on this page).

Getting Started

Open up the Configuration tool, and highlight "Microsoft Access" under the Examples section. You will see a list of Access examples that are installed with the QQube components. By default they are installed to "C:\Users\Public\Documents\CLEARIFY\QQube Tool\Access Examples"

The Access database will open up to a blank canvas where there is at least one query example.

Refreshing Your Own Data

FIRST. Make sure that the correct Analytic is loaded in the QQube Configuration Tool

SECOND. Check the synch logs to ensure that the Analytic Data has been extracted without errors.

THIRD. go to the Linked Table Manager as shown here, Select All, and click OK.

The Schema

The schema is already pre-connected where the subject tables are linked together in the only way possible.

Double clicking on the query example will show raw data

Looking at the design view for this example: