Unit 3 - Lesson 2 - Data Manager

Question 1

Explain what the Data Manager is and it is used

Answer 1

A tool used to create the database and load initial application and test data.

Executes generated SQL files to create and populate DB tables.

Question 2

Describe how the Data Manager is configured

Answer 2

datamanager_config.xml is used by the Data Manager to identify:
targets that may be processed by the Data Managers and what is involved in executing the target.
errors that may be ignored when the Data Manager executes.
File can be updated to include new targets for the Data Manager.
The DMX files must be in the following folder structure to be included in the merging process:
EJBServer/components/name/data/initial
EJBServer/components/name/data/test

Question 3

Describe the structure of DMX files

Answer 3

Curam database scripts which are interpreted by the Data Manager to load data onto the database
DMX files can be generated by extracting data from the database tables:

Developers can also handcraft DMX files.

Question 4

Extract and load data using the Data Manager

Answer 4

build extract data -Dtablename=”Users,Person,Address”

build reloadextracteddata

Question 5

Which tools Data Manager consist of

Answer 5

Contains multiple tools:
Configuration file
Ant target
Large Object (LOB) Manager
 --- Both Binary (BLOB) and Character (CLOB) Large Objects

Question 6

What data manager includes as data sources

Answer 6

Includes:
SDEJ Infrastructure Tables - supplied as XML files, consist of tables, indexes and database constrains.
Application Tables - Generated from .xml file, extracted from the model by generators.
Initial Data - required to start Curam and login. Data is drawn from code tables, scripts generated from DMX files and handcrafted scrips.
Test Data - may be required to run standard Curam Demo. Source is DMX.

Question 7

Where data manager gets SQL?

Answer 7

SQL found in:
build/datamanager
build/svr/codetable/sql

SQL come from model via build generated
Generated from intermediate database independent files - .dmx .ctx .itx

Question 8

Describe Data Manager Ant Target

Answer 8

Uses datamanager_config.xml
Runs as a target to the normal build
LOB is run as a part of the build database, loads files from clob & blob sub folders.

database.test build clean database with some test data
build extract data -Dtablename=”Users,Address,Person”
Creates dmx files in build/dataextractor

To reload files to the database:
build reloadextracteddata