To prepare the Oracle Empirica Signal database server for Oracle Business Intelligence, create the Oracle Business Intelligence database account for Oracle Empirica Topics.

1. On the Oracle Empirica Signal application server, unzip the Database.zip file.
2. Using a text editor, open the create_topics_user_obiee.sql file.
3. Modify the following properties as needed for your environment:

   
   DEFINE TOPIC_WORKFLOW = '<topic workflow account>';
   DEFINE SIGNAL = '<Signal account>';
   DEFINE TABLESPACE = '<tablespace>'

4. In a command prompt window, execute the create_topics_user_obiee.sql script as the Oracle system user:

   $ sqlplus system@>database_server_TNS name>
   @create_topics_user_obiee.sql

   Note:

   The database may reside on a different server than the Oracle Empirica Signal server.

   A password prompt appears.

5. Enter the password for the Oracle system account.

   A list of topic workflow configuration names and IDs appears, and an ID prompt appears.

6. Enter the target topic workflow configuration ID.

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

   A second password prompt appears.

7. Enter a password for the OBIEE_<topic workflow account>_<topic workflow ID> database user account.
8. Record the password for later use.

   After the script runs, the create_topics_user_obiee.log file is created and can be checked for errors.