Installing Google Looker

Although Unica Open Insights provides out-of-the-box integration with Google Looker, the Google Looker installation is not part of the Unica installation. You must install Google Looker separately.

Preinstallation Configurations

Complete the following steps before you install Google Looker:

Procedure

The following steps are applicable only if you have Microsoft Windows operating system. You can skip the following steps if you have a Linux-based operating system.
1. On your Microsoft Windows system (version 10), type develop in the search bar.
  A result for Developer settings appears.
2. Select Developer settings or select Open.
  The For developers section in the Settings dialog opens.
3. Select Developer mode.
  Microsoft Windows searches and installs the developer package.
4. Restart your computer.
5. In the search bar, type PowerShell.
  You will see a result for Windows PowerShell.
6. Right-click Windows PowerShell and select Run as administrator.
  The Windows PowerShell environment appears.
7. To enable the Windows Linux Subsystem, run the following command in the PowerShell:
```
C:\>Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Windows-Subsystem-Linux
```
8. When the system prompts you, select the option to restart the computer.
9. After the restart, visit the Microsoft Store and download Ubuntu.
10. After the download is complete, click the Launch button to start Ubuntu. You can also use the Windows search to access Ubuntu.
11. Set appropriate credentials for the Unix account.
  Your Windows system is ready to run Linux directly from the command prompt.
To test Linux commands, open the command prompt and execute the following command:
```
C:\>bash
```
The Linux prompt appears. Now run the following house cleaning command (you have to provide the credentials that you set in Step 1-k:
```
$ sudo apt-get update
```
Note: The Unix command is an Ubuntu-specific command. The command may vary for other Unix-based operating systems.

Google Looker Installation

You can access Google Looker documentation for installation. We have provided some steps which are based on the procedures mentioned in the Google Looker documentation.

Before you begin

If your Operating System is Microsoft Windows, ensure that you have completed the Preinstallation Configurations. To execute the commands mentioned in the following procedure, open the command prompt and perform Step 2 mentioned in Preinstallation Configurations to run Unix commands.

About this task

To install Google Looker, see Google Looker documentation. You can also visit the following page: https://docs.looker.com/setup-and-management/on-prem-install.

Note: The Unix commands, mentioned in the following procedure, are Ubuntu-specific commands. The commands may vary for other Unix-based operating systems.

Procedure

Run the following commands:
1. sudo apt install openjdk-8-jre-headless
2. sudo apt install openjdk-8-jdk-headless
3. sudo apt-get install -y libssl-dev
Run the command sudo vi /etc/sysctl.conf.
Append the following lines in the file and save the file.
```
net.ipv4.tcp_keepalive_time=200
net.ipv4.tcp_keepalive_intvl=200
net.ipv4.tcp_keepalive_probes=5
```
Run the command /etc/sysctl.conf and check the contents of the file.
Verify if the swap file exists. If it exists, move to Step 5. If it does not exist, run the following commands:
1. ulimit
2. ulimit -a
Run the following commands:
1. cd /tmp
2. sudo mount -o remount,exec /tmp
3. sudo apt-get install netcat
4. sudo apt-get install ntp
5. sudo ntpq -p
Exit the command prompt.
You must now create a new registry. To create a new registry, type regedit in the search bar.
You will see Registry Editor. Select Open.

Copy and paste the following path in the address bar and press ENTER:

Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W32Time\Parameters

Right-click on the right panel and select New > DWORD (32-bit) Value
Provide an appropriate Value name and Value data and click OK.
Restart the system.
Open the Unix command prompt.
Create a folder named looker in the Looker home directory.
Copy the following JAR files and the looker file to the looker folder:
- looker-dependencies.jar
- looker.jar
Start Looker by running the following command:
```
./looker start
```
Access Google Looker command with following URL: https://hostname:9999.
If you are logging in for the first time, provide the license key and credentials. For more information, see Google Looker documentation.
In the Google Looker home page, select Browse > Shared folders
Your organization's folders page appears.
Click New and select Folder.
The Create folder dialog opens.
Enter the name Unica and click Create folder.
A folder name Unica appears.
Select the folder Unica to open it.
Perform Step 19 through Step 20 to create a folder named Deliver and within the Deliver folder, create a folder named models
Copy the data model unica_deliver_project to the models folder.
Stop and restart Looker.
Note: This step is optional and must be performed only if you have not configured Unica Insights Reports for Unica Deliver.
Navigate to Campaign_home\reports\Deliver-ddl\<db name>\ and run the following SQL files:
- acer_tables_sqlserver.sql
- acer_indexes_sqlserver.sql
- acer_scripts_sqlserver.sql
Navigate to the location Campaign_home\reports\Deliver-ddl\<db name>\open_insights\ and run the following SQL files in the Campaign database:
- Deliver_open_insights_tables_1211.sql
- Deliver_open_insights_scripts_1211.sql
If you want to drop Open Insights objects, run Deliver_open_insights_tables_drop.sql.

Note: In case of DB2, before running the script, update Deliver_open_insights_tables_drop.sql for the <schema-name>. Replace <schema-name> with the appropriate name of the schema before you run the script.
If you have not configured Insights Reports for Unica Deliver, you must configure a set of jobs in the database. For more information, see the "For Unica Deliver only: How to schedule and run stored procedures" topic in Unica Insights Reports Installation and Configuration Guide