Try Pentaho Data Integration and Analytics

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.

  4. Within that directory, do the following things:

    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.

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>7
    </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>

3. Save and close the `module.xml` file.

PreviousInstall JDBC driver as a module in JBossNextCreate module file for HSQL database

Last updated