actian-analytics-odbc 1.0.0

Actian Analytics ODBC

Actian Analytics ODBC: Connect pyodbc applications to Actian Ingres/Vector/Analytics databases

What is it?

Actian Analytics ODBC is a Python package that provides a fast installation of Actian Client for ODBC and easy connections between pyodbc applications and Actian databases such as Ingres, Vector, and Actian Analytics Engine.

Main Features

• Contains the Actian Client SDK, no need to download it separately
• Automates installation of Actian Analytics SDK package
• Provides a simple API that extends pyodbc to provide a Python Database API 2.0 standard database connection to Actian databases.

Prerequisites

OS

Linux-x64 is supported at this time.

Python

Python 3.9 or higher is required to install and run.

ODBC Manager

You need an ODBC manager before installing this package. The simplest option on Linux is to run.

$ sudo apt install unixodbc

If you do not have an ODBC manager installed, importing the actiandb package will fail with an error.

Where to get it

The latest released version are available at the Python Package Index (PyPI).

# PyPI
pip install actian-analytics-odbc

Dependencies

• pyodbc - pyodbc is an open source Python module that makes accessing ODBC databases simple.

Platform Support

Currently only Linux x64 environments are supported.

License

[Commercial] See license inside of package

Example Usage

import actiandb
conn = actiandb.connect(
    database='databaseName',
    hostname='host-or-ip',
    port='port-or-service',
    username='username',
    password='password'
)
cur = conn.execute("SELECT * FROM region")
for row in cur:
  print(row)
conn.close()