Using Oracle for the MDM server - 7.0

Talend MDM Platform Installation Guide for Windows

EnrichVersion
7.0
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend ESB
Talend Identity and Access Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

When you select to use Oracle as the database for the MDM server, you must make specific configurations before starting the MDM server.

You can use a single Oracle database with different tablespaces: one tablespace for the master container, one for system objects, and another for the staging container.

The configurations for different Oracle versions are the same. For more information about the supported Oracle versions, see Compatible databases.

MDM also supports other types of databases. For more information, see Managing MDM databases.

Procedure

  1. Using your Oracle development tool (Oracle SQL developer, for example), create a user per container.
    In this example, create three users: mdm_master, mdm_staging, and mdm_system.
  2. Create a tablespace for each user.
    For example, create a tablespace MDMMASTER for the user mdm_master:
    CREATE TABLESPACE
    MDMMASTER DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\MDMMASTER.DBF'  SIZE 20M
    AUTOEXTEND ON NEXT 5M
    MAXSIZE 100M;
    Make sure you see the output: "tablespace MDMMASTER created."
  3. Grant access right to users on the tablespaces.
    ALTER USER mdm_master
    QUOTA 100M ON MDMMASTER; 

    Make sure you see the output: "user mdm_master altered."

  4. Alter the users so that each one uses a different tablespace.
    In this example, mdm_master uses the tablespace MDMMASTER, and mdm_staging uses MDMSTAGING.
  5. Make sure that each user has the permissions for "System Privileges"..
  6. On the MDM server, update the datasource configuration file <$INSTALLDIR>\conf\datasources.xml.
    The template is as follows:
        <datasource name="Oracle-Default">
            <master>
                <type>RDBMS</type>
                <rdbms-configuration>
                    <dialect>Oracle11g</dialect>
                    <connection-driver-class>oracle.jdbc.driver.OracleDriver</connection-driver-class>
                    <connection-url>jdbc:oracle:thin:@localhost:1521:TMDM_DB</connection-url>
                    <connection-username>mdm_master</connection-username>
                    <connection-password></connection-password>
                    <connection-pool-minsize>5</connection-pool-minsize>
                    <connection-pool-maxsize>50</connection-pool-maxsize>
                    <fulltext-index-directory>E:\Talend\Talend-MDMServer\data\indexes\Oracle-Default</fulltext-index-directory>
                    <schema-generation>update</schema-generation>
                    <properties>
                        <property name="hibernate.show_sql">false</property>
                        <property name="hibernate.default_schema">mdm_master</property>
                    </properties>
                </rdbms-configuration>
            </master>
            <staging>
                <type>RDBMS</type>
                <rdbms-configuration>
                    <dialect>Oracle11g</dialect>
                    <connection-driver-class>oracle.jdbc.driver.OracleDriver</connection-driver-class>
                    <connection-url>jdbc:oracle:thin:@localhost:1521:TMDM_DB</connection-url>
                    <connection-username>mdm_staging</connection-username>
                    <connection-password></connection-password>
                    <connection-pool-minsize>5</connection-pool-minsize>
                    <connection-pool-maxsize>50</connection-pool-maxsize>
                    <schema-generation>update</schema-generation>
                    <properties>
                        <property name="hibernate.show_sql">false</property>
                        <property name="hibernate.default_schema">mdm_staging</property>
                    </properties>
                </rdbms-configuration>
            </staging>
            <system>
                <type>RDBMS</type>
                <rdbms-configuration>
                    <dialect>Oracle11g</dialect>
                    <connection-driver-class>oracle.jdbc.driver.OracleDriver</connection-driver-class>
                    <connection-url>jdbc:oracle:thin:@localhost:1521:TMDM_DB</connection-url>
                    <connection-username>mdm_system</connection-username>
                    <connection-password></connection-password>
                    <connection-pool-minsize>5</connection-pool-minsize>
                    <connection-pool-maxsize>50</connection-pool-maxsize>
                    <schema-generation>update</schema-generation>
                    <properties>
                        <property name="hibernate.show_sql">false</property>
                        <property name="hibernate.default_schema">mdm_system</property>
                    </properties>
                </rdbms-configuration>
            </system>
        </datasource>

    For more information about the file, see Talend Help Center.

    Note: The staging area does not define any full text index directory.
  7. Update the configuration file <$INSTALLDIR>\conf\mdm.conf as follows:
    db.autoPrepare=false
    db.default.datasource=Oracle-Default
  8. Restart the MDM server.