Yellowfin

Learn how to connect Yellowfin to an Exasol database.

Yellowfin is a business intelligence tool that supports analytics and collaborative BI. This article explains how to connect Yellowfin to an Exasol database. For more information about how to use Yellowfin, refer to the Yellowfin website.

Prerequisites

  • Yellowfin must be installed.

  • The Exasol JDBC driver must be installed. To learn more, see JDBC driver.

  • Your Exasol database must be running and reachable from the environment where the tool is used.

Exasol SaaS

  • The IP address of the host where the tool is running must be in the allowed IP address list in Exasol SaaS. To learn how to allow traffic to your database, see Network security (SaaS).

  • To connect the tool to an Exasol SaaS cluster you will need the connection string and a personal access token (PAT) for authentication. To learn how to get the connection details, see Connect to Exasol SaaS.

Connect Yellowfin to Exasol

  1. Install the Exasol JDBC driver in Yellowfin. For more details, refer to the Yellowfin documentation.

  2. Add Exasol as a data source using the following connection details:

    • Database Host: The URL for the Exasol database.

      To learn about supported URL structures for the JDBC driver, see Exasol URL.

    • Database Port: Exasol database port (8563).

    • JDBC Driver: Select the Exasol JDBC driver.

    • Username: The name of the Exasol user.

    • Password: The password of the Exasol user.

      For Exasol SaaS, use a valid personal access token as password.