3 Configuring Your EDQ Database Schemas

This chapter describes how to create and configure your EDQ database schemas. Use one of the following sections to configure your database:

Section 3.1, "Configuring an Oracle Database"
Section 3.2, "Configuring a PostgreSQL Database"

3.1 Configuring an Oracle Database

To use an Oracle Database with EDQ, you must create the necessary database repository and schema using the following sections.

Note:

Do not use RCU when upgrading EDQ; use the instructions in Section 7, "Upgrading EDQ."

3.1.1 Starting RCU On Linux and UNIX

To start the RCU program on a Linux or UNIX system using a .sh installation file, follow these steps:

Log in to the target system as your EDQ installation user. See Section 2.2.3, "Choosing User Accounts".
Go to the RCU_HOME/bin directory.

Note:

Ensure that all files in the directory have executable permissions for the user you logged in with before continuing.
Start the installation by entering the following command:

./rcu

The RCU program is displayed.
Go to Section 3.1.3, "Completing the RCU Configuration" and complete the installation.

3.1.2 Starting RCU On Windows

To start the RCU program in on a Windows platform, follow these steps:

Log in to the target Windows system as your EDQ installation user. See Section 2.2.3, "Choosing User Accounts".
Locate the MS-DOS Command Prompt (cmd.exe), and then double-click on it.
Go to the RCU_HOME\bin directory.
Start the installation by entering the following command:

rcu.bat

The RCU program is displayed.
Go to Section 3.1.3, "Completing the RCU Configuration" and complete the installation.

3.1.3 Completing the RCU Configuration

Complete the RCU configuration using the instructions in Table 3-1, "Running the RCU Program"; some screens are displayed only in certain situations, as noted in the table.

To view any of the installation screens, see Section A.1, "RCU Screens."

Table 3-1 Running the RCU Program

Screen	Instructions and Action Required
Welcome	Click Next to proceed with the installation. You may cancel the installation at any time by clicking Exit.
Create Repository	Click Next to continue. This uses the default Create option.
Database Connection Details	Specify the host name where your Oracle database is running. Enter the port number for your database; the default port number is 1521. Specify the service name for the database. Typically, the service name is the same as the global database name. For example, oracle.example.com. Enter the user name for your database; the default user name is SYS. Enter the password for your database user. Select SYSDBA from the Role: list; this is automatically selected when the user is SYS. Click Next to continue.
Checking Global Prerequisites	When the prerequisites checking progress has reached completion, click OK to continue.
Select Components	Select the Oracle Enterprise Data Quality, EDQ Config Repository, and EDQ Results Repository check boxes. You can select other check boxes as required if you want to install any optional components. For example, if you intend to use WebLogic Policy Manager, then you may need to select additional corresponding schemas like Metadata Services. If you intend to install Oracle Platform Security Services for Audit, then you need the Audit Services schema. Click Next to continue.
Checking Component Prerequisites	When the prerequisites checking progress has reached completion, click OK to continue.
Schema Passwords	Enter the password you want to use for all database schemas in both password fields, then click Next to continue.
Map Tablespaces	The default EDQ tablespaces are displayed by component. You can change the tablespaces using the Manage Tablespaces button and modifying the information. Click Next to continue.
Map Tablespaces	Click OK to create any non-existent tablespaces in your schema, then click OK when the operation completes.
Summary	Review the database details then click Create to continue.
Completion Summary Completion	Click Close to exit the RCU program.

3.2 Configuring a PostgreSQL Database

To use a PostgreSQL Database with EDQ, you must ensure that database listening is turned on, create the necessary database repository, and schema using the following sections.

3.2.1 Starting PostgreSQL and Checking Local Connections On Linux and UNIX

To start the PostgreSQL program on a Linux or UNIX system and check that the local connections are properly configured, follow these steps:

Log in to the target system as your database user. See Section 2.2.3, "Choosing User Accounts".
Ensure your database server is running. For more information, see the PostgreSQL web site at

http://www.postgresql.org/docs/9.1/static/server-start.html
Go to the PostgreSQL data directory. For example, /var/lib/pgsql/data.

Examine the pg_hba.conf file by entering the following command:

tail pg_hba.conf

The file contents are displayed and the following is an excerpt:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connnections only
local  all              all                                     ident 

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

Ensure that the IPv4 and IPv6 local connections are configured as in the code excerpt in the previous step to ensure database listening is on and that passwords are accepted for authentication.
Go to Section 3.2.3, "Configuring PostgreSQL" to complete the configuration.

3.2.2 Checking Local Connections PostgreSQL On Windows

To check that the local connections are properly configured on a Windows platform, follow these steps:

Log in to the target Windows system as your database user. See Section 2.2.3, "Choosing User Accounts".
Locate the MS-DOS Command Prompt (cmd.exe), and then double-click on it.
Ensure your database server is running. For more information, see the PostgreSQL web site at

http://www.postgresql.org/docs/9.1/static/server-start.html
Go to the PostgreSQL data directory. For example, C:\Program Files\PostgreSQL\9.3\data.

Examine the pg_hba.conf file by entering the following command:

TYPE pg_hba.conf

The file contents are displayed and following is an excerpt:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
 
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5

Ensure that the IPv4 and IPv6 local connections are configured as in the code excerpt in the previous step to ensure database listening is on and that passwords are accepted for authentication.
Go to Section 3.2.3, "Configuring PostgreSQL" to complete the configuration.

3.2.3 Configuring PostgreSQL

This section describes how to configure remote connections, and creating the necessary EDQ users, database, and schemas.

3.2.3.1 Configuring Remote Connections

If your PostgreSQL database has been installed on a different system, then it must be configured to accept connections from other hosts. This is applicable to all PostgreSQL environments.

Configure remote database connections using these steps:

Locate the data directory for your PostgreSQL database.
Edit the postgresql.conf file.
Locate the following line:

#listen_addresses = 'localhost'
Insert the following line to cause PostgreSQL to accept connections from remote hosts:

listen_addresses = '*'
Edit the pg_hba.conf file then add the following line using addr/mask to identify the subnet of the host running EDQ:

host all all addr/mask md5

For example, host all all 192.168.0.0/24 md5 allows connections from all hosts with the IP addresses 192.168.0.0 to 192.168.0.255 while host all all 0.0.23.56/32 md5 accepts connections only from IP address 10.0.23.56.

3.2.3.2 Creating the EDQ Users, Database, and Schemas

Note:

The actual tables are created post-installation using the EDQ Configuration Application in Chapter 5, "Configuring EDQ Post-Installation."

Run psql for your PostgreSQL installation.
Enter your PostgreSQL credentials, that you configured during installation, when prompted.
Create the two necessary EDQ users with the following commands changing password to be the password you want to use for each user :

create user config password 'config';

create user results password 'results';
Create your EDQ database and the config user using this command:

create database edq encoding 'UTF-8' owner config template template0;
Create the schema using the following:

create schema authorization config;

create schema authorization results;
Test your database configuration by logging out then back in using your new EDQ credentials.

3.3 Next Step

Go to Section 4, "Running the EDQ Installer" to continue with the installation.