Is it possible to connect Google firebase, AdMob apis with Microsoft Azure data factory or synapse analytics

Question

I want to get the data from all my sources into one place i.e. Azure data lake gen2. Firebase database and AdMob are two of the sources of data and I want to make the connection of these sources with ADF to move the data into Azure.

I have been through all the official documentation of both firebase and admob api, but it doesn't helped. I want to know if it is possible to make connection or not. If it is possible then how should i do it?

Your assistance in this regard will be highly appreciated. Thanks in advance.

Answer 1

@BR

Thanks for using MS Q&A platform and posting your query.

Yes, it is possible to connect Firebase and AdMob to Azure Data Lake Gen2 using Azure Data Factory (ADF). Here's how you can achieve this:

1. Setting up Firebase and AdMob:

• Firebase: Enable the Firebase Realtime Database API and Cloud Storage API in your Firebase project. You'll find instructions on enabling APIs in the Firebase console documentation https://firebase.google.com/docs/projects/api/workflow_set-up-and-manage-project. Make sure to note down the project ID and credentials for later use in ADF.
• AdMob: AdMob doesn't have a separate API for data access. You'll need to use the Firebase Realtime Database to access AdMob data. AdMob reporting data is stored in the Firebase Realtime Database.

2. Connecting to Firebase and AdMob data in ADF:

• Firebase Realtime Database: Use the Google Cloud Pub/Sub connector in ADF to connect to your Firebase Realtime Database. You'll need to create a service account with the Firebase Realtime Database Admin role and grant it access to your Pub/Sub topic. Configure the ADF pipeline to listen to the relevant Pub/Sub topic that replicates your Firebase Realtime Database data.
• AdMob data: Since AdMob reporting data resides in the Firebase Realtime Database, you can access it using the same Pub/Sub connection established for Firebase Realtime Database. Configure your ADF pipeline to filter the data based on the specific path within the Realtime Database where AdMob reports are stored.

3. Transferring data to Azure Data Lake Gen2:

• Use the Azure Data Lake Storage Gen2 connector in ADF to transfer the data received from Pub/Sub to your Azure Data Lake Gen2 storage.
• Configure the ADF pipeline to define the schema and format (e.g., CSV, Parquet) for the data landing in Azure Data Lake Gen2.

Additional Resources:

• Azure Data Factory connectors documentation: https://learn.microsoft.com/en-us/azure/data-factory/
• Google Cloud Pub/Sub connector for ADF: https://learn.microsoft.com/en-us/fabric/data-factory/connector-google-cloud-storage
• Azure Data Lake Storage Gen2 connector for ADF: https://learn.microsoft.com/en-us/fabric/data-factory/connector-azure-data-lake-storage-gen2-overview

By following these steps, you can establish a connection between Firebase, AdMob, and Azure Data Lake Gen2 using ADF to centralize your data for further analysis

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.