Share this article:

Vertica Integration with Veera Predict: 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 version of Vertica and one version of the third party vendor’s software. Other versions of the third-party product may work with Vertica. However, we may not have tested those other versions.

Vertica and Veera Predict: Versions Tested

Software Version
Partner Product

Rapid Insight Veera Predict 3.2.18093.0

Desktop Platform

Windows Server 2012 R2

Vertica Client

Vertica ODBC 9.1.0-0

Vertica Server

Vertica Database 9.1.0-0

Rapid Insight Veera Predict

Rapid Insight Veera Predict mines and examines historic data, identifies variables with predictive qualities and builds powerful and transparent predictive models. Users can explore patterns within variables and perform detailed analysis of data and build statistical models to predict future outcomes. See the Rapid Insight Veera Predict website for more information.

Install Veera Predict

You can download Veera Predict from Rapid Insight's download page. Complete the registration information and click Get the Trial.

See the Desktop Installation Guide for instructions on installing Veera Predict.

For more information on using Veera Predict see the online documentation.

Download and Install the Vertica Client Drivers

Before you can connect to Vertica using Veera Predict, you must install the Vertica client package. This package includes the ODBC client driver that Veera Predict uses to connect to Vertica.

Download Vertica Client Drivers

  1. Go 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.
  3. Based on the client driver package you downloaded, follow the installation instructions in the Vertica documentation.

Note Vertica drivers are forward compatible, so you can connect to the Vertica server using earlier versions of the client.

For more information about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

  1. Create an ODBC DSN following the Setting up an ODBC DSN instructions in the Connecting to Vertica section of the documentation. This is used by Veera Predict when establishing a connection with Vertica.

Connecting Veera Predict to Vertica

Follow the steps below to create a connection to Vertica:

  1. From Windows File Explorer access the directory where you installed Veera Predict and double-click the file VeeraPredict64 to open the application. The Veera Predict Home Screen appears:


  2. Click New Connection:


    The Create New Connection dialog appears
  3. Click the DSN icon:


  4. From the Create New Connection data entry screen, enter the ODBC DSN details:


  5. Click Test to test the new connection. If the test is successful, the following appears:


  6. Click  OK, the new connection appears in the Connections window:


  7. Select the connection you just created, Vertica_Connection. The Select Tables dialog appears.
  8. Select the tables from the Vertica database that you want to use in your analysis:


  9. Click Select. The selected tables appear in the Selected Tables section of the dialog:


  10. Click Save. The tables appear on the Home page:


  11. Right-click a table (for example, VERT_DATATYPE_v1_0_5_SCHEMA) and select Create New Analysis:

  12. The relevant table data appears for this newly created analysis:


Known Limitations

Before using Veera Predict with Vertica, be aware of the following known limitations:

  • The following data types supported by Vertica are unable to display in Veera Predict:
    • Binary, VarBinary, and LongVarBinary

    • IntervalSeconds and IntervalMonth

      Max and Min values of Integer & Decimal (Number column ) data type.

    • PositiveInfinity, NegativeInfinity and NaN values of Float data type.

  • Max and Min values (Decimal, Numeric, NumLargeScale, Mon column of Decimal ) are getting rounded off after 15 digits.
  • Loss of millisecond values is reflected for the Typical values of Time and Timestamp data types.

  • A few Typical values of TimeTz and TimestampTz data type are showing loss of millisecond and timezone value truncation and are getting partially passed

For More Information

 

 

Share this article: