This is the implementation of the IBM Informix data handler for MindsDB.

IBM Informix is a product family within IBM’s Information Management division that is centered on several relational database management system (RDBMS) offerings. The Informix server supports object–relational models and (through extensions) data types that are not a part of the SQL standard. The most widely used of these are the JSON, BSON, time series, and spatial extensions, which provide both data type support and language extensions that permit high-performance domain-specific queries and efficient storage for data sets based on semi-structured, time series, and spatial data.

Prerequisites

Before proceeding, ensure the following prerequisites are met:

  1. Install MindsDB locally via Docker or use MindsDB Cloud.
  2. To connect IBM Informix to MindsDB, install the required dependencies following this instruction.
  3. Install or ensure access to IBM Informix.

Implementation

This handler is implemented using IfxPy/IfxPyDbi, a Python library that allows you to use Python code to run SQL commands on the Informix database.

The required arguments to establish a connection are as follows:

  • user is the username associated with database.
  • password is the password to authenticate your access.
  • host is the hostname or IP address of the server.
  • port is the port through which TCP/IP connection is to be made.
  • database is the database name to be connected.
  • schema_name is the schema name to get tables.
  • server is the name of server you want connect.
  • logging_enabled defines whether logging is enabled or not. Defaults to True if not provided.

Usage

In order to make use of this handler and connect to the Informix database in MindsDB, the following syntax can be used:

CREATE DATABASE informix_datasource
WITH
    engine='informix',
    parameters={
      "server": "server",
      "host": "127.0.0.1",
      "port": 9091,
      "user": "informix",
      "password": "in4mix",
      "database": "stores_demo",
      "schema_name": "love",
      "loging_enabled": False
    };

You can use this established connection to query your table as follows:

SELECT *
FROM informix_datasource.items;

This integration uses IfxPy. As it is in development stage, it can be install using pip install IfxPy. However, it doesn’t work with higher versions of Python, therefore, you have to build it from source.