Vertica QuickStart for Logi Info

To read this document in PDF form, click here.

The Vertica QuickStart forLogi Info is a set of sample reports created using Logi Info and powered by the Vertica Analytic Database. The dashboards present sample retail data for analysis. The QuickStart shows how retail companies could use Vertica and Logi Info to quickly explore, visualize, and gain insight into their data stored in Vertica.

You can download the Vertica QuickStart for Logi Info from the following location:

https://www.vertica.com/quickstart/vertica-quickstart-for-logi/

About the Vertica QuickStarts

The Vertica QuickStarts are free, sample applications created using front-end products from Vertica technology partners. For an overview, watch this short video:

The QuickStarts are posted for download on the Vertica QuickStart Examples page.

Note The Vertica QuickStarts are freely available for demonstration and educational purposes. They are not governed by any license or support agreements and are not suitable for deployment in production environments.

About Logi Info

Logi Info is a web-based business analytics platform used to rapidly create analytical applications and deploy dashboards and reports. Logi Info works with Windows and Linux operating systems. For detailed product information about Logi Info, see the Logi Analytics website.

Requirements

The Vertica QuickStart for Logi Info requires a Vertica database server with the VMart example database, a Vertica client driver, Logi Info Studio 12.0.036 – SP2 or later, and Web services, such as IIS or Java-based web.

Installation and Setup

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

  1. Install the Vertica Database Server
  2. Install the VMart Example Database
  3. Install Logi Info
  4. Install the Vertica Client Driver

Install the Vertica Database Server

If you do not already have Vertica, you can download the Community Edition free of charge:

  1. Navigate to Vertica Community Edition.
  2. Log in or click Register Now to create an account
  3. Follow the on-screen instructions to download and install the Vertica Community Edition.

Install the VMart Example Database

The Vertica QuickStart for Cognos assumes a default installation of the Vertica VMart example database.

To install VMart, follow the instructions in the Vertica documentation:

For details, see VMart Example Database Schema, Tables, and Scripts.

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 Client Driver

Logi Info uses ADO.NET drivers when using IIS Web Services and JDBC drivers when using Java based web services. Before you can connect to Vertica using Logi Info, you must download and install the Vertica client package. This package includes the Vertica JDBC driver that Logi uses to connect to Vertica. The ADO.NET driver is available as part of the Vertica client drivers with version 7.2.x and later. For earlier versions, it is part of the Vertica Microsoft Connectivity pack.

To download and install the Vertica client package:

  1. Navigate to the Vertica Client Drivers page.
  2. Download the version of the Vertica client package that is compatible with the architecture of your operating system and Vertica server version.

    Note Vertica drivers are forward compatible, so you can connect to the Vertica server using previous versions of the client. For information about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

  3. Follow the driver installation instructions in the Vertica documentation.

IIS Web Service: Place the Vertica.Data.dll File in the Appropriate Directory

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

Follow these steps:

  1. Locate the Vertica.Data.dll file from the Vertica driver location. For example, for a 64-bit Vertica driver package installed on a Windows machine, the directory is:
    C:\Program Files\Vertica Systems\ADO.NET\
  2. Place the dll file into the Logi product bin directory that contains DLLS. For example, the default location in a Windows environment is:
    C:\Program Files\LogiXML IES Dev\LogiStudio\bin
  3. Place the dll file into the Logi Info application bin directory that contains DLLs. For example:
    C:\<Application Folder path>\VMartQS_LogiInfo_ForIIS\bin

Java Based Web Service: Place the vertica-jdbc-XXX-0.jar File in the Appropriate Directory

For Logi Info to work with Vertica using Java drivers, you must place the vertica-jdbc-XXX-0.jar file you downloaded with the client package into the product bin directory. (The XXX represents the version of your Vertica database.)

Follow these steps:

  1. Locate the vertica-jdbc-XXX-0.jar file from the Vertica driver location. For example, for a 64-bit Vertica driver package installed on a Windows machine, the directory is: 
    C:\Program Files\Vertica Systems\JDBC\
  2. Place the .jar file into the Logi product bin directory that contains the other .jar files. For example, the default location in a Windows environment is: 
    C:\Program Files\LogiXML IES Dev\LogiStudio\bin
  3. Place the .jar file into the Logi Info application bin directory that contains the other .jar files. For example the default location in a Windows environment is: 
    C:\ApplicationFolderPath\VMartQS_LogiInfo_ForHaven\WEB-INF\lib

Note If you upgrade your Vertica client, you must repeat the steps for replacing the dll or .jar file.

Download the QuickStart

  1. Navigate to vertica.com/quickstart
  2. Select Vertica QuickStart for Logi Info.
  3. Log in or create an account.
  4. Click Download.

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 QuickStart for Logi Info compressed (zip) file named VMartQS_LogiInfo_ForIIS.zip.
  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\VMartQS_LogiInfo_ForIIS.
  4. Open the Logi Info application on your system.

    You will see that the application is not registered in the IIS Web Server.

  5. Click the Register in IIS link.

    logi2.png

    A new wizard appears.

  6. After the application is registered, click Next and then Finish.
  7. Under Application, click Settings and select Path.

    logi4.png

  8. 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.

    logi5.png

  9. Click Save All.

Java Web Service Deployment

  1. Navigate to the folder where you downloaded the QuickStart for Logi Info compressed (zip) named zip.
  2. Unzip the file into a web apps folder, such as: C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps.
  3. Copy your license file from C:\Program Files\LogiXML IES Dev into the unzipped folder, such as C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\VMartQS LogiInfo For Java.
  4. Open the Logi Info application on your system..

    logi6.png

  5. Under Application, click Settings and select Path.
  6. 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.

    logi7.png

  7. Click Save All.

    logi8.png

Modify the Data Source Connection to Vertica VMart Database

Logi Info connects to Vertica via the ADO.NET or JDBC driver. Before you can deploy the QuickStart example, you must connect the Vertica VMart database to the proper driver.

  1. Open the Logi Info application.
  2. Under Application, click Settings > Connections > ConnVerticaLocal_New.

    logi9.png

  3. Enter the following information:
    • Vertica Server
    • Vertica Database
    • Vertica User
    • Vertica Password
    • Vertica Port (If the default is not used. Default is 5433.)
  4. Click Save All.

Open QuickStart Example Reports

There are two ways to run your reports. You can either use Logi Info Studio or a browser to view the VMart QuickStart Reports.

Use Logi Info Studio

Under Application > Reports, right-click VMartExcDashboard and click Run in Browser.

 logi10.png

The Executive Dashboard displays in the application.

Use Web Services

  • For IIS Web Services:

http://<HostNameorIPAddress:<Port#>/VMartQS_LogiInfo_ForIIS/rdPage.aspx?rdReport=VMartExcDashboard

Example: http://localhost/VMartQS_LogiInfo_ForIIS/rdPage.aspx?rdReport=VMartExcDashboard

  • For Java based web services:

http://<HostNameorIPAddress:<Port#>/VMartQS_LogiInfo_ForJava/rdPage.aspx?rdReport=VMartExcDashboard

Example: http://localhost:8080/VMartQS_LogiInfo_ForJava/rdPage.aspx?rdReport=VMartExcDashboard

QuickStart Example Dashboards

The QuickStart dashboards present sample business and operational data that a large retail chain might track over time. The chain operates brick-and-mortar stores and an online marketplace. It sells a wide variety of products that it purchases from different vendors.

Note The data in your dashboards will not match the data in the screenshots in this document. This is because the VMart data generator generates data randomly.

Executive Dashboard

The Executive Dashboard presents a high-level view of business data. You can use this dashboard to analyze the overall functioning of the business over time. The dashboard shown here shows online and sales store performance and regional performance for the years 2006 and 2007. You can see at a glance that:

  • Store sales were more volatile in 2007 than in 2006.
  • The lowest revenue month was June 2007.
  • California sales were the highest across the nation both online and in stores.

logi11.png

Online Sales Dashboard

The Online Sales Dashboard presents an overview of the online business. You can use this dashboard to analyze the performance of the chain’s online sales over time. In this instance, the dashboard is displaying online sales comparison for 2006 and 2007 and the top 10 products for each year. By viewing the product category, you can see food (clams, frozen pizza, American cheese, canned chili and sushi) was a top seller in both 2006 and 2007.

logu12.png

Store Sales Dashboard

The Store Sales Dashboard presents an overview of the traditional business conducted in the brick-and-mortar stores owned by this retail chain. The dashboard displays store sales for 2006 and 2007 compared to store returns.

You can see that store sales were much more volatile in 2007 than in 2006, with the highest sales for both years appearing in March 2007.

By selecting the gear on the Store Sales Dashboard tab, you can add additional panels to view different information. 

logi13.png

Product Dashboard

The Product Dashboard presents an overview of the products sold in stores and online. In this instance, the dashboard displays the top 10 and bottom 10 products for store sales in 2006 and 2007.

logi14.png

You can see that the top 10 and bottom 10 products change drastically for online sales in 2006 and 2007. There is no overlap in the top and bottom products sold in stores versus those sold online.

logi15.png 

Customer Dashboard

The Customer Dashboard presents information about individual customers. In this instance, the dashboard shows the individual customers in 2006 and 2007 that had the top sales in stores and online.

logi16.png

Find More Information