Deployment Procedure

Contents

Introduction

This deployment procedure applies to the 7.6.000.08 General release of Data Mart, released 06/30/10. It describes how to deploy Data Mart using the package you received from Genesys.

Deployment Procedure – General [06/30/10]

Notes:

• Review all steps and the Reporting 8.0 Deployment Guide and Genesys 8.0 Migration Guide before performing any of the steps in this deployment procedure.

• Plan a time when you can complete this deployment, starting with installation step 5, in one continuous session. Several steps can take significant time to complete, and this potentially affects the availability of your Reporting data.

• If you already have an environment that has Primary and Backup DB Server, Primary and Backup Stat Server, Configuration Manager Applications, ODS, Data Sourcer installed from the Data Sourcer 7.6.000.15 Deployment Procedure, Data Mart database, and the JDBC Database Access Point (DAP) described below, you can reuse your existing environment and can begin this deployment starting from installation step 5.

Pre-Installation Steps

1. Ensure that the system parameters such as the Operating System, CPU, memory and disk space requirements for installing Data Mart are sufficient.
2. Ensure there is enough disk space for log files. Detailed log files may be required for some servers if troubleshooting is required, so it is better to have a large amount of disk space reserved for the log files. Genesys recommends a minimum of 100 GB for each server.
3. Ensure that you have performed the Data Sourcer 7.6.000.15 Deployment Procedure prior to starting this Data Mart 7.6.000.08 Deployment Procedure.

Installation Steps

1. Create the database (schema) for the Data Mart Database.The User that owns the database (schema) should be used in Database Access Point (DAP) configuration below and must have permission to create tables, views, indexes, and synonyms in the database.
2. Create a JDBC DAP that will be used with Data Mart. Refer to the Reporting 8.0 Deployment Guide for information on how to create a JDBC DAP.
3. Make sure the JDBC DAP has the following option set correctly to point to the Data Mart Database:

   [jdbc]
jdbcurl="The JDBC URL in appropriate format for your RDBMS"

4. Create an entirely new Data Mart application in Configuration Manager by importing the template and configuring all the required connections and options. Be sure to include the JDBC DAP you have created above. Refer to the Reporting 8.0 Deployment Guide for more information on how to install and configure the Data Mart application.
5. Install ETL Runtime and ETL Assistant from the Data Mart installation package you have received from Genesys. Refer to the Reporting 8.0 Deployment Guide for instructions on how to install ETL Runtime and ETL Assistant.
6. Initialize the Data Mart. Refer to the Reporting 8.0 Deployment Guide and follow the steps in the "Initializing the Data Mart" section.
7. Using ETL Assistant, configure the ETL options and ODS Data sources as described in the "Specifying a New ODS" topic in Reporting 7.6 ETL Assistant Help.
8. Update the etl.properties file in the Data Mart root directory as required. Refer to the Reporting 8.0 Deployment Guide for more information about the etl.properties file.
9. You have completed the Data Mart 7.6.000.08 Deployment Procedure.

Top of Page

Additional Information

Additional information on Genesys Telecommunications Laboratories, Inc. is available on our Technical Support website. The following documentation also contains information about this software. Please consult the Reporting Deployment Guide first.

• Reporting 8.0 Deployment Guide describes how to configure, install, start, and stop ETL Runtime.

• Reporting 7.6 ETL Runtime User's Guide describes ETL Runtime modules, configuration options, and runtime parameters.

• Reporting 7.6 ETL Assistant Help describes the user interface; how to specify new source connections; how to edit information about existing sources, report folders, and report views; and how to schedule database purges.

• Reporting 8.0 Master Index directs you to the location of specific topics in the Reporting documentation set.

• Reporting 8.0 Reference Manual includes component performance measurements.

• Reporting 7.6 Physical Data Model for a Microsoft SQL Data Mart provides database schema with table and field descriptions for an Microsoft SQL Data Mart.

• Reporting 7.6 Physical Data Model for an Oracle Data Mart provides database schema with table and field descriptions for an Oracle Data Mart.

• Reporting 7.6 Physical Data Model for a DB2 Data Mart provides database schema with table and field descriptions for a DB2 Data Mart.

• Reporting 7.6 Physical Data Model for a Sybase Data Mart provides database schema with table and field descriptions for a Sybase Data Mart.

• Genesys Supported Operating Environment Reference Manual contains information about supported operating systems and databases for this product.

Top of Page