Skip Headers

Oracle® Health Sciences Empirica Topics Reporting and Oracle Business Intelligence Configuration Guide Release 8.0 E50113-01 |
| Contents

Previous | Next |

# 2 Prepare the Empirica Signal data account

In this step, you create an OBIEE database account for the Empirica Signal and Topics application, and then populate the database account with views that point to data items in your chosen topic workflow configuration for reporting.

This chapter includes the following sections:

- Creating the OBIEE Topics database account

- Creating the OBIEE Topics views

## Creating the OBIEE Topics database account

1. Extract the contents of the `Database.zip` file on your Empirica Signal application server.

2. Open the `create_topics_user_obiee.sql` file in a text editor.

3. Verify that the following properties are set to the appropriate values for your environment, and edit the values if necessary:

   `DEFINE TOPIC_WORKFLOW = '<`topic workflow account`>';`

   `DEFINE SIGNAL = '<`Signal account`>';`

   `DEFINE TABLESPACE = '<`tablespace`>';`

4. Open a Command Prompt window (for example, PuTTY) and execute the `create_topics_user_obiee.sql` script as the Oracle system user:

   Note: The database may reside on a different server than the Signal server.

   `$sqlplus system@<`TNS name for database connection`> @create_topics_user_obiee.sql`

5. When prompted, type the Oracle system account password.

   A list of topic workflow configuration names and IDs appears.

6. When prompted, type the target topic workflow configuration ID.

   The script creates the `OBIEE_<`topic workflow account`>_<`topic workflow ID`>` database account.

7. When prompted, choose and type a password for the `OBIEE_<`topic workflow account`>_<`topic workflow ID`>` database account.

   Record this password for use in the next section and later.

   The script completes, and creates the `create_topics_user_obiee.log` file.

## Creating the OBIEE Topics views

1. On the Empirica Signal application server, locate the `populate_obiee_topics.sql` file in the contents extracted from the `Database.zip` file.

2. Open the `populate_obiee_topics.sql` file in a text editor.

3. Verify that the following properties are set to the appropriate values for your environment, editing the values as necessary:

   `DEFINE TOPIC_WORKFLOW = '<`topic workflow account`>';`

   `DEFINE SIGNAL = '<`Signal account`>';`

4. Open a command prompt window and execute the `populate_obiee_topics.sql` script as the database user created in Creating the OBIEE Topics database account:

   `$sqlplus OBIEE_<`topic workflow account`>_<`topic workflow ID`>@<`TNS name for database connection> `@populate_obiee_topics.sql`

5. When prompted, type the password for the `OBIEE_<`topic workflow account`>_<`topic workflow ID`>` database account that you created in Creating the OBIEE Topics database account.

6. When prompted, type the same topic workflow configuration ID that you entered in step 6 in Creating the OBIEE Topics database account.

   The script completes, and creates the `populate_obiee_topics.log` file.