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.
-
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
About this task
Procedure
-
Run the following commands:
-
sudo apt install openjdk-8-jre-headless
-
sudo apt install openjdk-8-jdk-headless
-
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:
-
ulimit
-
ulimit -a
-
-
Run the following commands:
-
cd /tmp
-
sudo mount -o remount,exec /tmp
-
sudo apt-get install netcat
-
sudo apt-get install ntp
-
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
- 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
Your organization's folders page appears.
-
Click New and select
Folder.
The Create folder dialog opens.
-
Type the name Unica and click
Create folder.
A folder named Unica appears.
- Select the folder Unica to open it.
- Perform Step 19 through Step 20 to create the other required folders. For more information, see New Folders required during Google Looker installation.
- Stop and restart Looker.
-
Note: This step is optional and must be performed only if you have not configured Unica Insights Reports for the concerned Unica product.In case of Deliver, navigate to the Insights Reports SQL location (CAMPAIGN_HOME/reports/Deliver-ddl/<Database-Name>/) and run the following SQL files:
- acer_tables_sqlserver.sql
- acer_indexes_sqlserver.sql
- acer_scripts_sqlserver.sql
In the path CAMPAIGN_HOME/reports/Deliver-ddl/<Database-Name>/, the <Database-Name> refers to Oracle, DB2, or SQLServer and it is dependent on the database that you are using.
-
Navigate to the concerned <Open Insights SQLs>
location and run the concerned SQL files in the Campaign database
For more details on <Open Insights SQLs>, see Unica Products and Open Insights SQLs.
-
If you want to drop Open Insights
objects, run the concerned SQL file.For more details , see Unica Products and Open Insights SQLs.
Note: In case of DB2, before running the script, update the concerned SQL file with <schema-name>. Replace <schema-name> with the appropriate name of the schema before you run the script.
- If you have not configured Insights Reports, configure a set of jobs in the database. For more information, see Configuring Database Jobs and Custom Audience.