This documentation corresponds to a historical version of Yellowfin

Icon

Access the latest release, or view a list of available versions of the documentation.

Skip to end of metadata
Go to start of metadata

Supplied Database Connection Drivers

Database

Driver Version

Diaprism

 

CacheDB

2007.1.1.420

DB2

3.57.82

H2

 

HSQLDB

2.2.8

Actian

3.8.3

Sybase ASA/IQ

6.0.5

Pervasive PSQL

 

DB2/AS400

5.2

JTDS (MS SQL Server, Sybase ASE)

1.2.5

MySQL

5.1.18

Oracle

11.2.0.3

PostgreSQL

9.1-901

SQLite

3.7.2

Adding Database Connection Drivers

If you need to add additional connection drivers then:

  1. Copy your JDBC driver JAR file(s) into the Yellowfin/appserver/webapps/ROOT/WEB-INF/lib/ directory.
  2. If the DB Name is not in Yellowfin's database list (see below) you will need to edit the file Yellowfin/appserver/webapps/ROOT/WEB-INF/web.xml and add the class name for your driver to the list in the JDBCDrivers parameter.
    Note: if the database name is simply greyed out in the list you won't need to perform this step.
  3. You will then need to restart Yellowfin for the new driver to become available.

Updating the TCP/IP Port

The TCP/IP port is used for the connection from the browser. You may have to change the port number if you have another service running on the Yellowfin server which has a port conflict. Choose a Port number which is not being used by another service. Note: The port was initially configured during the installation process.

To update you port number open the server.xml file located in:
Yellowfin/appserver/conf/server.xml

There are two ports that are used by Yellowfin by default, and two more that can be configured:

  1. The port that Tomcat listens on for shut down requests (used internally by Tomcat) (see line 1, below)
  2. The port that Tomcat listens on for HTTP browser connections (see line 3, below)
  3. The port that Tomcat listens on for HTTPS browser connections (see line 21, below)
  4. The port that Tomcat listens on for AJP connections (used when connecting Tomcat to IIS or Apache) (see line 35, below)

Outgoing Mail Settings

Yellowfin can be configured to broadcast electronic mail on an adhoc or scheduled basis. A SMTP server must be running for outgoing mail to be sent successfully.
By default the Yellowfin application will use localhost as the SMTP server. If you would like to use another SMTP server (such as an ISP SMTP server) you must manually modify the SMTP configuration using the Administration Configuration page.

Warning: Generally in an OEM deployment you may not wish to have your clients modify the some configuration items. There is a risk that your users may modify a key attributes which will break their instance of Yellowfin. Use role management to remove the associated functions from their roles.