Blog of Jivrus Technologies

Databases supported in Database Browser!!! Database Browser is a Google GSuite add-on that makes Google Sheet an awesome new way of browsing your database. The Key Features of Database Browser are Manage Connections - Create, test and save connections to databases on the Internet and cloud. Manage Queries - Build, execute, save queries and query results into Google Sheet. Edit - Edit the data in the database directly from Google Sheet and saving into the database.  Types of Databases in Database Browser There are two types of Databases in Database Browser they are  Standard Database Premium Database Standard Database: Standard Databases refer to the most commonly used databases. The standard databases that are supported in Database Browser are MySQL Microsoft SQL Server Oracle Database Google Cloud SQL mLab MongoDB BigQuery Firestore Datastore Premium Database: Premium Databases are not typically connectable from Google Workspace environment using Apps Script. But a special im...

Google Cloud Datastore You can now connect Google Sheet with Datastore using  Database Browser  add-on and build a query from the wizard, execute query and present results directly into Google Sheet.  Getting  Datastore   data into Google Sheet is NO more complicated.  Users  can now just follow the steps below Step 1 : Create a  Datastore  connection authorized with Google sign-in button. Step 2 : Provide project-id of the  Datastore  project (refer Google Cloud Console), test and save  the connection. Step 3 :  Build, Query and Present the results into Google Sheet as normally as you do with any other data sources. Check more documentation at  how it works . Check out the current list of  supported databases  by Database Browser.                                    ...

You can now connect Google Sheet with Firestore using  Database Browser  add-on and build query from wizard, execute query and present results directly into Google Sheet.  Getting Firestore  data into Google Sheet is NO more complicated.  Users  can now just follow the steps below Step 1 : Create a Firestore connection authorized with Google sign-in button.    Step 2 : Provide project-id of the Firestore project (refer Google Cloud Console), test and save  the connection. Step 3 :  Build, Query and Present the results into Google Sheet as normally as you do with any other data sources. Check more documentation at  how it works . Check out the current list of  supported databases  by Database Browser.                                                     ...

Ever since we launched Database Browser add-on, there has been requests to add support to various types of databases from Google Sheet. We add new database types as and when possible to Database Browser. mLab:MongoDB is our latest addition. You can now connect Google Sheet with mLab:MongoDB using Database Browser add-on and build query from wizard, execute query and present results directly into Google Sheet.  Getting mLab:MongoDB  data into Google Sheet is NO more complicated.  Our Pro plan subscribers can now just follow the simple steps below: Step 1 : Enable API access in  mLab:MongoDB and get API Key Step 2 : Create a database connection to  mLab:MongoDB from Database Browser with the API Key. Step 3 : Build, Query and Present the results into Google Sheet as normally as you with any other SQL database connection using Database Browser add-on. Check more documentation at  how it works . Check out current list of ...