Join the Intrafocus Academy

If you like our free strategy resources then join the Intrafocus Academy for additional material

Strategy Workshop

A three-session workshop based on the Intrafocus Strategic Planning Process (SPP)

Balanced Scorecard Certification

A five-day master class and certificate as a Balanced Scorecard Professional

Strategic Plan Audit/Review

Let us take a look at your strategic plan to check it contains all the elements needed in a good plan


Strategy & KPI Resources

A library of resources for anyone interested in strategic planning and KPI management

Strategic Planning Process (SPP)

Our next generation Strategic Planning Process based on the Balanced Scorecard Methodology

Blog - Intrafocus Insight

New articles published every two weeks, join our mailing list and keep up

Our Customers

Don’t take our word for it, see what the Intrafocus customers have to say.


Spider Impact KPI Software

Intrafocus is the only EMEA authorised reseller of Spider Impact® from Spider Strategies®.

Spider Impact - Video Guides

From getting started all the way through to integrating into back-end systems.

Spider Impact - Documentation

Everything you need to know to set up Spider Impact, configure and import data

My5 KPIs - On your PC, Mac & Phone

Keep your key performance indicators to hand with the My5 KPIs universal application

Contact and Help Desk

If you have any questions or need some help or guidance, you can contact us at any time.

SQL Queries to the Database

You are here:
Estimated reading time: < 1 min

Strictly speaking, this is not an integration item as the following SQL calls can only be made from within the application. However, they can provide useful information for other activities.

There are two ways SQL calls can be made:

1. Go to Charts & Reports, click on + New Report and then select SQL Console
2. Go to Settings (small cog, lower left of the screen), click on SQL Console

Allowable SQL Calls

It is imperative that any calls made to a database contain the correct syntax. This being the case, the allowable SQL calls are included in the attached TXT file. Please copy the calls directly from your browser or download as a TXT file.

Was this article helpful?
Dislike 0
Views: 50