Installed Components

Overview

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

• QQube Database — Stores and organizes the extracted QuickBooks data.
• QQube Configuration Tool — Controls company files, data models, synchronization, dates, examples, and administrative settings.
• QQube Synchronizer — Extracts data from QuickBooks.
• QQube Excel Add-In — Provides drag-and-drop Excel reporting.
• QQube Examples — Includes approximately 250 report, workbook, dashboard, and application examples.

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.

QQube Configuration Tool

The numbered sections 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.

Select the QQube fields you need, then use Excel to format, calculate, filter, and analyze the results. The Add-In handles the underlying query construction for you.

QQube Examples

QQube includes approximately 250 report, workbook, dashboard, and application examples for supported reporting applications:

• 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 Tool
• QQube examples
  C:\Users\Public\Documents\CLEARIFY\QQube Tool

Other installed components

QQube also installs the components used by Excel, Power BI, Access, Crystal Reports, and other supported 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 32-bit and 64-bit ODBC drivers. Each reporting application uses the driver that matches its own architecture.

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 or refreshing a QQube report for the first time.