Specify the Usage Tracking Database Using Model Administration Tool
Use Model Administration Tool to configure your usage tracking database if you currently use Model Administration Tool to develop semantic models.
You don't need to make any updates to your semantic model if you want
to track usage in an existing database or connection pool. You can skip these steps. You
can use the existing database, connection pool, and tables as part of the usage tracking
system configuration. Usage tracking won't delete the existing tables and create new
tables with the same name if the table schema matches between the old and new
tables.
- Specify the usage tracking database:
- In the Physical layer of the semantic model, right-click and select New Database.
- In the Database dialog, provide a name for the database of your semantic model; for example SQLDB_UsageTracking, specify the database type, for example Oracle 12c, and click OK.
- Right-click the newly created database, select New Object, and then select Connection Pool.
- In the Connection Pool dialog, enter connection pool details and specify values
for:
- Call interface: Select Default (Oracle Call Interface (OCI)).
- Require fully qualified table names: Ensure that this check box isn't selected.
- Data Source Name**: Specify
the data source to which you want this connection pool to
connect and send physical queries. For
example:
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = <DB Host>)(PORT = <DB port>))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = <Servicename>))) - User name and Password: Enter a user name that matches the name of a schema available in the usage tracking database.
**As an alternative to providing the Data Source Name, you can refer to an existing database connection “by name” in the Connection Pool dialog.
- Data connections - To use the connection details for a database defined through the Data tab as your usage tracking database, select Use Data Connection and enter the connection's Object ID instead of manually entering the connection details in the Data Source Name field. Ensure that the data connection you want to use was created with the System Connection option selected.
- Console connections - If you use Model Administration Tool, you might define database connections for semantic models using the Console. To use the connection details for a database that you defined through the Console as your usage tracking database, select the Use Console Connection check box and enter the name of the database connection in the Connection Name field.
For example:
Description of the illustration model_admin_tool_connection_pool.gif