General Flow#
The DiMEC-LCA platform integrates with the following components: Grafana, MySQL, Laravel and Keycloak. Below is the diagram describing the flow in the DiMEC-LCA toolkit application.
1. Grafana#
Grafana, as shown in the figure below, serves as a visualization and dashboarding tool. Key features include:
MySQL Integration: Grafana seamlessly connects to a MySQL database, allowing users to visualize and analyze data in real time.
Infinity Plugin for CSV Uploads: The Infinity plugin facilitates the direct upload of CSV files into Grafana, making it easy to work with external or static data sources.
Variable Plugin for Dynamic Data Interaction: This plugin enables users to select variables for automatic calculations, enhancing flexibility and interactivity. Users can choose variables via dropdown lists, buttons, or radio buttons, dynamically adjusting the displayed data to suit their needs.
Data Manipulation Plugin for Database Updates: With this plugin, users can modify existing MySQL data directly from Grafana dashboards in an intuitive and straightforward manner, enabling real-time updates and interaction with stored data.
2. MySQL#
MySQL is a scalable relational database system that makes it easy to store and manage structured data. It keeps data safe and accessible while ensuring smooth performance. Moreover, it helps maintain data integrity and ensures everything works seamlessly with the rest of the system.
3. Laravel#
Laravel is a PHP framework that the administrator uses to manage the database efficiently. Key features include:
Data Insertion: By using Laravel’s seeding features, the administrator can quickly insert data into the MySQL database, creating a foundation for smooth querying and analysis.
Table Creation: Laravel’s migration system makes it easy for administrators to create and update database tables. This helps keep the database consistent, organized, and scalable.
4. Keycloack#
Keycloak, as shown in the figure below, is responsible for managing identity and access control, providing essential authentication and authorization services to ensure secure user access to the platform’s resources. As part of this implementation, Single Sign-On (SSO) has been integrated into Grafana through Keycloak, enabling users to authenticate seamlessly within a centralized environment. This approach enhances security, streamlines user management, and simplifies access across the platform.
