IBM Informix JSON compatibility

Applications that use the popular JSON-oriented query language created by MongoDB can interact with data stored in IBM® Informix®.

This information is intended for application programmers.

These topics are taken from IBM Informix JSON Compatibility Guide.

What's new in JSON, Version 12.10
This publication includes information about new features and changes in existing functionality.
About the JSON compatibility
You can combine relational and JSON data into a single query by using the JSON compatibility features.
Wire listener
The wire listener is a mid-tier gateway server that enables communication between MongoDB, REST API, and MQTT clients and the database server.
JSON data sharding
You can shard data with IBM 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 support for MongoDB application programming interfaces and commands are described here.
REST API
The REST API provides a method for accessing JSON collections in and provides driverless access to your data.
MQTT protocol
The MQTT protocol provides a method for loading JSON data in .
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.
Monitoring collections
You can use the IBM OpenAdmin Tool (OAT) for Informix to monitor collections in the database.
Troubleshooting JSON compatibility
Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter with JSON compatibility.