Share this article:

Vertica Integration with Yellowfin: Connection Guide

 

About Vertica Connection Guides

Vertica connection guides provide basic information about setting up connections to Vertica from software that our technology partners create. These documents provide guidance using one specific version of Vertica and one specific version of the third party vendor’s software. Other versions of the third-party product may work with Vertica. However, other versions may not have been tested.

Yellowfin and Vertica Product Versions

This document provides guidance using the versions of Vertica and Yellowfin described as follows:

Software Version
Partner Client

Yellowfin 7.4

Desktop Platform

Windows Server 2012 R2

Vertica Client

Vertica JDBC driver 9.0.1-0

Vertica Server

 Vertica 9.0

Yellowfin Overview

Yellowfin is a business intelligence tool that supports analytics, collaborative BI, mobile access, and geospatial mapping as well as data visualization and reporting.

Yellowfin can access data stored in relational databases, multi-dimensional cubes, and in-memory analytical databases. With Yellowfin, you can build personalized and interactive dashboards that are immediately accessible on mobile devices or in a web browser. Yellowfin provides native apps for iPhone and iPad and an HTML 5 hybrid app for Android.

For more information about Yellowfin, visit the Yellowfin website. To start learning about Yellowfin, see the Yellowfin documentation.

Yellowfin uses JDBC to connect to your Vertica database.

Download and Install Yellowfin

Yellowfin is available for download on the Yellowfin website. Before you download Yellowfin:

  1. Check the Installation Prerequisites.
  2. If JRE 7 or higher is not installed on your system, click download to download the JRE.
  3. If you already have a valid Yellowfin license, click the checkbox for A Valid Yellowfin License.

To download and install a free, evaluation copy of Yellowfin:

  1. Navigate to the Yellowfin homepage.
  2. Click Try It Free.
  3. Supply the required information and click Submit.
  4. Follow the installation instructions.

Download and Install the Vertica Client

Before you can connect to Vertica using Yellowfin, you must install the Vertica client package. This package includes the Vertica JDBC driver that Yellowfin uses to connect to Vertica.

Download the Vertica Client

  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 more information about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

Install the Vertica Client Driver

Based on the client package you downloaded, follow the installation instructions in the Vertica documentation.

Connect Vertica to Yellowfin

Create a Connection

  1. After you install the Yellowfin software, go to the Yellowfin installation directory:
    Installation_Location_Yellowfin_7.4/appserver/bin
  2. Double-click the Yellowfin batch file to start the Yellowfin services. Startup information like the following displays:

  3. Place the Vertica JDBC jar file,, vertica-jdbc-9.0.1-0.jar, in the following location:

    Installation_Location_Yellowfin_7.4/appserver/webapps/ROOT/WEB-INF/lib
  4. Double-click the Yellowfin batch file to restart the Yellowfin services.
  5. Open a web browser and type the following URL: http://server-IP:8080
  6. Specify the following credentials and click Login:

    Username: admin@yellowfin.com.au

    Password : testYellowfinConnecting.png

  7. On the default Yellowfin screen, click the plus sign (+)

    YellowFinGraph.png

  8. Select Data Source from the Create menu.

    YellowfinDataSource.png

  9. Select Create a data source connection using JDBC.

    SelectDataSource.png

  10. Specify the connection details.NewConnection.png
  11. In the Advanced Connection editor, select Test Connection.TestConnection.png

Create a View

  1. When the connection is successful, return to the default screen and select View from the Create menu.

    ViewDataSource.png

  2. Under Select Data Source, select Vmart, the Vertica data source.

    CreateNewView.png

  3. Select a table from the Vertica database, specify a name for the new view and click Create Analysis.

    CreateNewViewCustomer.png

  4. Create the view using the dimensions and measures of the selected table.

    CustomerDim.png

Known Limitations

INTERVAL Data Types

Yellowfin 7.4 does not support the INTERVAL data types in Vertica. INTERVAL data in Vertica is not loaded into Yellowfin.

BINARY Data Types

Null values of type BINARY, VARBINARY, and LONGVARBINARY in Vertica are successfully loaded into Yellowfin. However, non-null values of these types are not loaded.

UUID Data Type

Yellowfin 7.4 does not support the Vertica UUID data type. UUID values are not loaded into Yellowfin.

FLOAT Data Types

MaxDouble, MinusOne, One and Zero values of FLOAT data type are supported.

OnePlusFraction and [122.333444455555] values of FLOAT data type are partially supported. Values to the right of the decimal point are truncated.

NAN, -Infinity, +Infinity, Null, SmallestDouble and ZeroPlusFraction values of FLOAT data type are not supported.

A similar pattern of result-set is observed for DOUBLE_PREC, FLOATN, FLOAT8 and REAL columns of Float datatype values.

For information about the Vertica FLOAT data type, see Double Precision (FLOAT) in the Vertica documentation.

For More Information

For more information, see the following:

Share this article: