Share this article:

Vertica Integration with Yellowfin: Connection Guide

This document applies to Vertica 8.0.

 

Click here to access this document in PDF form.

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. This document provides guidance using the versions of Vertica and Yellowfin mentioned in the following topic.

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 tutorials and User Guides.

Yellowfin uses JDBC to connect to your Vertica database.

This document is based on the results of testing Vertica 8.0.x with Yellowfin 7.2 on Windows.

Download and Install Yellowfin

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

  1. Check the Installation Checklist.
  2. If JRE 1.5 or higher is not installed on your system, click download to download JRE 1.5.
  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 8.0 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 steps for installation from 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.2/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-8.0.0-0.jar, in the following location:

    Installation_Location_Yellowfin_7.2/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

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

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

Yellowfin supports the Vertica FLOAT data type but does not recognize thevalues +INFINITY, -INFINITY, and NAN. See Double Precision (FLOAT) for information about the Vertica FLOAT data type.

For More Information

For more information, see the following:

Share this article: