Configuring the MDS Repository Explorer - Teradata Meta Data Services

This procedure is required only if you will be using the MDS Repository Explorer.

Master Data Manager provides the infrastructure for the Repository Explorer web application. If the MDM user-database does not exist, you must create it before performing any of the configuration steps.

To create an MDM database schema, create a user as follows using an SQL tool like Basic Teradata Query Utility: > create user username as password = password, perm=200000000; > grant all on username to username with grant option; > grant SELECT on dbc to username
Navigate to the directory where you installed MDS and extract RepositoryExplorer.zip to any directory that is accessible by the Tomcat web server.
Create a text file named installer.properties in the directory where you extracted RepositoryExplorer.zip as in the following example:
```
JavaHome=/home/java/jdk1.6.0_45/
REHome=/home/mds/re/
DBUserName=repexp_mdm
DBUserPWD=df0880wfkj34
TDSystemName=sdll1486
REPort=14454
```
where JavaHome is the location of the JDK on your system, REHome is the location of the un-zipped RepositoryExplorer on your system, DBUserName and DBUserPWD are the MDM user name and password of your MDM database, and TDSystemName is the name of the host where MDM database is located
The port number is for the MDM infrastructure S/W and should not be changed unless that port is in use.
Navigate to /bin in the directory where you installed Repository Explorer and run re_config.sh
Navigate to /web/mdmclient/bin in the directory where you installed Repository Explorer and run mkcolocjar.sh.A new coloc.jar file is created in /web/mdmclient/WEB-INF/lib .
If this is the first time installing Repository Explorer, populate the MDM repository user database:
1. Navigate to /bin in the directory where you installed Repository Explorer, open dbadd.txt, and set the following before saving or closing the file:
  - db.userId and db.userPassword to the user and password you defined when creating the MDM database schema
  - db.url to the connection string shown in the example in dbadd.txt:
    #db.url=jdbc:teradata://DB_HOST/TMODE=TERA
  - DB_HOST to the network host name where your MDM database resides
2. Navigate to /bin in the directory where you installed Repository Explorer and run call_tk_gendb.sh.The MDM repository user database will populate in about twenty minutes. You can check log/gendb.log for errors.
To complete the MDS-specific additions to the MDM database, do the following:
1. Navigate to /bin in the directory where you installed Repository Explorer and run startAll.sh.
2. Navigate to /bin in the directory where you installed Repository Explorer and run addMDSUserSecurityInfo.sh.
3. Navigate to /bin in the directory where you installed Repository Explorer and run stopAll.sh.
Using an SQL tool like Basic Teradata Query Utility, log into Teradata as your MDM database user and run \cfg\xservice\MDS_UI\data\left_nav_url.sql in the directory where you installed Repository Explorer.

Navigate to the Tomcat installation directory and edit \conf\web.xml, changing the jsp servlet information to include additional JSP servlet parameters for MDM, so that it appears as follows:

<servlet>
        <servlet-name>jsp</servlet-name>
        <servlet-class>org.apache.jasper.servlet.JspServlet</servlet-class>
        <init-param>
            <param-name>fork</param-name>
            <param-value>false</param-value>
        </init-param>
		<init-param>
			<param-name>compilerSourceVM</param-name>
			<param-value>1.5</param-value>
		</init-param>
        <init-param>
            <param-name>xpoweredBy</param-name>
            <param-value>false</param-value>
        </init-param>
		<init-param>
			<param-name>tagpoolMaxSize</param-name>
			<param-value>0</param-value>
		</init-param>
        <load-on-startup>3</load-on-startup>
    </servlet>

Deploy Repository Explorer to the Tomcat web server:
1. Create a deployment configuration file named mds.xml that contains the following:
```
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/mds" privileged="true" docBase="RE_Install_dir/web/mdmclient" crossContext="true">
    <Manager pathname="" maxInactiveInterval="-1"/>
</Context>
```
  where RE_Install_dir is the full path to the directory where you installed Repository Explorer.
2. Move the file to /conf/Catalina/localhost in the directory where you installed Tomcat.