Create the Oracle Analytics objects for Oracle Empirica Signal Review

To prepare the Oracle Empirica Signal database server for Oracle Analytics, you must create the Oracle Analytics objects for Oracle Empirica Signal Review.

1. On the Oracle Empirica Signal application server, locate the obi_create_sigmgt_objects.sql file in the contents extracted from the Database.zip file.
2. Open the obi_create_sigmgt_objects.sql file in a text editor.
3. Modify the following properties as needed for your environment:

   DEFINE SIGNAL = '<Signal account>';

4. In a command prompt window, execute the obi_create_sigmgt_objects.sql script as the database user you created in Create the Oracle Analytics database account for Oracle Empirica Signal Review (OBIEE_SIGNAL_MGT), for example:

   $ sqlplus OBIEE_SIGNAL_MGT@<TNS name for database connection> @obi_create_sigmgt_objects.sql

   A password prompt appears.
5. Enter the password for the OBIEE_SIGNAL_MGT database account.
   After the script runs, the obi_create_sigmgt_objects.log file is created and can be checked for errors.