Installed Components

Overview

QQube installs five primary components, depending on the type of installation.

• QQube Database — Holds and organizes the extracted data.
• QQube Configuration Tool — Controls which data is extracted.
• QQube Synchronizer — Extracts data from QuickBooks.
• QQube Excel Add-In — Provides drag-and-drop Excel reporting.
• QQube Examples — Includes 250 examples for supported reporting applications.

QQube Database

The QQube Database stores and organizes the data extracted from QuickBooks.

The database consists of two files:

• QQube.db — Stores the extracted data.
• QQube.log — Tracks database changes and helps maintain database integrity.

The log is emptied after a successful synchronization, but the file remains in place.

The QQube Database can be stored in a location other than the default when:

1. It remains on the same physical machine as the QQube Synchronizer.
2. The required Windows permissions are granted for the selected folder.

QQube Configuration Tool

The numbered sections shown in the QQube Configuration Tool control:

1. QuickBooks company files — Select the files from which QQube extracts data.
2. Data models — Choose the subjects available for scheduled or manual synchronization.
3. Data synchronization — Manage schedules, manual refreshes, and synchronization logs.
4. Date setup — Control extraction dates, data-model date ranges, calendars, holidays, and the definition of today.
5. Examples — Open examples for Excel, Excel Power Pivot, Power BI, Access, SAP Crystal Reports, and Tableau.
6. Advanced database options — Manage options that require administrative access.
7. Account information — Manage licensing, support, and product suggestions.

QQube Synchronizer

The QQube Synchronizer runs from the Windows system tray and has two purposes:

1. It indicates that the QQube data-extraction process is ready.
2. It displays messages while synchronization is in progress.

The QQube Synchronizer should restart automatically when the computer is rebooted.

QQube Excel Add-In

The QQube Excel Add-In provides a drag-and-drop interface for creating Excel reports.

It handles the underlying table relationships through Microsoft Query. Select the information you need, then use Excel to format, calculate, and analyze the results.

QQube Examples

QQube includes 250 examples, with at least one example for each data model and supported reporting application:

• Microsoft Excel
• Excel Power Pivot
• Microsoft Power BI
• Microsoft Access
• SAP Crystal Reports
• Tableau

Open an existing example and modify it instead of starting from scratch.

Default installation folders

• QQube program files
  C:\Program Files (x86)\CLEARIFY
• QQube Excel Add-In
  C:\Program Files (x86)\CLEARIFY\QQube Tool\QQube Add-In For Excel
• QQube Database and log
  C:\Users\Public\Documents\CLEARIFY
• QQube examples
  C:\Users\Public\Documents\CLEARIFY

Other installed components

QQube also installs the components used by Excel, Power BI, Access, Crystal Reports, and other applications to connect to the QQube Database.

ODBC drivers

These drivers allow supported reporting applications to communicate with QQube.

They also allow a report created by one QQube user to be opened and refreshed by another QQube user without creating a special connection string.

On a 64-bit version of Windows, QQube installs both the 32-bit and 64-bit ODBC drivers. Each reporting application uses the driver that matches its own 32-bit or 64-bit architecture.

Important: The QQube Configuration Tool and ODBC components are required on every Multi-User client installation.

System DSNs

QQube creates two System DSNs:

• QQubeUser — Password: User
• QQubeFinancials — Password: Financials

Each DSN uses different permissions for accessing QQube data models.

• QQubeFinancials provides access to financial reporting, including financial summaries, general ledger detail, and payroll.
• QQubeUser provides access to all other subjects, including Job Costing.

QQubeFinancials is the super user.

Microsoft Power BI stores credentials separately. You may be prompted for the appropriate DSN password when opening a QQube report for the first time.