1. Introduction

Note

This software is provided for experimental purposes to evaluate potential new features and gather customer feedback. These features are not officially supported and must not be used in production environments.

For more information about experimental features in Connext, see the Connext What’s New.

Database Integration Adapter is a plugin for RTI Routing Service that enables storing DDS samples from specified Topics in relational databases.

This plugin enables Routing Service to:

  • connect to database servers through Open Database Connectivity (ODBC)

  • automatically create tables based on DDS Topic types, and

  • persist sample metadata, such as reception timestamps and instance handles

You can configure Routing Service to route data from multiple DDS Domains to different database servers, enabling applications to store and query historical DDS data using standard SQL.

Database Integration Adapter uses the ODBC standard to connect to database servers, enabling compatibility with any database that provides an ODBC driver.

DDS/Database Integrated System Architecture

Figure 1.1 DDS/Database Integrated System Architecture

1.1. Key Database Integration Adapter Features

  • Automatic Table Creation: automatically creates database tables based on DDS topic types, including metadata columns for timestamps and instance tracking.

  • Flexible Data Formatting: Store DDS samples in JSON format for easy querying and integration with other applications.

  • Instance History Management: Configure how many samples per instance to keep in the database.

  • Native MariaDB and PostgreSQL Support: Out-of-the-box support for MariaDB and PostgreSQL databases with fully tested implementations. Support for other ODBC-compliant databases requires custom implementation (see the Database Support chapter).

1.2. Examples

For a complete working example and detailed walkthrough, see the Tutorial.