DQA Build Guide

Document Sample
DQA Build Guide Powered By Docstoc
					Data Quality Assurance                                                                                   Deployment Guide
                                                            C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




                             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 Build ............................................................................................................. 7
  Application Deployment ...................................................................................................... 9




                                                         Page 1                                                 6/13/2013
Data Quality Assurance                                                            Deployment Guide
                                             C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




Prerequisites

Each of the following is a prerequisite 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 later
         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 access to a data store in order to compile and operate. Install one 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 file 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




                                           Page 2                                       6/13/2013
Data Quality Assurance                                                          Deployment Guide
                                           C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




Retrieving the Source Code

   Open a web browser and navigate to http://ois-dqa.svn.sourceforge.net/




   Click the release folder
   Click the folder with the latest version number
   Click the “Download GNU tarball”




   Extract the Build Source Files

          Prerequisite: standard compression software

              7Zip
              GZip
              WinZip
              StuffIt




                                         Page 3                                       6/13/2013
Data Quality Assurance                                                         Deployment Guide
                                          C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc



         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




                                         Page 4                                      6/13/2013
Data Quality Assurance                                                         Deployment Guide
                                          C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




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 for
      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 user 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”




                                        Page 5                                       6/13/2013
Data Quality Assurance                                         Deployment Guide
                          C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




                         Page 6                                      6/13/2013
Data Quality Assurance                                                        Deployment Guide
                                         C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




Compiling the Build
      Update the Database

      Obtain the db upgrade 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)




                                       Page 7                                       6/13/2013
Data Quality Assurance                                                        Deployment Guide
                                         C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




      3. Run the Maven install command

             Command: mvn install




      4. Get the WAR file

             Location: \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 contains
          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




                                       Page 8                                       6/13/2013
Data Quality Assurance                                                         Deployment Guide
                                          C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc




Application Deployment

      Update the Database

      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 application’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”




                                        Page 9                                       6/13/2013
Data Quality Assurance                                                     Deployment Guide
                                      C:\Docstoc\Working\pdf\d7d8516a-ed81-4e90-9370-b165efa5cdf7.doc



      8. Start the Tomcat service
      9. Test???

         Hibernate configuration location:

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




                                    Page 10                                      6/13/2013

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:6/13/2013
language:Latin
pages:10
changcheng2 changcheng2
About