Create the OBIEE Topics database account

Previous Topic

Next Topic

Book Contents

Create the OBIEE Topics database account

  1. On the 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 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.

Send Feedback