Share this article:

Vertica Partner QuickStart for Logi Info

Applies to Vertica 7.2.x and earlier 

What Is A QuickStart Application?

The Vertica QuickStarts are sample applications that show how complementary technologies can work together to deliver outstanding benefits to end users. Each QuickStart uses the Vertica Analytic Database with a different tool from a Vertica technology partner.

The QuickStarts are available for download free of charge on the Big Data Marketplace in the QuickStart Examples category.

About This Document

This document explains how to deploy and use the telecom QuickStart example for Logi Info. This document includes the setup information you need to get up and running and it provides an overview of the Logi dashboards and Vertica data sources.

Logi Analytic's Logi Info is a web-based business analytics platform used to rapidly create analytics applications and deploy dashboards and reports. Logi Info works with Windows and Linux operating systems. For more information about Logi, see the Logi product documentation.

The sample application used in this QuickStart was built by Logi Info. The dashboards presented in the QuickStart display sample telecom data loaded into the Vertica database.

Vertica QuickStart with Logi Overview

The Vertica QuickStart for Logi is a sample BI application implemented as a Logi report powered by the Vertica Analytic Database. The dashboards present sample telecommunications data for analysis. The QuickStart shows how telecommunication companies could use Vertica and Logi to quickly explore, visualize, and gain insight into their data stored in Vertica. The QuickStart sample application is available as a .zip file that contains the Logi application.

For a quick introduction to the Vertica QuickStart with Logi watch this short video: 

.

Requirements

The Telecom QuickStart for Logi requires an Vertica database server, the Vertica ADO.Net client driver, Logi Info Studio 12.1.188 or later, and IIS Web services.

This documentation is based on the results of testing Logi Info 12.1.188 with Vertica 7.2.x.

Installation and Setup

To install the software that is required for running the QuickStart, follow these steps:

  • Install Logi Info
  • Install the Vertica Database Server
  • Install the Client Driver

Install Logi Info

  1. Navigate to the Logi Download page.
  2. Enter your information to join the community.
  3. Click Join.
  4. Follow the installation instructions from Logi Analytics.

Install the Vertica Database Server

The Vertica database server runs on Linux platforms. If you do not have Vertica installed, you can download the Community Edition free of charge from MyVertica or from the Big Data Marketplace.

To download the Vertica Community Edition from MyVertica:

  1. Go to https://my.vertica.com/.
  2. Click the Register box.
  3. Provide your information and click Register.
  4. Follow the on-screen instructions to download and install Vertica Community Edition.

To download the Vertica Community Edition from the Big Data Marketplace:

  1. Go to Big Data Marketplace and sign in with your Marketplace credentials.
  2. Select the Vertica Platform category.
  3. Select Vertica Analytic Database Server.
  4. Click Get It!.
  5. Provide your information and click Register.
  6. Follow the on-screen instructions to download and install Vertica Community Edition.

Install the Client Driver

Logi Info uses ADO.NET drivers to connect to Vertica using IIS Web Services. Before you can connect Logi to Vertica, you must download and install the Vertica client package that includes the ADO.NET driver that Logi uses to connect to Vertica. The ADO.NET driver is available as part of the Vertica client drivers package with Vertica 7.2.x and later. For earlier versions, ADO.NET is part of the Vertica Microsoft Connectivity Pack.

To download and install the Vertica client package:

  1. Go to the Vertica Client Drivers page.
  2. Download the Vertica client package that matches the version of Vertica that you are using.
  3. Follow the steps for installing the Vertica client as described in the Vertica documentation.

Note Vertica drivers are forward compatible. You can connect to the Vertica server using previous versions of the client. For more information, see Client Drivers and Server Version Compatibility in the Vertica documentation.

For IIS Web Service: Save the Vertica.Data.dll File

For Logi Info to work with Vertica using the client driver package, you must save the Vertica.Data.dll file you downloaded with the client package into the product bin directory:

  1. Locate the Vertica jar file from the driver location. For example, a 64-bit driver package installed on a Windows machine is located at:
    C:\Program Files\Vertica Systems\ADO.NET\Vertica.Data.dll
  2. Save the dll file into the Logi product bin directory that contains DLLs. For example, the default location on a Windows environment is:
    C:\<Application Folder path>\TelecomQS_LogiInfo_ForIIS\bin

Download the QuickStart

  1. Go to the Big Data Marketplace and log in with your Marketplace credentials.
  2. Select QuickStart Examples.
  3. Select Vertica Partner QuickStart for Logi.
  4. Click Download.
  5. Navigate to the folder where you downloaded the compressed file and extract the QuickStart.

Install Telecom Schema

The Logi application file includes the telecom example DDL files. After you have downloaded and unzipped the QuickStart application into a wwwroot folder, follow these to install the sample schema.

The telecomsolution.zip file contains the following files:

  • TelecomQS_forLogi_Create_Schema.sql: Creates the LogiTelecom schema and its objects. This file also contains tables that include:
    • cells: Cell tower location details
    • concepts
    • customersessions: Details about customer-initated sessions
    • kpiunits: Key performance indicator units
    • networkq: Wireless network data
    • regions: City regions
    • troubletickets: Network tickets opened
    • worldcloud: The words in a Twitter feed
    • Twitter:Twitter data
  • TelecomQS_forLogi_Load_Data.sql: Loads data into the tables listed previously.
  • TelecomQS_forLogi_Drop_Schema.sql: Drops the tables and schema listed previously.

Before you start running the QuickStart application, you must execute these SQL scripts in Vertica. Copy the files into a folder on the machine where you can execute vsql command-line interfaces.

After you invoke vsql, follow these steps:

  1. Enter the following command:
    dbadmin>\i<Directorywherefileexists>\TelecomQS_forLogi_Create_Schema.sql
    The tables are created.
  2. Validate the tables that were created:
    dbadmin>\d
    The following output appears: output.jpg
  3. Load the data by executing the load script:
    dbadmin>\i <Directorywherefileexists>\ TelecomQS_forLogi_Load_Data.sql
  4. Validate that the rows were loaded into the tables by running the following:

dbadmin> select count(*) from LogiTelecom.cells;
dbadmin> select count(*) from LogiTelecom.concepts;
dbadmin> select count(*) from LogiTelecom.customersessions;
dbadmin> select count(*) from LogiTelecom.kpiunits;
dbadmin> select count(*) from LogiTelecom.networkq;
dbadmin> select count(*) from LogiTelecom.regions;
dbadmin> select count(*) from LogiTelecom.troubletickets;
dbadmin> select count(*) from LogiTelecom.twitter;
dbadmin> select count(*) from LogiTelecom.wordcloud;

If any of these commands return zero rows, check to see if you received an error message while executing the load script. If you dropped objects while troubleshooting, execute the drop schema script (TelecomQS_forLogi_Drop_Schema.sql).

Deploy the QuickStart for Logi Info Dashboards

You must deploy the zip file into the appropriate folder before you can run sample reports:

IIS Web Service Deployment

  1. Navigate to the folder where you downloaded the telecomsolution.zip file.
  2. Unzip the file into a wwwroot folder, such as C:\inetpub\wwwroot.
  3. Copy your license file from C:\Program Files\LogiXML IES Dev into the unzipped folder, such as C:\inetpub\wwwroot\telecomsolution.
  4. Open the Logi Info application on your machine.
  5. You see the application is not registered in the IIS Web Server. Click the Register in IIS link.
  6. A new wizard appears. Click Next.
  7. After the application is registered, the following graphic appears. Click Next and then click Finish.
  8. Under Application click Settings > Path.
  9. In the bottom left corner of the application, in the Optional Attributes window, change the Application Path based on your web services host name and port number.
  10. Click Save All.

Modify the Data Source Connection

Before you can deploy the QuickStart example, you must connect the Vertica database to the proper driver, by following these steps:

  1. Open the Logi Info application.
  2. Under Application, click Settings > Connections > ConnVerticaLocal_New.
  3. Enter the following information:
    • Vertica Server
    • Vertica Database
    • Vertica Backup Server
    • Vertica User
    • Vertica Password
    • Vertica Port (default is 5433)
    • Vertica Load Balance (enable on the server side also)

4. Click Save All.

Access QuickStart Example Dashboards

You can run the dashboards using Logi Info Studio or by using a web browser.

Use Logi Info

  1. Under Application, in the Reports folder, select Default.
  2. Right-click Default and select Run in Browser.

    runinbrowser.jpg

  3. Press Enter to see the dashboards.

volte.jpg

Use Web Services

To access the dashboards using Web Services, navigate to the following: http://<HostNameorIPAddress:<Port#>/TelecomQS_LogiInfo_forIIS/rdLogon.aspx.

QuickStart Example Dashboards

The QuickStart dashboards present sample wireless network data that a telecom company chain might use to monitor network performance. This could allow the company to minimize the risk of customer churn, which is the amount of time that has elapsed since the customer last interacted with the service. The dashboards also present insight into the views of end-to-end IP based networks to deliver enhanced services.

Main Menu

The Service Assurance dashboard presents a high-level view of the cities within the network you are monitoring. The dashboard appears gray until you click the Simulation button on the bottom left of the dashboard. The simulation shows how the networks are performing in different regions.

serviceassurance.jpg

You can drill down further into a region by selecting it. With the simulation running, the regions appear green, orange, or red, to correspond with how well the network is performing. If you select a specific area within a region, you can view data about the network traffic.

Network Assurance Dashboard

The Network Assurance dashboard contains a weather map, which shows how the weather impacts the networks. Based on weather, you can monitor how many support tickets were reported on an hourly basis.

network assurance.jpg

Customer Assurance Dashboard

This dashboard provides insight about network utilization information for an individual customer. You can see details about calls that the customer made and see if any of the calls were dropped. The graph on this dashboard shows any variation of delay of packets received (jitter), bit rate, latency, and more.

customer assurance.jpg

Opinion Dashboard

This dashboard provides insights about customer sentiment from Twitter feeds. Press the Simulation button to see if sentiment is positive, negative, or neutral and view what customers are tweeting about.

opinion.jpg

For More Information

For More Information About…… See
Logi Analyticswww.logianalytics.com
Vertica Communityhttps://my.vertica.com/community/
Vertica Documentationhttp://my.vertica.com/docs/latest/HTML/index.htm
Big Data and Analytics Communityhttps://my.vertica.com/big-data-analytics-community-content/
Telecom QuickStart https://www.youtube.com/watch?v=GDDa4HAG-E0&feature=youtu.be

Contact Us

The Vertica QuickStart for Logi Info is an example of complementary technologies: Logi Analytics with the Vertica Analytic Database. The QuickStart is not a product and is not governed by any license or support agreement.

We welcome your feedback. If you have questions, comments, or suggestions, please contact us by clicking the Contact developer button on the Big Data Marketplace download page for the QuickStart.

Share this article: