This chapter describes how to create and configure your EDQ database schemas. Use one of the following sections to configure your 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."
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.
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.
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 |
---|---|
Click Next to proceed with the installation. You may cancel the installation at any time by clicking Exit. |
|
Click Next to continue. This uses the default Create option. |
|
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. |
|
When the prerequisites checking progress has reached completion, click OK to continue. |
|
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. |
|
When the prerequisites checking progress has reached completion, click OK to continue. |
|
Enter the password you want to use for all database schemas in both password fields, then click Next to continue. |
|
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. |
|
Click OK to create any non-existent tablespaces in your schema, then click OK when the operation completes. |
|
Review the database details then click Create to continue. |
|
Click Close to exit the RCU program. |
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.
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
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.
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
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.
This section describes how to configure remote connections, and creating the necessary EDQ users, database, and schemas.
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.
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.