Create the Oracle Analytics database account for Oracle Empirica Signal Review

To use the data model for Signal Review, create an Oracle Analytics database account for Oracle Empirica Signal.

On the Oracle Empirica Signal application server, locate the create_sigmgt_user_obiee.sql file in the contents extracted from the Database.zip file.

1. Using a text editor, open the create_sigmgt_user_obiee.sql file.
2. Modify the following properties as needed for your environment:

   DEFINE SIGNAL = '<Signal account>';
   DEFINE TABLESPACE = '<tablespace>'; 
   DEFINE PROXY_USER = '<proxy analytics account>';
   

   Note:

   The proxy reporting account should be the same as what you specified in create_topics_user_obiee.sql for Oracle Empirica Topics in the previous section.
3. In a command prompt window, execute the create_sigmgt_user_obiee.sql script as the Oracle SYS user:

   $ sqlplus sys@<database_server_TNS name> as sysdba @create_sigmgt_user_obiee.sql
   

   A password prompt appears.
4. Enter the password for the Oracle SYS account.
   A second password prompt appears.
5. Enter a password for the OBIEE_SIGNAL_MGT database user account.

   Tip:

   The password must not contain a dollar sign symbol ($).
6. Record the password for later use.
   After the script runs, the create_sigmgt_user_obiee.log file is created and can be checked for errors.