Create the Oracle Analytics views for Oracle Empirica Topics

To prepare the Oracle Empirica Signal database server for Oracle Analytics, you must create the Oracle Analytics views for Oracle Empirica Topics.

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

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

4. In a command prompt window, execute the populate_obiee_topics.sql script as the database user you created in Create the Oracle Analytics database account for Oracle Signal Topics, for example:

   $ sqlplus OBIEE_<topic workflow account>_<topic workflow ID>@<TNS name for database connection> @populate_obiee_topics.sql

   A password prompt appears.