Working with SQL Database data sources

Structured Query Language (SQL) is used to manipulate and extract information from an SQL database. Klipfolio lets you connect to an SQL database and execute an SQL query to retrieve information to create a data source.  

Drivers

The following JDBC drivers are supported:

  • MS SQL (Microsoft SQL Server)
  • MySQL
  • Oracle Thin
  • Oracle OCI
  • Sybase SQL Anywhere
  • PostgreSQL
  • Firebird
  • DB2

ODBC drivers are not supported.

To create an SQL database data source 

 

  1. Go to Library and select the Data Source tab. Click Create a New Data Source and select SQL Database Query.
  2. Fill in the following fields
    • Host
    • Port
    • Database
    • Driver
    • Username
    • Password
    • SQL Query
  3. If accessing a database behind a firewall, click Use an SSH tunnel and type the required credentials.
  4. Click Execute Query and follow the instructions to save the data source.

For more information on connecting to an SQL database, see our Frequently Asked Questions.

Supported MS SQL versions

  • Microsoft SQL Server 2005 - only supported by version 4.0
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Azure
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016