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:

https://cacerts.digicert.com/DigiCertGlobalRootG2.crt.pem

Remember where you save this file, because you will need it in the next step.

4. Connect Google Data 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 Google Data 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.