Using Oracle for the MDM server

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

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.
Create a tablespace for each user.
For example, create a tablespace MDMMASTER for the user mdm_master:
```
CREATE TABLESPACE
MDMMASTER DATAFILE '/home/talend/oracle/oradata/XE/MDMMASTER.DBF'  SIZE 20M
AUTOEXTEND ON NEXT 5M
MAXSIZE 100M;
```
Make sure you see the output: "tablespace MDMMASTER created."
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."
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.
Make sure that each user has the permissions for "System Privileges".

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

Update the configuration file <$INSTALLDIR>/conf/mdm.conf as follows:
```
db.autoPrepare=false
db.default.datasource=Oracle-Default
```
Restart the MDM server.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here