Configuring Google Looker

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

Configurations before accessing Google Looker

Complete the following steps before accessing Looker:

If Google Looker is running, stop it. To stop Google Looker, execute the following commands:
```
cd ~/looker
./looker stop
```
Navigate to Campaign_Home\reports\Open Insights\Looker\<Product_Name>\Install directory where
<Product_Name> is Deliver.
Navigate to the product folder and copy the project folder to the following location: /home/looker/looker/models/.
For Unica Deliver, the project folder is unica_deliver_project.
Start Google Looker. Run the following commands:
```
cd ~/looker
./looker start
```
Access the Looker URL with administrator privileges.
An example URL is https://localhost:9999.

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

Open Google Looker.
Navigate to Develop > Manage LookML Projects.
The LookML Projects page appears.
Verify if the unica_deliver_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 menu item unica_deliver_project.
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.

Perform the following configurations upon accessing Google Looker:

In the Connection Settings page, provide the following values:


Name	Enter the Deliver data source name, deliverds, which points to the Unica Campaign system database. 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.

Navigate to Browse > All Folders.
Access Shared Folders.
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>. Create the folder Unica and within the Unica folder, create another folder named Deliver.
Select the Develop menu and toggle Development Mode to On.