SQL Table widget supports PostgreSQL and MSSQL databases.

The components of Orange intended for work with SQL datarequire the following extensionson the PostgreSQL server (>= 9.5), where the data is stored:

• quantile -http://pgxn.org/dist/quantile

  It can be installed with pgxn client:

  pgxn install quantilepgxn load -d mydb quantile

  Or manually (after fetching the source from the link above):

  make installpsql dbname -c "CREATE EXTENSION quantile"

• tsm_system_time

  Extension is part of the PostgreSQL contrib.

  cd contrib/tsm_system_timemake installpsql dbname -c 'CREATE EXTENSION tsm_system_time;'

Install pymssql module.

pip install pymssql

If using Python3.6, you might have issues with availability of wheels.

Or run intofatal error: 'sqlfront.h' file not found

You would needFreeTDS which you can install:

• On Debian-based systems:apt install freetds-dev
• On OSX:brew install freetds

If the error persists install pymssql from git:

pip install Cython

pip install git+https://github.com/pymssql/pymssql.git