Crate.io, developer of CrateDB, is launching the CrateDB Event Hubs Connector, a new capability that allows users to route data from Microsoft Azure IoT Hub or Event Hubs directly to CrateDB.
“The success of large-scale Industry 4.0 initiatives depends completely on users’ systems’ abilities to ingest millions of data points from connected equipment and for them to analyze and action that data in real time,” said Holger Mueller, vice-president and principal analyst at Constellation Research. “Traditional SQL databases cannot support time series workloads, legacy time series databases lack the flexibility we need and NoSQL is too risky and complex. The market needs a perfect balance among ease-of-use, rapid ingestion, query flexibility and scale.”
CrateDB lets users of Microsoft IoT Hub put data to work by providing time series monitoring capabilities while enabling data analytics on the extremely large, long-term, complex data sets seen in Industrial IoT.
The ability to scale, integrate, and extend CrateDB time series data enables users to gain much more insight from machine data and take action quicker to improve operations and profitability.
Being able to easily integrate data from other HR, ERP and CRM applications provides context for time series data.
Microsoft Azure features scalable services for securely streaming machine data from edge devices into the cloud.
A new Event Hubs Connector in CrateDB makes it even easier to integrate and analyze IoT data in real time in order to monitor, predict, or control the behavior of smart systems.
The Connector can scale to accept millions of telemetry data readings per second from Event Hubs or IoT Hub and insert it into the CrateDB SQL DBMS.
Dynamic Schema Support enables messages of any structure to be inserted into CrateDB, which updates the schema on-the-fly making it easy to integrate new types of connected devices.
The flexibility of CrateDB -- with its ability to process time series, geospatial, search and nested JSON with SQL -- simplifies smart systems design by eliminating the need to use a variety of specialized databases together.
Industrial IoT stacks often feature multiple, specialized databases -- for example, Azure SQL for relational data, Azure Cosmos DB for JSON and InfluxDB or Azure Time Series Insights for time series. CrateDB, with its unique distributed SQL-on-NoSQL architecture, enables it to do the work of all three of those databases. As a result, database hosting and database administration costs are much lower for CrateDB users.
For more information about this news, visit https://crate.io/.