Configuring Google Looker

Before accessing Open Insights using Google Looker, you must make some configurations on Google Looker.

Configurations before accessing Google Looker

About this task

Complete the following steps before accessing Looker:

Procedure

  1. If Google Looker is running, stop it. To stop Google Looker, execute the following commands:
    cd ~/looker
    ./looker stop
  2. Start Google Looker. Run the following commands:
    cd ~/looker
    ./looker start
  3. Access the Looker URL with administrator privileges.
    An example URL is https://localhost:9999.

Validate and Publish the Google Looker Model

About this task

To validate the deployment of the project, complete the following steps:

Procedure

  1. Open Google Looker.
  2. Navigate to Develop > Manage LookML Projects.
    The LookML Projects page appears.
  3. Verify if the project entry exists in the Project column. If the entry exists, it confirms the successful deployment of the project. Also, when you access the menu Develop, you will see the project entries in the menu items.
  4. Click the Configure button, succeeding the required Project from the list. For more information about projects, see Data Model files and their Location after installing Unica.
  5. For the Allowed Connections field, and Only these connections option, select the required datasources as per the Unica product. For more information, see Unica Products and their Datasources.
  6. Configure your Git repository to maintain Google Looker Unica Projects. For more information, see https://docs.looker.com/data-modeling/learning-lookml/importing-projects.
    CAUTION: You may use Google Looker's bare_model repository to publish models, but it may not have all functionalities of repository management.

Creating Data Source for Google Looker

About this task

Perform the following configurations upon accessing Google Looker:

Procedure

  1. Navigate to Admin > Connections.
  2. In the Connection Settings page, provide the following values:
    Name Enter the datasource name. For details related to the datasource name, see Unica Products and their Datasources.

    For more information on connecting to the database, see https://docs.looker.com/setup-and-management/connecting-to-db.

    In case of Oracle database, see https://docs.looker.com/setup-and-management/database-config/oracle. Also, see Google Looker Oracle Connection for a quick reference.

    Dialect Select:
    • Microsoft SQL Server 2012+ for Microsoft SQL Server.
    • Oracle for Oracle.
    • IBM DB2 for IBM DB2.
    Note: For more information on Google Looker Oracle Connection, see Google Looker Oracle Connection.
  3. Navigate to Browse > All Folders.
  4. Access Shared Folders.
  5. Note: Perform this step only if you have not created the folders. If the folders exist, skip this step.
    Create a folder name <Product_Name>. For more information, see New Folders required during Google Looker installation.
  6. Select the Develop menu and toggle Development Mode to On.