How to Forward Data from Aspects LRS (Ralph/ClickHouse) to an External Database

Development
1

I’m currently using the Aspects Learner Analytics plugin via Tutor, which integrates several tools like ClickHouse, Apache Superset, and Ralph (LRS) for tracking and visualizing learner activity. The system is working well, and xAPI statements are successfully stored in ClickHouse.

Now, I would like to forward or replicate the tracked data (from LRS or ClickHouse) into another external database (e.g., PostgreSQL or MySQL) for further custom analytics and integration with other systems.

Has anyone here done something similar or can guide me on:

  • Best practices for exporting or syncing xAPI data from ClickHouse or Ralph
  • Tools or methods to extract and transfer data regularly
  • Whether there’s native support for this in Vector or another part of the Aspects pipeline
2

Welcome to the community @Omer_Hameed !

@Sara_Burns is there any documentation on this?

3

I’ve also changed the category from Community to Development, @Omer_Hameed - it’s a good idea to pick a proper category for your question to get the right eyes on it! :slight_smile:

4

Responded in How to Forward Data from Aspects LRS (Ralph/ClickHouse) to an External Database - #3 by Sara_Burns