Database Integration Adapter

Turn real-time DDS data into persistent, query-ready database records

The Database Integration Adapter is a plugin for RTI Routing Service that enables the persistence of DDS data into relational databases. It allows applications to store DDS samples from selected topics directly into databases such as MariaDB and PostgreSQL for long-term storage, analysis, and integration with enterprise systems. By leveraging the ODBC (Open Database Connectivity) standard, the adapter provides compatibility with any database system that offers an ODBC-compliant driver. This approach simplifies integration, reduces vendor lock-in, and enables flexible deployment across diverse database environments.

Features

Automatic Table Management

Generates database tables from DDS topic types and can be configured to automatically delete tables when a topic is disposed of, ensuring efficient resource management.

Flexible Data Formatting

Stores DDS samples in JSON format for easy querying and integration.

Instance History Management

Configurable sample history per instance.

ODBC Compatibility

Works with any ODBC-compliant database (custom implementation may be required), with native support provided for MariaDB and PostgreSQL.

 Multiple Endpoints

Supports simultaneous connections to multiple database servers, enabling routing of DDS data to different databases.

Benefits

Seamless Data Persistence

Effortlessly store and retrieve DDS data using standard SQL queries.

Historical Data Access

Enable analytics and reporting on DDS data with familiar database tools.

Flexible Deployment

Supports both Docker-based and native Linux installations.

Extensible

Easily adapt to new databases via ODBC.