Academy

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

Resources

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.

Software

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.

Defining a SQL import connection

You are here:
Estimated reading time: 1 min

Defining a SQL Import Connection

Direct connections to SQL databases can be defined if required. Data can then be extracted from the database using SQL calls. 

To set up a data connection, you will first need access to the database. This might require installing Spider Impact into your local environment. Contact Intrafocus for more information on this subject.

If the database is accessible, that is, you have the right permissions to access the database, then the following procedure can be used.

  • Go to Application Administration (small cog, bottom left of the screen)
  • Click on Import Connections in the Data Import & Export section
  • Click on + Add Connection in the Database Connections panel. The following dialogue box will appear:
Define SQL Database

In the example above you can see we have defined a connection to a cloud-based free SQL database. The types of connection parameters will be the same for a local SQL database if this operation is undertaken locally.

  • Click Next, the following dialogue will appear

 

Name the Connection

Add the connection name, this can be anything useful and memorable and optionally add an Owner for the connection.

  • Click Done

The Connection you have defined will appear in the list in the Database Connections section

Connection List

Once the connection has been established, data can be imported directly from the SQL database and mapped to the fields contained within a Scorecard. A schedule can be put in place to pull the data on a regular cycle, for example, weekly, monthly or quarterly.

Go to Import Data Values to see the next stage.

Was this article helpful?
Dislike 0
Views: 96