How to install the PyODBC package for TIBCO Data Science Team Studio Python Notebooks?

How to install the PyODBC package for TIBCO Data Science Team Studio Python Notebooks?

book

Article ID: KB0072310

calendar_today

Updated On:

Products Versions
Spotfire Data Science Team Studio 6.5.0, 6.6.0

Description

Installing pyodbc on Centos / RHEL can be challenging if you forget to have the development library. This article cover pre-requisite libraries and steps to install pyodbc library.

Issue/Introduction

This article covers pre-requisite libraries and steps to install pyodbc library in TIBCO Data Science Team Studio Python Notebooks.

Environment

Centos / RHEL.

Resolution

On Centos / RHEL server following libraries needed to be installed before installing the pyodbc library.
Log in to the command line of the Python notebook instance and use the following commands to install them:

$ sudo yum install unixodbc-dev
$ sudo yum install unixODBC unixODBC-devel
$ sudo yum install epel-release
$ sudo yum install gcc-c++
$ sudo yum install python3-devel

Navigate to /opt/conda/envs/python3/bin on the Notebook server and install the pyodbc package using the below command:
---------
./pip install pyodbc 
---------

Note: This will install the pyodbc package for all Team Studio notebook users.

Powered by Wolken Software