Most Data Analytics stacks comprise three stages: An ETL tool + a Data Warehouse to centralize data + a visualization or BI tool. Here we will show how to use Google Looker Studio as a BI tool, along with PostgreSQL as a Data Warehouse and Kondado as your ETL tool.
3. Creating your first integration: Now that your data destination and data sources are registered, you can create your first integration by following the platform onboarding steps.
Connecting Looker Studio to PostgreSQL:
- In the top left corner, click on “Create” and choose the option “Data Source”:
- In the search bar, look for “PostgreSQL” and select the returned option:
- Click on “Authorize” to start the connection:
- Choose a Google account to use Looker Studio with Postgres.
- In the “BASIC” option, fill in your Postgres database details and click on “Authenticate”. If your database is protected by a firewall, you need to give access to the IPs listed by Google on this page under “Notes”:
- Select the table you want to connect to Looker Studio (1), give a name to your data source (2), and then click on “Connect” (3):
- Done! Now your table will be connected to Looker Studio, where you can create reports, visualizations, or SQL queries.
Use Looker Studio with PostgreSQL and Kondado
Register PostgreSQL as a Kondado destination, replicate your sources into it, and visualize the data in Looker Studio.
Register PostgreSQL as a destination in Kondado
Log in to Kondado and add your PostgreSQL database as a destination so it can receive data from your tools.
Add the sources you want to replicate
Register the data sources (CRM, ads, e-commerce, etc.) you want to centralize, following the per-source instructions in the Kondado wiki.
Create your first pipeline
Build a pipeline from a source to PostgreSQL and run it so data lands in your database at the frequency you choose.
Allow Looker Studio to reach PostgreSQL
If your database sits behind a firewall, whitelist the Google IP ranges listed in Looker Studio's PostgreSQL connector documentation.
Connect Looker Studio to PostgreSQL
In Looker Studio, create a new data source, choose PostgreSQL, enter host, port, database, and credentials, pick the table Kondado populated, and start building reports.
