Prerequisites for Usage Tracking

If you want to track usage, verify you meet the following prerequisites:

  • You currently use Semantic Modeler or Model Administration Tool to manage your semantic model.

    To configure usage tracking, you must add the usage tracking database details to your semantic model using either Semantic Modeler or Model Administration Tool.

  • You have appropriate access permissions on the database where you want to store usage information.

    You must have the credentials for a user who has permissions to create the usage tracking tables on the database schema and write usage data to the tables.

  • The database supports usage tracking: Oracle Database or Oracle Autonomous Data Warehouse
  • You have created a data connection to your usage tracking database with the following settings. See Connect to Data.
    • System Connection - Select the System Connection check box.

      When you select the System Connection check box, the connection becomes available in Semantic Modeler. Similarly in Model Administration Tool, the System Connection option enables you to select Use Data Connection and enter the connection's Object ID instead of manually entering the connection details in the Data Source Name field. See Specify the Usage Tracking Database.

    • User Name and Password - The User Name must match the name of the schema in the database that you want to use for usage tracking. For example, if the schema you want to use is called UT_Schema the User Name must be UT_Schema.

    Note:

    If you use Model Administration Tool, you can also define database connections for semantic models and the usage tracking database using the Console. See Connect to Data in an Oracle Cloud Database. If you use the Console, you can select Use Console Connection and enter the connection's Name while specifying the usage tracking database in Model Administration Tool, instead of entering the connection details in the Data Source Name field.

If you want to use Oracle Autonomous Data Warehouse as the usage tracking database, complete these additional tasks before you specify the usage tracking database in your semantic model: