Google Data Studio "is a free tool that turns your data into informative, easy to read, easy to share, and fully customizable dashboards and reports." Learn more about it here.
"Quick Base is an application development platform that unites business and IT teams by enabling problem solvers of any technical background to work together to safely, securely and sustainably create an ecosystem of applications. Quick Base helps businesses accelerate the continuous innovation of unique processes by enabling citizen development at scale across one common platform." Learn more about it here.
Now you can use both together with QBGDS Connect, which stands for Quick Base Google Data Studio Connect.
The QBGDS Conenctor provides similar functionality as the Quick Base Power BI connector supported by Quick Base, just into a different business inteligence tool:
- Authenticates with specified Quick Base applications by using user tokens
- Quickly refreshes both large and small data sets from Quick Base
- Automatically updates both data and report columns.
And, supports a lot of the same use cases.
For example, you can use these features to add power to the following Quick Base use cases:
- Create and share report and chart types that are not supported by native Quick Base
- Merge data from multiple sources to analyze processes that span across multiple systems
- Convert timestamps to dates and times that are easy to read
Note: For Quick Base reports that are being used by Power BI, we recommend caution when making changes to the reports' configuration because changes may inadvertently break the Power BI features dependent on those reports.
To use QBGDS Connect:
- Use the link you were provided to create a new data source in Google Data Studio with the connector
- Provide the connector a user token as the "key" for authentication -- note this must have access to the application and table you expect to use in Google Data Studio
- QBGDS will then prompt for more information -- (A) Enter a realm hostname for your Quick Base account (enter the full URL including quickbase.com), and (B) Enter a table ID (the dbid of a table).
- Use as a normal Google Data Studio data connector. Certain field types are not supported (like multi-text, vCard, etc.) and will not be returned in Data Studio.
Realm
A Quick Base realm is a logical slice of Quick Base dedicated to your organization that you control. Realms are defined using a DNS sub-domain with the format: https://customername.quickbase.com.
Table ID / DBID
Quick Base uses an alphanumeric database ID, or DBID, to uniquely identify each app and each table on our platform. You can find the DBID of a table in the address bar of your browser when you're looking at any page of the table. The home page of all Quick Base applications has a DBID that does not refer to any of the tables in the application. You can view a record or a report on one of your tables, then look in your browser's address bar to see that table's DBID. The DBID is after the "https://mycompany.quickbase.com/db/"; and before the first question mark "?" if there is one. For example the dbid in the following URL:
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=ej&rl=bjd
is
6ewwzuuj
Having trouble with QBGDS Connect? Post an issue here, and we’ll help you sort it out.
Copyright 2020 smblytics LLC