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.
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.
Creating a time series through the wire listener
You can create time series with the REST API or the MongoDB API through the wire listener. You create time series objects by adding definitions to time series collections.

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.
  - 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.
    - Creating a time series through the wire listener
      You can create time series with the REST API or the MongoDB API through the wire listener. You create time series objects by adding definitions to time series collections.
      - Time series collections and table formats
        You can add, view, and remove documents from the time series collections with REST API and MongoDB API methods to create and manage your time series. You must use a specific format to create time series tables and virtual tables that are based on time series tables.
      - Example: Create a time series through the wire listener
        This example shows how to create, load, and query a time series with the MongoDB API or the REST API through the wire listener.
    - Example queries of time series data by using the wire listener
      These examples show how to query time series data by using the MongoDB API or the REST API.
    - Aggregate or slice time series data
      You can use the MongoDB aggregation pipeline commands to aggregate time series values or return a slice of a time series.
    - Loading time series data with the MQTT protocol
      You can load JSON documents into time series through the MQTT wire listener. The MQTT wire listener publishes data directly to the time series base table by internally running time series loader routines.
  - Troubleshooting Informix® JSON compatibility
    Several troubleshooting techniques, tools, and resources are available for resolving problems that you encounter with Informix® JSON compatibility.

Creating a time series through the wire listener

You can create time series with the REST API or the MongoDB API through the wire listener. You create time series objects by adding definitions to time series collections.

Before you begin

You must understand time series concepts, the properties of your data, and how much storage space your data requires. For an overview of time series concepts and guidance on how to design your time series solution, see Informix® TimeSeries solution.

Perform the following prerequisite tasks:

Connect to a database in which to create the time series table. You run all methods in the database.
Configure the wire listener for the MongoDB API or the REST API. For more information, see Configuring the wire listener for the first time.
Configure storage spaces for your time series data.

Procedure

To create a time series through the wire listener:

Choose a predefined calendar from the system.timeseries.calendar collection or create a calendar by adding a document to the system.timeseries.calendar collection.
Create a TimeSeries row type by adding a document to the system.timeseries.rowType collection.
The row type must include one BSON column for the JSON data.
Create a container by adding a document to the system.timeseries.container collection.
Create a time series table with the time series table format syntax.
Instantiate the time series by creating a virtual table with the time series virtual table format syntax.
Load time series data.
You can use the REST API or the MongoDB API to load time series data through a virtual table. You can use the MQTT protocol to load time series data into the time series base table.

What to do next

After you create and load a time series, you query the data though the virtual table with MongoDB and REST clients.