Metadata-Version: 2.1
Name: PyInformix
Version: 0.2.0
Summary: Experimental SQLAlchemy dialect for IBM Informix
Home-page: https://github.com/homedepot/pyinformix
Author: Mike Phillipson
Author-email: MICHAEL_PHILLIPSON1@homedepot.com
License: Apache 2.0
Platform: UNKNOWN
Description-Content-Type: text/markdown
License-File: LICENSE

# PyInformix

Experimental SQLAlchemy dialect for IBM Informix

## Installation

```
pip install PyInformix
```

## Usage

### Connect via ODBC*

```python
from sqlalchemy.engine import create_engine

engine = create_engine('informix+ibm_db://{username}:{password}@{hostname}:{port}/{database}')
```

*Requires [IBM Data Server Driver for ODBC and CLI software](https://www.ibm.com/docs/en/db2/11.1?topic=drivers-obtaining-data-server-driver-odbc-cli-software).

### Connect via JDBC*

```python
from sqlalchemy.engine import create_engine

engine = create_engine('informix+ifx_jdbc://{hostname}:{port}/{database};INFORMIXSERVER={server};delimident=y;user={username};password={password}')
```

Export CLASSPATH environment variable:

```
CLASSPATH=/path/to/informix_jdbc_x_x_x_x/jdbc-x.x.x.x.jar:/path/to/informix_jdbc_x_x_x_x/bson-x.x.x.jar
```

*Requires [IBM Informix JDBC Driver](http://www.ibm.com/software/data/informix/tools/jdbc) and [Java Runtime Environment (JRE)](https://www.java.com/en/download/).

## License

Distributed under the [Apache, version 2.0 license](https://opensource.org/licenses/Apache-2.0).

