Configuring the MDS Repository Explorer - Teradata Meta Data Services

Teradata Meta Data Services

Product
Teradata Meta Data Services
Release Number
15.00
Published
February 2015
Language
English (United States)
Last Update
2018-09-27
dita:mapPath
B035-3045-114K/MDS_Installation_1500.ditamap
dita:ditavalPath
ft:empty
Product Category
Teradata Tools and Utilities

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

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

  1. To create an MDM database schema, create a user 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
    You specified the username in the MDS Repository Explorer Web Application dialog box when installing MDS.
  2. Navigate to the directory where you installed Repository Explorer and double-click re_config.bat.This script will verify the MDM database connection, then apply all the changes specified from the installation, as saved in installer.properties, to the appropriate Repository Explorer files. The file-replacement results are logged to the config.log file. If the connection fails, or config.log contains errors, they must be corrected before you can proceed.
  3. From the installation directory, navigate to \web\mdmclient\bin and double-click mkcolocjar.bat.A new coloc.jar file is created in \web\mdmclient\WEB-INF\lib .
  4. If this is the first time installing RE, you must do the following to populate the MDM repository user database.
    1. From the installation directory, navigate to \bin, open dbadd.txt, then set the following before saving and 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. Double-click \bin\call_tk_gendb.bat.The MDM repository user database will populate in about twenty minutes. You can check log\gendb.log for errors.
  5. To complete the MDS-specific additions to the MDM database, do the following:
    1. From the \bin directory, double-click startAll.bat.An MDM Server window appears. Wait for the MDM Server window to display "Accepting connections on port."
    2. From the \bin directory, double-click addMDSUserSecurityInfo.bat
    3. From the \bin directory, double-click stopAll.batThe MDM Server window closes.
    4. 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.
  6. If the Tomcat web server has not previously been set up to run Repository Explorer, do the following:
    1. 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>
    2. To deploy Repository Explorer to the Tomcat web server, 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 directory where you installed Repository Explorer.
    3. Move the file to \conf\Catalina\localhost in the directory where you installed Tomcat.