Data Quality Assessment (DQA)

aquahellishΛογισμικό & κατασκευή λογ/κού

13 Δεκ 2013 (πριν από 3 χρόνια και 8 μήνες)

110 εμφανίσεις

Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
1

12/13/2013







Data Quality Assessment



(DQA)



Build and Deployment Guide





Table of Contents

Prerequites

................................
................................
................................
...........................

2

Retrieving the Source Code

................................
................................
................................

3

Perparing the Build Files
................................
................................
................................
.....

5

Compiling the Bu
ild

................................
................................
................................
.............

7

Application Deployment

................................
................................
................................
......

9

Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
2

12/13/2013


Prerequisites



E
ach of the
following
is a

prerequ
i
site

for
DQA
source code compilation. Make sure
each of
the following is
installed and
configured

prior to any attempts
to

compile the source code.



Java Platform (JDK)

Version 6.26 or later

http://www.oracle.com/technetwork/java/javase/downloads/index.html



Apache Ant

Version 1.8.2 or lat
er

http://ant.apache.org/ivy/download.cgi



Apache Maven

Version 1.8.2 or later

http://maven.apache.org/download.html



The DQA module requires a
ccess to a data store in order to compile

and operate. Install o
ne of
the following database platforms and configure

the database using the initial SQL file
*

prior to
any attempts to

compile the
source code or
deploy the DQA Module
.


* The initial.sql fi
le is located in the source’s db under the appropriate platform name.



MySQL

http://www.mysql.com/



HyperSQL

http://hsqldb.org/



Oracle

http://www.oracle.com/index.html



The DQA requires a server platform in which to run.

Apache Tomcat 7 is the recommended
platform. Evaluations for other platforms have not been made at this time.



Apache Tomcat

http://tomcat.apache.org/download
-
70.cgi

Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
3

12/13/2013


Retrieving the Source Code



Open a

web browser and navigate to

http://ois
-
dqa.svn.sourceforge.net/




Click the release folder

Cli
ck the folder with the latest version number

Click the “Download GNU tarball”




Extract the

B
uild
S
ource

Files


Prerequisite: standard

compression software



7Zip

GZip

WinZip

StuffIt


Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
4

12/13/2013

Using the chosen compression software:


1.

Extract

the GNU zip (.
gz
) file

to a temporary folder.

a.

The file should a file named ois
-
dqa
-
vX_X.tar where X
represents the DQA version number


2.

Extract the build source file

from the TAR file

a.

The folder should be named vX_X


3.

Make sure the build source includes


Folders

Data

SRC

DB

Files

build.xml

pom.xml



Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
5

12/13/2013


Preparing the
Build
Files




Database Settings



Locate the hibernate configuration file (hibernate.cfg.xml)



Location:

\
src
\
main
\
resources




Delete the hibernate configuration file and rename the configuration file appropriate f
or
your database platform to hibernate.cfg.xml


Open the hibernate configuration file

and change the following property values


1.

Change the URL property to match your database’s location

2.

Change the user name property to match your application’s database use
r name

3.

Change the password property to match your application’s database password
for that user name

4.

Change the Show SQL property to “false”



Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
6

12/13/2013

Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
7

12/13/2013


Compiling the Build


Update the Database


Obtain the db
up
gr
a
d
e script

[If available]

Upgrade the database

by

running the SQL script


Location:
\
db
\
<<Your Database Platform>>
\
upgrade
-
X
.
Xsql



Compilation [Windows]


1.

Open a Command Prompt window

a.

Click the Windows Start menu

b.

Click the Run menu

item

c.

Type cmd

d.

Press OK







2.

Navigate to the
build root folder (vX_X)


Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
8

12/13/2013



3.

Run the Maven install command


Command: mvn install




4.

Get the WAR file



L
ocation
:

\
target
\
ois
-
dqa
-
X
.
X
.war


NOTE:

Oracle users may encounter issues during deployment if the appropriate JDBC
drivers are not included in the build. Please check that the

build library contain
s
the ojdbcXX.jar. If
the driver is

not

included,

place a copy

of the driver

into the
build library
and compile the code again.


Location:

\
target
\
ois
-
dqa
-
X
.
X
\
WEB
-
INF
\
lib
\
ois
-
dqa
-
X
.
X
.war



Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
9

12/13/2013


Application

Deployment



Update the
Databa
se


1.

Stop the Tomcat service

2.

Obtain the db upgrade script [If available]

3.

Upgrade the database by running the SQL script


Upgrade script location:
\
db
\
<<Your Database Platform>>
\
upgrade
-
X.Xsql



Deploy

the
DQA Module


1.

Stop the Tomcat service

2.

Save a copy of
the

current hibernate configuration file to a backup location

3.

Navigate to the webapps folder [/{tomcat home}/webapps]

a.

Delete DQA folder

b.

Delete DQA.war

c.

Move

in

the new
file [
ois
-
dqa
-
X
.
X
.war
]

d.

Rename
ois
-
dqa
-
X
.
X
.war

to DQA.war

4.

Start the Tomcat service

5.

Wait
for the
DQA.war

file to unpack

a.

The DQA folder will be created

6.

Stop the Tomcat service

7.

Edit the Hibernate configuration file


Open the hibernate configuration file and change the following property values




Change the user name property to match your applica
tion’s database user name



Change the password property to match your application’s database password
for that user name



Change the Show SQL property to “false”



Data Quality Assurance

Deployment Guide

C:
\
Program Files
\
neevia.com
\
docConverterPro
\
temp
\
NVDC
\
E88320A6
-
9BAB
-
48AF
-
8AAE
-
1BEC69413DAC
\
aquahellish_e4913c6c
-
44d3
-
4db0
-
8262
-
c3560d983bda.doc


Page
10

12/13/2013

8.

Start the Tomcat service

9.

Test???


Hibernate configuration location:


/{tomcat home}/webapp
s/dqa/WEB
-
INF/class/hibernate.cfg.xml