QQube 6.x Installed Components | CLEARIFY

Overview

There are four components that get installed, depending upon the type of installation. 

QQube Database - Holds and organizes the extracted data
Configuration Tool - Controls what data gets extracted
Synchronizer - The data extraction engine
Excel Add-In - Drag and Drop Excel Add-In

Extraction folders

• Program Files. C:\Program Files (x86)\CLEARIFY
• Excel Add-In. C:\Program Files (x86)\CLEARIFY\QQube Tool\QQube Add-In For Excel
• QQube Database and Log. (QQube.db and QQube.log) C:\Users\Public\Documents\CLEARIFY
• Examples for Excel, PowerPivot, PowerBI, Access, SAP Crystal Reports, Tableau: C:\Users\Public\Documents\CLEARIFY

QQube Database

The QQube database can be stored to a location other than the default, with two conditions:

1. It must be stored on the same physical machine where the synchronizer exists.
2. There must be proper machine permissions to access the designated folder.

The QQube.db (QQube Database) is always paired with a QQube.log file which is a transaction log that tracks all changes to the database and ensures the integrity of the database.  When a synch is successful the log file is emptied, but still exists.

QQube Configuration Tool

The QQube Configuration Tool is the brain that controls:

1. QuickBooks files are to be extracted
2. Available Analytics
3. Data synch - scheduled and automatic
4. Examples for Excel, PowerPivot, Power BI, Access, SAP® Crystal Reports, Tableau®
5. Advanced database options
6. Managing licensing and upgrades

NOTE: Operations 5 and 6 require administrative rights to perform.

QQube Synchronizer Tool

This applet sits in your system tray and allows QuickBooks to communicate with the QQube Database to ensure that the resulting data is both accurate and up to date. (Right click to show:)

If you reboot your machine, the Synchronizer Tool will automatically re-appear in the tray.

If you have a 64 bit machine you can use the 64 Bit Database Engine to talk to the database from your application. e.g. Excel, PowerBI, but QQube can only talk to QuickBooks using a 32 bit connection (QuickBooks Limitation). 

QQube Excel Add-In

This Add-In eliminates the need to deal with Microsoft Query, and thus the need to link tables together and learn their relationships. You will simply drag and drop your information into Excel and then use the native functionality of Excel to create your reports or analysis. 

All QQube does is make the data available for your use – the rest is all Excel. 

Other automatically installed elements

Several elements are installed regardless of which components are chosen to be installed:

• ODBC drivers
• Two System DSN's

These elements are what allow Excel, Crystal, Access,etc to communicate to QQube - and are the reason that others can use and update reports which you create, on their own system, if they also have QQube. 

NOTE: The QQube Configuration Tool and the ODBC components are REQUIRED elements in a Multi-User Install Client installation. 

If you have a 64 bit system, both the 64-bit ODBC drivers and 32-bit ODBC drivers get installed. However if you are using a 32-bit program, e.g. Excel, then you will only be able to use the 32-bit ODBC driver to communicate with the QQube Database. 

There are two System DSN's that get created during installation:

1. QQube User (password is "User" without the quotes)
2. QQube Financials (password is "Financials" without the quotes)

Each one employs different permission mechanisms to connect to particular QQube data sets/analytics.  The QQube Financials user has permissions for financial reporting, including analytics for financial summaries, general ledger detail and payroll (Job Costing contains payroll, but is accessed using the QQube User, not QQube Financials).  The QQube User user can connect to all other subjects.