Completing the prerequisite tasks
This content applies only to On-premises and Client-managed cloud environments
Pega Customer Decision Hub
Installation Guide
- Ensure that you can stop and start the application server.
- In your external database, create the schema where your customer data resides, for example, ExternalMKTData, and ensure that the Pega Deployment User has full permissions for this schema.
- Before starting an installation, and before backing up your system, review the database policies and application permissions that are used by your Pega Platform installation. Determine whether the application is permitted to update the database automatically or if you must generate the database scripts that your organization will use to manually make schema changes.
- Install the latest
version of Pega Platform
8.6, and ensure that you can log in as an administrator. For
more information, see the Pega Platform
Install Guide for
your environment on the Deploy Pega Platform page.
- If the ExternalMKTData DADN is configured to use Configuration
preferences, in Pega Platform, create the following
Dynamic System Settings to specify the default schema used by the ExternalMKTData database
rule:
Owning ruleset Setting purpose Value Pega-Engine prconfig/database/databases/ExternalMKTData/defaultSchema/default name of the schema where the customer data resides prconfig/database/databases/ExternalMKTData/datasource/default java:comp/env/jdbc/PegaRULES - Restart Pega Platform to enable the setting.
- Before you install Pega Customer Decision Hub, ensure that you have the following
database information available:
- Such database connection information as:
- Hostname or IP address
- Database port
- Database name
- JDBC driver JAR file for your database type
- PegaRULES schema name
- If using split schema, PegaDATA schema name
- Ensure that the Pega Customer Decision Hub external schema meets the following
requirements:
- This is the schema that contains your customer data repository and other marketing assets.
- This schema must exist in the same database as the PegaDATA and PegaRULES schemas.
- This schema must have the database privileges to create views and to select from tables in the PegaDATA schema.
- Ensure that the Pega Customer Decision Hub external user and password meet the following
requirements:
- This user must already exist.
- This is the user that Pega Platform uses to connect to the Pega Customer Decision Hub external schema.
- This user must have full privileges to the Pega Customer Decision Hub external schema.
- This user must have the database privileges to create views and to select from tables in the PegaDATA schema.
- Ensure that the Pega Deployment user and password meet the following
requirements:
- This user must already exist.
- This user must have permissions to create and modify objects in all Pega schemas.
- If using Oracle, this user must have permission to create materialized views.
- Ensure that the user associated with PegaDATA DB rule meets the following
requirements:
- This user must be set in application server configuration.
- For Tomcat, this would typically be in the context.xml file.
- The user that is mapped to the PegaDATA DB rule must already exist.
- This user must have the following privileges on the PegaDATA schema:
- Select, Create, and Drop on tables, indexes, and views
- Insert, Update, and Delete on tables
- Alter on tables and indexes
- This user must be set in application server configuration.
- Ensure that the user associated with PegaRULES DB rule meets the following
requirements:
- This user must be set in application server configuration.
- For Tomcat, this would typically be in the context.xml file.
- The user that is mapped to the PegaRULES DB rule must already exist.
- This user must have the following privileges on the PegaRULES schema:
- Select, Create, and Drop on tables, indexes, and views
- Insert, Update, and Delete on tables
- Alter on tables and indexes
- This user can be the same as the PegaDATA user, provided the user has permissions to both schemas.
- This user must be set in application server configuration.
- Such database connection information as:
- For IBM Db2 databases, if you use JDBC URL to connect to your external database, add
the following parameters to the template URL and the
prweb.xml
file where the Pega DB connections are defined:- resultSetHoldability=1;
- resultSetHoldabilityForCatalogQueries=1;
- allowNextOnExhaustedResultSet=1;
jdbc:db2://localhost:50000/MYDB:fullyMaterializeLobData=true;
fullyMaterializeInputStreams=true;
progressiveStreaming=2;
progressiveLocators=2;
useJDBC4ColumnNameAndLabelSemantics=false;
currentSchema=MKTDATA;
resultSetHoldability=1;
resultSetHoldabilityForCatalogQueries=1;
allowNextOnExhaustedResultSet=1;
- Request the required hotfixes. The list of required hotfixes can be found here: Required Pega Customer Decision Hub and Pega Marketing hotfixes and here Required Pega 1:1 Operations Manager hotfixes.
Previous topic Pega Customer Decision Hub Installation Guide Next topic Installing the application