How to store topic data to external database automatically？

[saiyxin]

Hello，

I want to store all the topic data in order to replay someday，is there anyway to store all the topic data to database automaticlly？ Can I use some QoS Profiles to realize this function，or is there any other way？

Best regards.

[ismaelrti · Accepted solution]

Hi Saiyxin,

For that exact purpose exists Recording Service and Replay. Those tools record the samples and allow to replay them automatically with Replay. They are very customizable and flexible allowing even converting data in different formats. They are not included with the DDS LabVIEW Toolkit. They are part of RTI Connext DDS.

You only need to run Recording service, start transfering data using the DDS Toolkit as usual (Recording Service is a separate tool running in the backgroud) once you finish you can replay the data exactly as if the original scenario if you like or you can, for example, customize the replay speed among other functionalities.

Have a look at the following resources for more details:

- https://www.rti.com/products/is/recording-service

- https://info.rti.com/hubfs/Datasheets/RTI_Datasheet_10005_Recording-Service_V3_Web_0718.pdf

- https://www.rti.com/podcast/recording-service-record-analyze-replay-real-time-data

- https://community.rti.com/static/documentation/connext-dds/6.1.0/doc/manuals/connext_dds_professiona...

[saiyxin]

Hi，ismaelrti:

I wonder where the data is stored when the data volume is large. Dose it has an internal database or I need to config an external database to store them？And can I use Labview to enable this recording service and then show the replay panel when I need，cause I want to develop an application using Labview.

[ismaelrti]

The database location can be customized. The recording service has a built-in SQLite system but it allows using custom adapters for using different databases systems (adapters written in C).

Recording service is a separate application. You can launch it from LabVIEW using the System Exec VI. It also can be controlled remotely through command line, so in that case, you can also use System Exec VI for doing it. Have a look at the Recording Service User's Manual "Remote Administration" (Same for Replay, see it in the left column) and check if this can adapt to what you need.