Integrating Firebase Data with Bold BI using Web API connector: Step-by-Step Guide
Integrating Firebase data with Bold BI allows you to create insightful dashboards and reports directly from your Firebase database. Here’s how you can connect your Firebase data to Bold BI using the Web API Connector.
Step 1: Create a New Project on Google Cloud
Before connecting, you need to have a project in Google Cloud.
- Navigate to Google Cloud and select Add Project.
- Enter a name for the project you’re creating and proceed with the project setup.
Step 2: Work with Your Real-time Database
After setting up your project on Google Cloud:
- Go to the Navigation menu and click on Real-Time Database.
- Under the provided options, select Import JSON.
- Choose the JSON file you want to import and then click Import to add the records to your database.
Step 3: Copy the Database URL
Once your JSON records are imported:
- Your data should now be displayed.
- Within your database view, find and copy the unique link that refers to your data.
Step 4: Open Bold BI Web API Connector
With the link copied:
- Open your Bold BI dashboard.
- Go to the Web API Connector to establish a new data connection.
Step 5: Configure the Data Source
Setting up your data source involves:
- Naming the data source for easy identification.
- Pasting the copied link into the URL section.
- Appending “.json” at the end of the URL (this is important for Firebase connections).
Step 6: Preview and Connect
Finally:
-
Click on Preview and Connect.
-
Bold BI will now connect to your Firebase database, allowing you to perform further operations and create dashboards.
-
Save the Data source.
By following these steps, you will be able to seamlessly fetch real-time data from your Firebase database into Bold BI, enabling you to visualize and analyze your data effectively.
Additional References
