Try Pentaho Data Integration and Analytics

Step 1: Create module file for Pentaho Repository database

You need to create a file for the database that hosts the Pentaho Repository (either PostgreSQL, MySQL, or Oracle), as well as for HSQLDB.

  1. Locate the pentaho/server/pentaho-server/<your jboss installation directory>/modules/system/layers/base/org folder and create one of the following paths for the database on which you are hosting the Pentaho Repository.

    • PostgreSQL: postgresql/main

    • MySQL: mysql/main

    • Oracle: oracle/main

    • MS SQL Server: sqlserver/main

  2. Create these two paths in the same directory.

    • HSQLDB: hsqldb/main

    • H2: h2/main

  3. Download the supported JDBC driver for your Pentaho Repository database to the directory that you just created.

    The JDBC drivers reference has a list of supported drivers.

  4. Within that directory, perform the following steps.

    1. Use an editor to create a text file named module.xml.

    2. Copy the appropriate code into the module.xml file, then modify it so that the name of the JDBC driver you just downloaded appears.

    3. Save and close the module.xml file.

Repository Type

Module code

PostgreSQL


<?xml version="1.0" encoding="UTF-8"?>
    <module xmlns="urn:jboss:module:1.0" name="org.postgresql">
        <resources>
            <resource-root path="[Name of JDBC Jar You Downloaded Here]"/>
        </resources>
        <dependencies><module name="javax.api"/></dependencies>
    </module>

MySQL


<?xml version="1.0" encoding="UTF-8"?>
    <module xmlns="urn:jboss:module:1.0" name="org.mysql">
        <resources>
            <resource-root path="[Name of JDBC Jar You Downloaded Here]"/>
        </resources>
        <dependencies><module name="javax.api"/></dependencies>
    </module>

Oracle


<?xml version="1.0" encoding="UTF-8"?>
    <module xmlns="urn:jboss:module:1.0" name="org.oracle">
        <resources>
            <resource-root path="[Name of JDBC Jar You Downloaded Here]"/>
        </resources>
        <dependencies><module name="javax.api"/></dependencies>
    </module>

MS SQL Server


<?xml version="1.0" encoding="UTF-8"?>
    <module xmlns="urn:jboss:module:1.0" name="org.sqlserver">
        <resources>
            <resource-root path="[Name of JDBC Jar You Downloaded Here]"/>
        </resources> 
        <dependencies><module name="javax.api"/></dependencies>
    </module>
PreviousInstall JDBC driver as a module in JBossNextStep 2: Create module file for HSQL database

Last updated

Was this helpful?