Database Deployments

This page provides step-by-step instructions related to the deployment of the Genesys Decisions database and the Data Mart database. You can find additional information in the installation instructions that are provided in the Release Package. You will find the following information on this page:

• Installation Checklist
• Using the Database Deployment Wizard

Installation Checklist

Before you begin installation, review this section to ensure that you have everything you need to complete the installation.

Task	Steps	Completed ()	Notes
Permissions	Ensure that the individual who will deploy the Decisions database has been assigned the dbcreator permissions on the database server. Ensure that the individual who will deploy the Data Mart database has been assigned the serveradmin permission on the database server.
Release Package	Download the release package. Review the installation instructions.
Collect information	Collect the following information about your organization: Hours per week (FTE) Start day of the planning week Applicable Active Directory (AD) groups, including the domain Decisions database server and database name

Using the Database Deployment Wizard

Procedure:

Purpose: This procedure describes the screens in the Decisions database deployment wizard.

You require a Decisions database in your deployment in order to run the Decisions application in a production environment. The Decisions Data Mart database is optional in a Decisions deployment. While it is not necessary to deploy both databases simultaneously (that is, in one run of the deployment wizard), it is possible to do so.

Steps

1. Run the database deployment wizard:
   1. Double-click the DecisionsDatabaseDeployer.exe file, located in the Release Package, to open the deployment wizard.
   2. Select the database to install.
   3. Click Install.
2. If you opted to install the Decisions database on the Select database(s) to install/upgrade screen, then you are presented with a screen in which you enter the Decisions database information:
   1. Enter the SQL Server instance name.
   2. Enter the database name.
   3. If you select Windows Authentication, the deployment wizard will use the Windows credentials of the logged-in user to access the database server and execute the commands. You have the option to supply a SQL login name and password to perform the operations, instead of the Windows login.
   4. Click Next.
3. If you opted to install the Decisions Data Mart database on the Select Database(s) to install/upgrade screen, then you are presented with a screen in which you enter the Decisions Data Mart database information:
   1. Enter the SQL Server instance name.
   2. Enter the Data Mart database name.
   3. If you select Windows Authentication, the deployment wizard will use the Windows credentials of the logged in user to access the database server and execute the commands. You have the option to supply a SQL login name and password to perform the operations, instead of the Windows login.
   4. Click Next.
4. Configure the Decisions database:
   1. Select the day that begins the planning week (see the Installation Instructions provided in the Release Package).
   2. Enter the number of hours in each week for FTE (see the Installation Instructions provided in the Release Package).
   3. Enter the Admin Active Directory (AD) group name (domain name must be included). You can enter only one group name.
   4. Enter the User Active Directory (AD) group name (domain name must be included). You can enter only one group name.
   5. Click Next.
5. Complete the database deployment:
   1. Review the summary data screen. If the data is correct, proceed with installation. Otherwise, go back to any page that contains incorrect data and correct the information before proceeding.
   2. Click Install.
   3. Wait for the Process Complete window to display.
   4. Click Exit.

Next Steps

If the process does not complete successfully, review the log file in the temporary folder for an error message.