Data Fabric
MDM Platform
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:
Make sure you see the output:CREATE TABLESPACE MDMMASTER DATAFILE '/home/talend/oracle/oradata/XE/MDMMASTER.DBF' SIZE 20M AUTOEXTEND ON NEXT 5M MAXSIZE 100M;
"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.