SQL for Orange

We bet you’ve always wanted to use your SQL data in Orange, but you might not be quite sure how to do it. Don’t worry, we’re coming to the rescue.

The key to SQL files is installation of ‘psycopg2‘ library in Python.

 

WINDOWS

Go to this website and download psycopg2 package. Once your .whl file has downloaded, go to the file directory and run command prompt. Enter “pip install [file name]” and run it.

 

MAC OS X, LINUX

If you’re on Mac or Linux, install psycopg2 with this.

 

SQLTable

Upon opening Orange, you will be able to see a lovely new icon – SQL Table. Then just connect to your server and off you go!

 

  • Massimo Trapani

    Hi, I have Orange 3.8.0 (git revision 58a5218) with Python 3.4. My OS is Windows 10 64 bit.
    I want to use the SQL Table function but when you run the program it sends “Please install the backend to use this widget”.
    I installed the version of Postgres 10 and I installed the component PSYCOPG2-2.6.2. Win32-PY 3.4-PG 9.5.3-release. exe.
    I also tried with the version psycopg2-2.6.2. Win-AMD64-PY 3.4-PG 9.5.3-release. exe but the result does not change.
    Could you help me?

  • Juris Cielens

    How about Oracle 12c?

    • John Collins

      Juris, were you able to form a connection to Oracle 12c? I am also hoping to do so

      • Juris Cielens

        I built an oracle sql widget that uses cx_oracle and submitted to orange-prototypes. Almost accepted.

  • Sagar

    Hi , I have Orange 3.3.7 installed on my Windows 7 (64 bit) machine. Could you please help me with correct and supported version of psycopg2 package.

    I tried all three 64 bit package available on http://www.lfd.uci.edu/~gohlke/pythonlibs/#psycopg but getting below error

    “psycopg2-2.6.2-cp27-cp27m-win_amd64.whl is not a supported wheel on this platform.”

    Please help me

    • Ajda Pretnar

      Dear Sagar, the proper wheel for my platform works just fine. Be careful to use a wheel for Python 3 (cp34 or cp35) as Orange 3.3.7 runs on Python 3.
      I hope you’ve managed to solve your issue.

  • Ajda Pretnar

    It’s being improved as we speak. I highly recommend you to give a look at 2UDA package for big data analytics. http://2ndquadrant.com/en/resources/2uda/