Shopping Cart
Your Shopping Cart is empty

Data Dictionary Setup Instructions

Thanks to the DBAs and Web Administrators who helped with this guide!
Show Container Instructions

After table creation, be sure to apply Select, Insert, Update and Delete permissions

Database - MySQL

Create database and schema:

  Create Database data_dictionary;

  USE data_dictionary;

  CREATE TABLE audit_log (
  id varchar(60) COLLATE utf8mb4_general_ci NOT NULL,
  user varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
  object varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
  action varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  oldValue blob,
  newValue blob,
  table_fk varchar(60) COLLATE utf8mb4_general_ci DEFAULT NULL,
  entereddate bigint(20) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE objects (
  id varchar(60)  NOT NULL,
  nodeType varchar(45)  DEFAULT NULL,
  uicontrol varchar(45)  DEFAULT NULL,
  parent_id varchar(60)  DEFAULT NULL,
  related_id varchar(60)  DEFAULT NULL,
  relationshiptype varchar(45)  DEFAULT NULL,
  name varchar(255)  DEFAULT NULL,
  description varchar(255)  DEFAULT NULL,
  jsondata blob,
  effectivedate bigint(20) DEFAULT NULL,
  expirationdate bigint(20) DEFAULT NULL,
  enteredby varchar(45)  DEFAULT NULL,
  changedby varchar(45)  DEFAULT NULL,
  entereddate bigint(20) DEFAULT NULL,
  changeddate bigint(20) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY idx_objects_parent_id (parent_id),
  KEY idx_objects_nodeType (nodeType),
  KEY idx_objects_name (name)
);


 CREATE TABLE scan_history (
  id varchar(60) COLLATE utf8mb4_general_ci NOT NULL,
  data_source_fk varchar(60) COLLATE utf8mb4_general_ci DEFAULT NULL,
  scannedby varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
  entereddate bigint(20) DEFAULT NULL,
  PRIMARY KEY (id)
);


        

Copy MySQL driver to server lib directory

Tomcat MySQL server.xml setup - Tomcat example below

Apply Select, Insert, Update permissions


Container - Tomcat MySQL Example

Copy database driver to server/lib directory

Copy DBCP Pool driver to server/lib directory

Add to server context.xml file:


Add JNDI or context variables (conf/context.xml in Tomcat):
Note different in units of time, hours vs. minutes.
<Environment name="LuceneDictionaryPath" value="temp" type="java.lang.String"/>
<Environment name="IndexerPollMinutes" value="15" type="java.lang.Long"/>
<Environment name="DataSourcePollHours" value="12" type="java.lang.Long"/>
<ResourceLink name="jdbc/AckDevDataDictionary"
global="jdbc/AckDevDataDictionary"
type="javax.sql.DataSource"/>

Add to server.xml file or JNDI configuration (MySQL Example):

<Resource name="jdbc/AckDevDataDictionary"
global="jdbc/AckDevDataDictionary"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.cj.jdbc.Driver"
url="jdbc:mysql://YOUR_SERVER_ADDRESS:YOUR_SERVER_PORT/data_dictionary"
username="YOUR_DB_LOGON"
password="YOUR_DB_PASSWORD"
maxActive="100"
maxIdle="20"
minIdle="5"
maxWait="-1" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
timeBetweenEvictionRunsMillis="300000"
minEvictableIdleTimeMillis="30000"
/>
Note driver class name will change based on technology and version.

Restart server

copy dataDictionary.war to webapps directory

Additional help and tuning options for tomcat available here