Creating the OBIEE Topics database account
- On the Empirica Signal application server, unzip the
Database.zip
file. - Using a text editor, open the
create_topics_user_obiee.sql
file. - Modify the following properties as needed for your environment:
DEFINE TOPIC_WORKFLOW = '
<topic workflow account>';
DEFINE SIGNAL = '
<Signal account>';
DEFINE TABLESPACE = '
<tablespace>';
- 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 Signal server.
A password prompt appears.
- Type the password for the Oracle system account.
A list of topic workflow configuration names and IDs appears, and an ID prompt appears.
- Type 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.
- Type a password for the OBIEE_<topic workflow account>_<topic workflow ID> database user account.
- Record the password.
After the script runs, the
create_topics_user_obiee.log
file is created.