Connection Experience

Please read this first.

When using cloud tools like Database Browser, often establishing connection to your database would be a challenge.

Note that Database Browser is a cloud tool and hence you are establishing a server to server connection between Database Browser (running in Google Cloud) and your database in Internet/ any cloud platform.

So it is important to understand what is required to establish the connection. Once you have established connection, things are going to be smooth with Database Browser.

With Database Browser, we are trying to bring you a best connection experience.

• Your database is running on a cloud platform or your database server is connectable from Internet

• You have whitelisted the access to G Suite platform IP addresses. Please read below for details

To Connect above Databases you have to provide below mentioned elements

• • Host Name/ IP Address.

  • Database Name.

  • User Name

  • Password

To Connect Cloud SQL Databases you have to provide below mentioned elements

• • Instance Name

    • Cloud SQL instances are SQL databases hosted in Google's cloud.

  • Database Name.

  • User Name

  • Password

To get the instance name, 

• • goto https://console.cloud.google.com/

  • choose your project

  • select SQL under Storage from the side navigation menu

  • click on the instance

  • See below image

Important Note: To access Google Cloud SQL, your logged in Google account (email)  must have access to the Google cloud project. Please check "IAM & admin" section on the Google cloud project for verifying this.

Without this, Database Browser cannot connect with Google Cloud SQL.

To Connect mLab - Mongo DB  you have to provide below mentioned elements.

• • • Database Type

    • API KEY 

      • To connect with mLab - Mongo DB, you will need to enable API Access with mLab. Once the API Access is enabled, mLab provides an API key.

    • Select Database

To Connect Big Query you need to provide below mentioned elements.

• • Create Project inside your Google Clould.

  • Copy the Project Id of the created project.

  • Select Database Type

  • Insert Project Id

  • Select Data set

Important Note: To access Google Cloud Datastore/ Firestore/ Big Query, your logged in Google account (email)  must have access to the Google cloud project. Please check "IAM & admin" section on the Google cloud project for verifying this.

Without this, Database Browser cannot connect with Google Cloud Datastore/ Firestore/ Big Query.

I get error when connecting to Google Cloud SQL inspite of giving all connection information correctly. What is wrong?

Please check whether Google Cloud SQL is configured to be connected from Apps Script (G Suite script on which Database Browser is written). Whitelisting is required for Google Cloud SQL and other databases,

Whitelisting for Google Cloud SQL

Important Note: Without whitelisting Database Browser add-on cannot connect to your database

Whitelisting required for Other Databases (MySQL, MS SQL Server, Oracle)

Important Note: Without whitelisting Database Browser add-on cannot connect to your database

Important: Refer https://www.gstatic.com/ipranges/goog.txt for all the ip ranges that needs to be whitelisted in your database to allow connection.

Refer "Setup for Google Cloud SQL" section in https://developers.google.com/apps-script/guides/jdbc for full details on whitelisting.

Ip range for Premium Databases

Premium Databases are connecting through Jivrus Infrasturture hence it requires the following IP range should be whitelisted. 

35.238.134.134 

As Premium Databases are not connectable from the GSuite environment, you don't need to whitelist Google IP ranges.

How do I specify a port in the connection?

You can specify the port in the IP address field with :<port> as a suffix. Please see the sample below.

Can I connect to databases running in my machine (localhost) or in LAN?

Remember that Google Sheet and the add-on is running in the cloud server. To connect a database from Database Browser add-on, 

• the machine / instance where your database is running must be connected with Internet 

• IP address / domain of the machine is exposed as public static IP and 

• access to the port is enabled in the database. 

If you make these configuration in your database machine, it can be connected.

When I copy the Google Sheet, I am not seeing any of the connection in the copied Google Sheet. Why?

When you copy the Google Sheet, the connection details are not copied into new Google Sheet. This is implemented purposely to avoid security issues on unauthorised access from anyone who copies your Google Sheet. So, on the new sheet you will need to configure the connections again.

MySQL server stops working recently/not connecting. why? 

Google has updated the Google Workspace database connectivity library (Apps Script JDBC Driver) for Microsoft SQL Server recently to version 7.2.1. This requires the Microsoft SQL server to be supporting TLS 1.2 and stopped working for TLS 1.0 and 1.1. Please see the issue related to this in Google Issue Tracker.

Recommended Action:  You need to upgrade your Microsoft SQL server to a version that supports TLS 1.2. Once it is upgraded, this issue gets resolved.

When connecting to the PostgreSQL database, I encountered a connection issue. I have provided all the credentials except for SSL JSON. What is the SSL JSON, and what value should be given for a smooth connection?