We are excited to announce that Onvo can now pull data from your MySQL database to build AI powered dashboards and reports using SQL databases.
What is MySQL?
MySQL is an open-source relational database management system. It is popular for being very beginner friendly and has become one of the most popular database options out there
How do I activate this integration?
To activate the Onvo-MySQL-Integration, simply login to your Onvo account, go to Data sources click on “New data source”. You can now choose the option for SQL DB and click on "Connect". You will then be redirected to a configuration page where you can enter the SQL credentials and the query needed to get the view you want.
What can I do with this integration?
You can pull in data from multiple tables/databases as data sources on Onvo to build your dashboards and reports. Any datasource using the MySQL integration will be kept in sync with the underlying data to keep your dashboards live.
You can create beautiful, interactive dashboards using your MySQL data. Just ask for the kind of visualisation you want in natural language to create a widget on the dashboard. You can also ask for data pre-processing before visualisation. We also allow for questions in natural language to your data on MySQL.
If you prefer to have a tabular view of your data, you can create a report on Onvo which will then be available to download as a CSV or Excel file. And just like with a dashboard, you can ask questions from your data.
Once you are happy with your dashboards and reports, you can integrate them into your products with your easy to use SDK.
How do I create a dashboard using multiple tables?
On Onvo, you can do this in two ways:
- You can write an SQL query with a join on a single datasource so that the datasource has all the relevant data to begin with
- You can optionally create 2 separate data sources and make sure you mention the field used to correlate the data in the "fields" tab. This will enable the AI to write the necessary code to join the data without having to write complicated join queries.
If you have any questions regarding the MySQL integration or face any issues, do reach out at firstname.lastname@example.org. If there are additional integrations you would like to see on Onvo, let us know at https://onvo.canny.io/