Yellowfin

You can easily integrate Exasol into Yellowfin, which is a business intelligence tool that supports analytics and collaborative BI. This section provides you with information on how to connect the Exasol database to Yellowfin.

Prerequisite

  • Yellowfin downloaded and installed. Yellowfin is available for download on the Yellowfin website.
  • Exasol JDBC driver installed on your operating system. You can download the driver from the Exasol downloads section.

Connect Exasol to Yellowfin

Connecting Exasol to Yellowfin includes the following steps: 

Login to Yellowfin

  1. After you have installed Yellowfin, navigate to the Yellowfin installation directory and start the Yellowfin services by clicking the Yellowfin startup batch (startup.bat) file.
  2. Once Yellowfin is running, open a web browser and enter the following URL: http://<server-ip>:8080
  3. Enter the login credentials and click Login. For example: 
  4. Username: admin@yellowfin.com.au
    Password: test


Install Exasol Driver

To be able to connect Exasol to Yellowfin, you must first install the Exasol JDBC driver. You can use the Plugin Management page in Yellowfin to install and manage the drivers.

  1. From the menu button on the left corner of the screen, select Administration to open the Admin Console.
  2. In the Admin Console, select the Plugin Management option.
  3. In the Plugin Management page, click the Add button to add a plugin/driver.
  4. In the New Plugin screen, enter a name and description for the plugin/driver.
  5. Next, drag and drop the Exasol JDBC driver file. Once the driver is added, click Submit.
  6. You will now see the driver you added in the Plugin Management page.

Add Exasol as Data source

Once you have Yellowfin running and the Exasol driver installed, you can connect Exasol as the data source to Yellowfin. Follow these steps to add Exasol as a data source:

  1. On the default Yellowfin screen, click the plus sign.
  2. Select Data Source from the Create menu.
  3. Next, select the Database option in the New Connection screen.
  4. Enter the following connection details for the database as shown in the screen shot below:
    • Name: Name of the database
    • Description: Description for the database.
    • Database Type: The type of the database.
    • Include Schema in SQL: Select this check box to add the schema name when addressing database tables in SQL queries.
    • Database Host: Name or IP address of the server hosting the Exasol database.
    • Database Port: Port number for this connection.
    • Default Schema: Default schema to be opened on login.
    • JDBC Driver: JDBC driver to talk to Exasol database.
    • Username: Username of your database account.
    • Password: Password for your database account.

  5. Once you have entered all the connection information, you can test the connection. Click the down arrow next to the Create View button and select Test Connection.

  6. When the connection is successful, a Connection Succeeded message is displayed in the New Connection screen.
  7. Next, you can create views by clicking the Create View button.
  8. Save the connection by selecting the Save & Close option when you click the down arrow as shown below.

 

See Also: 

For additional information on Yellowfin, refer to