Create the Oracle Analytics database account for Oracle Empirica Topics

To prepare the Oracle Empirica Signal database server for Oracle Analytics, create the Oracle Analytics database account for Oracle Empirica Topics.

With this release, multiple Oracle Analytics accounts are supported. To streamline connections, a proxy account (OBI_PROXY) will be created.

1. On the Oracle 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 MASTER_OBI_ACCOUNT = '<proxy analytics account>';
   DEFINE TOPIC_WORKFLOW = '<topic workflow account>';
   DEFINE SIGNAL = '<Signal account>';
   DEFINE TABLESPACE = '<tablespace>'

   Note:

   The proxy analytics account, by default named OBI_PROXY, is used to establish proxy connections for all analytics accounts (for example, OBIEE_TOPIC_WORKFLOW).
4. In a command prompt window, execute the create_topics_user_obiee.sql script as the Oracle SYS user:

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

   Note:

   The database may reside on a different server than the Oracle Empirica Signal server.

   A password prompt appears.

5. Enter the password for the Oracle SYS account.
6. A second password prompt appears for the proxy analytics user. Enter the password.

   A list of topic workflow configuration names and IDs appears, and an ID prompt appears.

7. 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.

8. Enter a password for the OBIEE_<topic workflow account>_<topic workflow ID> database user account.

   Note:

   The password must not contain a dollar sign symbol ($).
9. Record the passwords for later use.

   After the script runs, the create_topics_user_obiee.log file is created and can be checked for errors.