Launch update: Google firestore integration

We are excited to announce that Onvo can now pull data from your Firestore database to build AI powered dashboards and reports using Google Firestore.

What is Firestore?

Cloud Firestore is a NoSQL document database that lets you easily store, sync, and query data for your mobile and web apps - at global scale.

How do I activate this integration?

To activate the Onvo-Firestore-Integration, simply login to your Onvo account, go to Data sources click on “New data source”. You can now choose the option for Firestore DB and click on "Connect". You will then be redirected to a configuration page where you can enter the Firestore credentials and the collection 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 Firestore integration will be kept in sync with the underlying data to keep your dashboards live.

You can create beautiful, interactive dashboards using your Firestore 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 Firestore.

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 by creating 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 Firestore integration or face any issues, do reach out at info@onvo.ai. If there are additional integrations you would like to see on Onvo, let us know at https://onvo.canny.io/