Connect to Oxla Cloud

  1. You need a running cluster to connect it with Looker.

    • If you don’t have one, create one by following the steps here.
    • If you already have an existing cluster that you want to connect, click the three dots next to the cluster and click Connect.
  2. You will see the following details in the Oxla Cloud Connect view:

    • Address: The host’s address to be used to connect with Looker.
    • Port: The port number.
    • Username: The username of the user/role that has access to the cluster.
    • Password: The password that you set up during the cluster creation.
    • Server certificate: A certificate of the server that you can download to be uploaded to Looker.

Access Looker Studio

  1. Open and login to your account.
  2. Click on the Create button and choose the Report option.
  1. Configure Looker Studio connection with a Google-provided PostgreSQL connector.
  1. To connect with Looker connection, please enter the following details:
    • Host Name or IP: Your host’s address from the Address field on the Oxla Cloud Connect view.
    • Port: Enter the port number
    • Database: Enter oxla.
    • Username: Your username from the Username field on Oxla Cloud Connect view.
    • Password: Your cluster’s password.
    • Check Enable SSL checkbox.
    • Next to PostgreSQL SSL Configuration Files, click the Upload icon arrow and upload the certificate you downloaded from Oxla Cloud.
  2. Click on Authenticate to proceed.
  1. Select a table from the list of tables.
That’s all! The data source is connected.