Like what you see? Have a play with our trial version.

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)
<Server port="8085" shutdown="SHUTDOWN">		
  <Service name="Catalina">
    <Connector port="80"				
               maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               connectionTimeout="20000" disableUploadTimeout="true"
               URIEncoding="UTF-8"
               compression="on"
               compressionMinSize="2048"
               noCompressionUserAgents="gozilla, traviata"
               compressableMimeType="text/html,text/xml,text/plain"
               />

    <!-- Uncomment this for an SSL connector running on port 8443 (change
         the port as required). You will need to generate a certificate
         and save it in this directory as "tomcat.key" (change the
         keystoreFile and keystorePass values as required).
         See: http://tomcat.apache.org/tomcat-5.5-doc/ssl-howto.html -->
    <!--
    <Connector port="8443"				
               maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" disableUploadTimeout="true"
               acceptCount="100" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS" URIEncoding="UTF-8"
               keystoreFile="${catalina.home}/conf/tomcat.key"
               keystorePass="password"
               />
    -->
    
    <!-- Uncomment this for an AJP connector, to connect tomcat to another
         web server such as Apache or IIS -->
    <!--
    <Connector port="8009" protocol="AJP/1.3" />	
    -->

    <Engine name="Catalina" defaultHost="localhost">
      <Host name="localhost" appBase="webapps"
       unpackWARs="true" autoDeploy="false"
       xmlValidation="false" xmlNamespaceAware="false">
      </Host>
    </Engine>
  </Service>
</Server>