Before You Begin
This 10-minute tutorial shows you how to set up tracking of user queries to the content in Oracle Analytics.
Track usage to determine which user queries are creating performance bottlenecks, based on query frequency and response time. Administrators set up the criteria to track user queries and generate usage reports that can be used in a variety of ways such as database optimization, aggregation strategies, or billing users and departments based on the resources that they consume.
This is the first tutorial in Track Usage in Oracle Analytics. Read the tutorials in the order listed.
- Set Up Usage Tracking in Oracle Analytics
- Analyze Usage Tracking Data in Oracle Analytics
What Do You Need?
- Install Oracle Analytics Developer Client Tool
- Access to Oracle Analytics
- Access to Oracle Database Cloud Service instance and these connection details:
- Host name
- Port number
- Database service name
- User name and password that match the name of a schema available in the database
Specify the Usage Tracking Database
Before you can track usage of reports, dashboards, and data visualization projects on your system, you must specify the database where you want to store the usage tracking statistics. The database must have a schema defined in it with permissions to create tables. The usage tracking process creates tables in the schema whose name matches the user name that you provide when specifying the connection pool details. For example, if the name of a schema in the usage tracking database is
Analytics_Usage, then when specifying the connection pool details, you must enter
Analytics_Usage in the User Name field. The usage tracking process creates the usage tracking-related tables in the schema named
In this section, you configure the database and connection pool details in the physical layer of your data model file.
- In Oracle Analytics Developer Client Tool, from the File menu, select Open, then In the Cloud.
- Enter the following connection information for your Oracle Analytics instance and click Open:
- User: The user name of an Oracle Analytics administrator
- Password: The password for the specified user.
- Host: The Oracle Analytics URL without the
https://at the start or the
/dv/uipart at the end of the URL. For example,
- Port: Port number of your Oracle Analytics instance.
- In the Physical layer of the data model file, right-click and select New Database.
- In Database, enter
UsageTrackingin Name, select Oracle 12c in Database type, and then click OK.
- In the Physical layer of the data model file, right-click UsageTracking, select New Object, and then select Connection Pool.
- In Connection Pool, enter
UTConnectionPoolin Name, specify values for the following, and then click OK:
- Call interface: Select Default (Oracle Call Interface (OCI)).
- Data Source Name: Enter your database host, port, and service name using the following format:
(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = <Your DB Host>)(PORT = <Your DB port>))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = <Your DB Service name>)))
- User name and Password: Enter the user name and password that matches the name of a schema available in the usage tracking database.
Set Usage Tracking Parameters
To record usage information, specify connection details for the usage tracking database and database table names that include the schema name that matches the user name of your connection pool. Use the database and connection pool names that you specified in the physical layer.
After you set the parameters and restart, Oracle Analytics creates the usage tracking tables in the specified schema with the table names that you provided and starts to log user queries in these tables.
- Sign in to Oracle Analytics with your administrator credentials.
- On the Home page, click Navigator, and then click Console.
- In Console, click System Settings.
- Enter these values for the following parameters:
- Usage Tracking Connection Pool:
- Usage Tracking Physical Query Logging Table:
UsageTracking.Analytics_Usage.PhysicalQueries. Replace "Analytics_Usager" with your usage tracking database schema name.
- Usage Tracking Logical Query Logging Table:
UsageTracking.Analytics_Usage.LogicalQueries. Replace "Analytics_Usage" with your usage tracking database schema name.
- Usage Tracking Max Rows:
10000as the maximum number of rows that you want in the usage tracking tables.