I want to understand what different kinds of data sources can the OpenSearch dashboards plug into and generate the desired dashboards? If a client has data stored in MySQL and Prometheus, and I want to create a consolidated dashboard bringing data from these two, is OpenSearch helpful?
I have used data sources for Elasticsearch & Opensearch nodes, also connected to Prometheus. Never tried to connect to MySQL yet. Then under Observability I created a dashboard which alsa shows in the main Dashboard sections.