Versions Compared

Version Old Version 14 New Version Current
Changes made by

Fiona Sargeant

Anthony George

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_Banners
_Banners
nameadministration
nopaneltrue

This page is for administrators who need to connect PhixFlow to external databases using Driver Classes.

Overview

The PhixFlow application communicates with:

  • the database on which it is installed.

    • can communicate with an external database from which it needs to load data.


    This is configured using a Datasource in an analysis model. 

    To communicate with a an external database, PhixFlow needs:

    1. The
    appropriate database driver
    1. jar files
    in its Driver Class
    1. for connecting to a database, stored in PhixFlow's Database Driver File Directory. This location is set
    in 
    1. directly in System Configuration → System Directories → Database Driver File Directory.
    2. A
    Driver Class for the database
    1. database driver configured in the repository. One database driver
    class
    1. item can
    have multiple Driver Class Files.PhixFlow is installed with the database driver jar files (stored where) and preconfigured driver classes for the
    1. refer to multiple jar files.

    Preinstalled Databases

    There are three databases on which it PhixFlow can be installed:

    MariaDB
    1. MySQL
    Microsoft (
    1. MS
    )
    1. SQL Server
    2. Oracle.
    Panel
    borderColor#7da054
    titleColorwhite
    titleBGColor#7da054
    borderStylesolid
    titleSections on this page

    Table of Contents
    indent12px
    stylenone

    PhixFlow automatically uses the appropriate driver class to communicate with its own database. You can use these driver classes

    For each of these, PhixFlow is preconfigured with:

    • jar files stored in in tomcat/webapps/phixflow/WEB-INF/lib 
    • a database driver in the repository, which uses jar files.

    You can use these pre-configured database drivers in a datasource. However, you cannot update their properties or see their

    driver class You can use the MariaDB driver class to connect to a MySQL database.

    jar files.

    Tip

    Additional Databases

    You may need to configure additional database drivers to support:

    • other types of database
    • different versions a database.

    How to Configure a Database Driver

    Class

    1. Find out which

    (usually
    1. JDBC
    ) 

    Deprecated Driver Classes

    The repository includes the following, deprecated driver classes, for backwards compatibility. 

    • DB2
    • Debug JDBC
    • Google Big Query
    • Hadoop Hive
    • MySQL
    • Netezza
    • Sun ODBC Bridge
    • Teradata
    Note

    These are drivers are read-only and do not connect to any database drivers. If you want to connect to one of these databases, we recommend you create a new driver class in which you can configure all the database drives needed.

    Adding or Changing a Driver Class  Anchor_add_addTo create a driver class, in
    1. database drivers you require. This information is available in the documentation for your database. Also check the System Requirements and Compatibility page for supported versions. Communication to a database may require multiple JDBC driver files. 
    2. Download the required JDBC driver files from:
  • Save them to the Driver Class File Directory specified in System Configuration. You need permission to add system files to do this. 
  • For each database, create one Driver Class, see Adding or Changing a Driver Class, below.
  • In the driver class properties → Driver Class File section, add all the JDBC driver files that the database requires; see Driver Classes and Driver Class File Properties, below.
  • For each driver class file that is saved to a sub-directory of the Driver Class File Directory, specify it's relative path.
    1. Ensure you have a Database Driver File Directory setup. If it has been setup it can be seen in System Configuration → System Directories → Database Driver File Directory.
      1. If it has not been setup, create the directory in a location available to Tomcat.
      2. Open Administration → System Configuration → System Directories, and update the Database Driver File Directory with the path of the directory.
    2. In PhixFlow, for each type of database, create one database driver;
      1. In the full repository scroll down to the
        Insert excerpt
        _driver_
    class_
      1. repo
        _driver
    _class
      1. _repo
        nopaneltrue
         section. 
      2. To add a new driver,
    right-
      1. click
    Driver Classes and select 
      1. Insert excerpt
        _
    add
      1. addIcon
        _
    add
      1. addIcon
        nopaneltrue
        . PhixFlow opens a property tab where you can enter the details for the new driver.
        1. To open an existing database driver
    class
        1. , in the repository double-click on its name.
      2. In the database driver properties → Database Driver File section, add all the JDBC driver files that the database requires; see Properties Tab → Settings, below.
      3. For each jar file, specify the path to the file stored in the Database Driver File Directory.


    Tip

    You cannot change the pre-configured

    driver classes

    database drivers supplied with your PhixFlow installation. These have the System Defined property ticked.

    PhixFlow also includes a number of unconfigured drivers, such as Google Big Query, which are included for backwards compactivity. See Deprecated Database Drivers below for full details.

    Driver Classes and Driver Class File Properties 

     

    Insert excerpt
    _property_tabs
    _property_tabs
    namebasic-h
    nopaneltrue
    Anchor
    properties
    properties

    The

    driver classes

    database drivers configured in the repository populate the drop-down list in

    Insert excerpt
    _datasource
    _datasource
    nopaneltrue
     properties Basic Settings

    → Driver Class.

    → Database Driver 

    Insert excerpt
    _

    standard_settings_standard_settings

    parent
    _parent
    nopaneltrue
     This section is available for custom database drivers and shows the package to which a database driver has been added, if any.

    Tip

    If you intend to use an analysis model in multiple PhixFlow instances, and the model contains a datasource that uses a custom database drivers, remember to add the database driver to the same application or package as the analysis model; see Using Drivers Across Multiple Instances below.

    Insert excerpt
    _parent
    _parent
    nopaneltrue

    Basic

    Settings

    Basic 

    FieldDescription

    Name

    		Enter a unique name for the database driver, which will appear in the PhixFlow repository.
    Database Driver
    Class
    Name

    Enter

    the

    the  database driver

    class

    name, which you will find in the driver documentation. For example, for MySQL, the driver name is: com.mysql.jdbc.Driver

    System Defined

    Read-only.

    Insert excerpt
    _check_box_untick
    _check_box_untick
    nopaneltrue
     indicates

    this driver class

    this  database drivers is custom defined for your PhixFlow instance. You can change it's configuration.

    Insert excerpt
    _check_box_

    ticked

    tick
    _check_box_

    ticked

    tick
    nopaneltrue
     indicates this driver is preconfigured when PhixFlow is installed. It is required for the system and cannot be updated.

    DescriptionOptionally enter a description for the driver.

    Advanced

    FieldDescription
    Datasource Profile

    Use this option to specify the datasource properties to use. Enter:

    • default - for most drivers
    Driver Class
    •  bigQuery - for Google BigQuery.

    Database Driver File

    This section has a toolbar with standard buttons. 

    The grid lists the jar files for this database driver

    class

    . Each database usually requires multiple jar files. To add a jar file to the list:

    1. Click
      Insert excerpt
      _
    add
    1. new
      _
    add
    1. new
      nopaneltrue
       to open a the properties for a new Database Driver
    Class
    1. File Location.
      (Database Driver
    Class Driver Class
    1. File Location properties are only available from this grid. They are not listed in the repository.)

    2. In the Basic Settings section, set:

      FieldDescription

      Name

      		Enter a unique name for the driver.  
      Connector Jar File Location
    PhixFlow looks for jar files in the root 

    1. The root Database Driver File Directory,

    that is

    1. must be specified in System Configuration.

    If this jar file is in the root directory, leave this field empty. If the jar file is in a subdirectory, specify the relative path

    1.  

      Specify a path, relative to the root Database Driver File Directory:

      • either to a specific driver jar file
      • or to a sub-directory that contains multiple driver jar files.

      For example:

      • if the file is /opt/phixflow-drivers/BigQueryJDBC/driverfile.jar
      • and the Database Driver File Directory is set to /opt/phixflow-drivers/

      then enter:

      • for Linux: BigQueryJDBC/driverfile.jar
      • Windows:  BigQueryJDBC\driverfile.jar

      If you specify a sub-directory, all jar files will be loaded but further sub-directories will be ignored.


    2. Click 

      Insert excerpt
      _finish
      _finish
      nopaneltrue
       to save and close the properties and return to the database driver

    class properies

    1. properties.

    To remove a jar file from the grid, use the toolbar button 

    Insert excerpt
    _delete
    _delete
    nopaneltrue
    . 
    Anchor
    export
    export


    Insert excerpt
    _audit
    _audit
    nopaneltrue

    Using Drivers Across Multiple Instances

    If you run multiple instances of PhixFlow, you must ensure that

    any

    :

    • a custom
    driver classes you create:
  • are exported and then imported to other instances
    • have
    • database driver used by a datasource, is moved with the datasource to another PhixFlow instance
    • AND the database driver has access to the database driver jar file from the other
    instances
    • instance.

    This

    ensures that

    means all datasource objects

    that use the database driver

    continue to work in other instances. 

    Excerpt
    namePackageDependency


    Tip

    Packages cannot depend on

    the other instances. 

    objects in another package. For example, if a Datasource is in an application then its Database Driver can be in the application or any linked packages. However, if a Datasource is in a package then its Database Driver must be in the same package. Datasources in one package cannot reference Database Drivers in a different package. 

    The easiest way to ensure Database Drivers move with the Datasource is to add the database driver to the same application or package as the model.


    For adding database drivers to the same application or package as the model; see Package.

    Note

    The following system database drivers cannot be moved into a package because they are installed on all PhixFlow instances:

    • MariaDB/ MySQL
    • MS SQL Server
    • Oracle

    How PhixFlow Decides Which Driver to Use

    PhixFlow is configured with a class path for finding drivers. This will use the first appropriate driver it finds in:

    1. The Connector Jar File Location configured for the
    driver classes
    1. database drivers file. 
    2. tomcat/webapps/phixflow/WEB-INF/lib
    3. tomcat/lib.
    Note
    In PhixFlow version 8.2 it is possible to use tomcat/lib as the System Configuration → Driver Class File Directory. However this is deprecated. In a future release, we will remove the ability to use the tomcat/lib directory for driver files.

    We do not recommend using the tomcat/lib directory for driver files.

    Deprecated Database Drivers

    For PhixFlow pre-version 10.1, the repository includes the following deprecated database drivers, for backwards compatibility. 

    • DB2
    • Debug JDBC
    • Google Big Query
    • Hadoop Hive
    • MySQL
    • Netezza
    • Sun ODBC Bridge
    • Teradata
    Note

    These are drivers are read-only and do not connect to any database drivers. If you want to connect to one of these databases, we recommend you create a new database driver in which you can configure all the database drives needed.

    If you want to connect a preconfigured database driver to the appropriate JDBC database driver files, download and save them to tomcat/webapps/phixflow/WEB-INF/lib. Be aware that the deprecated database drivers will be removed in a future release.


    Live Search
    spaceKey@self
    additionalnone
    placeholderSearch all help pages
    typepage

    Panel
    borderColor#00374F
    titleColorwhite
    titleBGColor#00374F
    borderStylesolid
    titleSections on this page

    Table of Contents
    maxLevel3
    indent12px
    stylenone


    Learn More