Looker Studio Setup Instructions
1. Create a new data source
From the Google Data Studio home page, click Create > Data Source.
2. Select the PostgreSQL connector published by Google
PostgreSQL is the database technology that we use to deliver your data. It is natively supported by Google Data Studio. Search for “PostgreSQL” to find the connector, then click the Select button.
3. Download an SSL certificate
Most services automatically include SSL certificates but Looker Studio does not. Download the Azure certificate here:
Remember where you save this file, because you will need it in the next step.
4. Connect Looker Studio to Reason Automation
In the next setup screen, fill out the following fields.
Host Name: [Your server]
Port: [Your port - usually 5432 or 4527]
Database: [Your database]
Username: [Your database user name]
Password: [Your database password]Your database, database user name, and database password were emailed to you during account setup. If you have lost your database credentials and need them reset, please email technical support.
Next, check the “Enable SSL” box, then upload the certificate you downloaded in Step 3.
Finally, click “Authenticate.”
5. Choose a table to work with
Select the table you want to import. Each table represents a Seller Central report that has been imported to your database, e.g. “inventory_all_listings”.
6. Congratulations!
You now have direct access to all of your Seller Central reports from within Looker Studio. Click Create Report to start working with your data right away. We recommend checking the data Type that Google assigned to each field, and updating if necessary.
