Home
JSON compatibility
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
HCL Informix® JSON compatibility
The Informix® JSON Compatibility Guide describes how applications that use the popular JSON-oriented query language created by MongoDB can interact with data stored in HCL Informix.
About the Informix® JSON compatibility
You can combine relational and JSON data into a single query by using the Informix® JSON compatibility features.
Requirements for JSON compatibility
Informix® JSON compatibility has specific software dependencies and database server requirements.

JSON compatibility
You can use the popular JSON-oriented query language created by MongoDB to interact with data stored in HCL Informix®.
- HCL Informix® JSON compatibility
  The Informix® JSON Compatibility Guide describes how applications that use the popular JSON-oriented query language created by MongoDB can interact with data stored in HCL Informix.
  - About the Informix® JSON compatibility
    You can combine relational and JSON data into a single query by using the Informix® JSON compatibility features.
    - Getting started with Informix® JSON
      You can begin using the Informix® JSON features after installing Informix.
    - Requirements for JSON compatibility
      Informix® JSON compatibility has specific software dependencies and database server requirements.
    - MongoDB to Informix® term mapping
      The commonly used MongoDB terminology and concepts are mapped to the equivalent Informix® terminology and concepts.
    - Support for dots in field names
      Unlike MongoDB, which does not allow dots, ( . ), in JSON or BSON field names, HCL Informix® conforms to the JSON standard and allows dots. For example: {"user.fn" : "Jake"}. However, you cannot run a query or an operation directly on a field that has a dot in its name. In queries, a dot in between field names indicates a hierarchy.
    - Manipulate BSON data with SQL statements
      As an alternative to using the MongoDB API, you can use Informix® SQL to manipulate BSON data. However, if you plan to query JSON and BSON data through the wire listener, you must create your database objects, such as collections and indexes, through the wire listener. You can use SQL statements to query JSON and BSON data whether you created your database objects through the wire listener or with SQL statements.
  - Wire listener
    The wire listener is a mid-tier gateway server that enables communication between MongoDB, REST API, and MQTT clients and the Informix® database server.
  - JSON data sharding
    You can shard data with HCL Informix®. Documents from a collection or rows from a table can be sharded across a cluster of database servers, reducing the number of documents or rows and the size of the index for the database of each server. When you shard data across database servers, you also distribute performance across hardware. As your database grows in size, you can scale up by adding more shard servers to your shard cluster.
  - MongoDB API and commands
    The Informix® support for MongoDB application programming interfaces and commands are described here.
  - REST API
    The REST API provides a method for accessing JSON collections in Informix® and provides driverless access to your data.
  - MQTT protocol
    The MQTT protocol provides a method for loading JSON data in Informix®.
  - Manage time series through the wire listener
    You can create and manage time series through the wire listener. You interact with time series data through a virtual table.
  - Troubleshooting Informix® JSON compatibility
    Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter with Informix® JSON compatibility.

Requirements for JSON compatibility

Informix® JSON compatibility has specific software dependencies and database server requirements.

Java requirements

Informix® JSON compatibility requires HCL Informix® version 12.10.xC2 or later, with the J/Foundation component, which enables services that use Java™.

You must use a supported Java™ runtime environment. Java version 1.8 is recommended.

MongoDB version

Informix® JSON compatibility is based on MongoDB version 2.4, 2.6, and 3.0.

You set the version of the MongoDB API that the wire listener uses by setting the mongo.api.version parameter in the wire listener configuration file. The MongoDB API version affects the type of authentication that you can use. For example, MongoDB version 3.0 supports the MongoDB SCRAM-SHA-1 authentication method, but does not support database server authentication or connections with the REST API.

Database server requirements

JSON and BSON data is stored in sbspaces. You can specify the sbspace for JSON and BSON storage in the PUT clause of the INSERT statement. However, you must set a default sbspace with the SBSPACENAME configuration parameter. When you insert JSON or BSON data that exceeds 4 K in size, the data is temporarily saved in the default sbspace for processing before being saved in the sbspace that you specified.