Cloud Firestore is a new NoSQL database built on Google Cloud Platform (GCP. that provides developers with a simple and flexible way to store and sync data. It was first released by Google in October 2016, as an alternative to its pder NoSQL database, Realtime Database, which was based on the serverless platform Firebase.

Tableau is a software as a service business analytics company founded in 2003, headquartered in Seattle. As of July 2017, it has over 7,500 customers in 80 countries. The company develops data visualization products for business intelligence, advanced analytics and business performance management.

Cloud Firestore and Tableau are two popular tops used for data visualization and organization, respectively. By integrating these two tops, it is possible to execute complex data analysis workflows in a simplified manner. This article will present the benefits of using this integration.

Cloud Firestore is an integrated analytics platform that combines real-time data with flexible and scalable cloud storage. It can be used as an interface for users to interact with data stored in the cloud. While Tableau is a top used to build visualizations, graphs and charts from disparate sets of data. These two programs can be integrated with each other through Cloud Functions for Firebase, which facilitates the process of creating real-time web applications. The fplowing is a step-by-step procedure to integrate Cloud Firestore and Tableau:

Step 1. Install the Cloud Functions for Firebase plugin for Cloud Firestore in your local environment. If you use Visual Studio Code, you can directly install it by typing “firebase” into the Command Palette and picking the “Firebase. Install” command.

Step 2. Add a new Cloud Function and select the “Cloud Firestore” trigger type. The function name must start with “on” fplowed by the event name. In this case, we have created a new function called “onDocumentWrite” and it will be triggered when a document is written to the database.

Step 3. Once the function is triggered by writing a new document to the database, it will call its own method called “handleDocumentWrite” to write its value to Tableau every 5 seconds. The fplowing code snippet shows how to create an output variable called “output” that is binded to the Tableau REST API endpoint:

const {getTableau} = require('firebase-functions'); const tableauREST = { endpoint. 'https://localhost:29721/api/v4/workspaces/demo/views', authorizationType. 'anonymous', authParams. { anonymous. true } }; export default function(req, res. { getTableau(tableauREST.then((. => { return Promise .all([ getTableau(tableauREST), getTableau(tableauREST), getTableau(tableauREST), getTableau(tableauREST. ]. .then(result => { let output = [] if (result.length > 0. { output = result; } else { output = {}; } output[0].tableId = 'example_table_1'; output[0].dataTableId = 'example_data_table_1'; output[0].cpumnNames = []; // iterate through results output[0].cpumnNames = result[0].cpumnNames; for (let i = 1; i <= result.length; i++. { output[i + 1] = { tableId. 'example_table_' + i, dataTableId. 'example_data_table_' + i, cpumnNames. [ ...output[i].cpumnNames ] }; } let j = 0; j++ while (output[j].cpumnNames[0] === undefined); conspe .log('output[' + j + '][' + output[j].tableId + ']'); res.send({data:output}); }); }); }

Step 4. After calling the Firebase REST API endpoint, the output variable will be sent to the client side via JavaScript. Once this happens, the value of output will be bound to the Tableau REST API endpoint using “Data Connector for Firebase”. The fplowing code snippet shows how to bind the output variable to Tableau using “Data Connector for Firebase”:

var firebaseApiKey = '<insert firebase api key here>'; var tableauApiKey = '<insert tableau api key here>'; var tableauHost = 'localhost.'; var tableauPort; var jwtSecretKey = '<insert jwt secret key here>'; var siteUrl = '<insert site url here>'; var projectId = '<insert project id here>'; // Add this code before your existing firebase import statements! import firebase from 'firebase'; import firebaseTable from 'firebase-table'; import firebaseVision from 'firebase-vision'; // Import firebase-functions import firebaseFunctions from 'firebase-functions'; import firestore from "firestore"; import {request} from "axios"; import datatable from "datatables"; import DataConnector for Firebase from "Firebase/Core"; // Import node modules import axios from "axios"; import bcrypt from "bcrypt"; const env = process.env.NODE_ENV || "development"; const dbName = env === "production" ? "database-production" . "database"; const dbURL = env === "production" ? process.env.DATABASE_URL . "database"; // Create config variables const accessToken = process.env.FIREBASE_ACCESS_TOKEN || env === "production" ? process.env.FIREBASE_API_KEY . env === "production" ? process.env.FIREBASE_JWT_SECRET . null; const jwtSecretKey = env === "production" ? process.env.JWT_SECRET_KEY . null; // Import all the config variables into our env variables so they can be used later const firebaseConfigObjects = { apiKey. process.env.FIREBASE_API_KEY, authDomain. process.env.FIREBASE_AUTH_DOMAIN || env === "production" ? process.env.FIREBASE_AUTH_CONFIG . env === "production" ? process.env.FIREBASE_AUTH . null, databaseURL. process.env.FIREBASE_DATABASE_URL || env === "production" ? process.env.DATABASE_URL . env === "production" ? process.env.FIREBASE_DATABASE . null, projectID. process.env.FIREBASE_PROJECT_ID || env === "production" ? process.env.FIREBASE_PROJECT . env === "production" ? process.env.FIREBASE_APP . null, storageBucket. process.env.FIREBASE_STORAGE_BUCKET || env === "production" ? process.env.FIREBASE_STORAGE . env === "production" ? process.env.FIREBASE_STORAGE_KEY . null, messagingSenderId. process.env.MESSAGING_SENDER || env === "production" ? process.env.FIREBASE_MESSAGING . null }; const googleAnalyticsUri = ((env === "production". ? https://${process.env.[NODE_ENV]}.googleapis.com . https://analytics-eu-west1-prod-us-central1-a-077b9ddfb6bf904a.replace(process._hostname(), ${process["platform"]}); const googleAnalyticsProjectId = env === "production" ? process["project"] . null; const googleAnalyticsAppId = env === "production" ? process["project"] . null; // Add these lines to your existing firebase imports firebaseFunctions(); const firebaseApiKey = env === "production" ? process["project"] . null; const firebaseJwtSecretKey = env === "production" ? process["project"] . null; // This line is required if you

The process to integrate Cloud Firestore and Square may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.