Refresh analytical data in pre-computed tables
Data Asset Analytics displays key metrics and key charts on the dashboard tabs based on pre-computed analytical data. If you notice a discrepancy in the data, you must refresh the analytical data in the pre-computed database tables.
Perform the following steps to run the Data Asset Analytics utility in synchronize mode to refresh the analytical data:
1. Back up the Data Asset Analytics database schema.
2. Disable the Catalog Service.
3. From the Akamai Download Manager, download and extract the informatica_1051_daa_utility.zip file on the domain machine.
Note: If you applied a service pack, you must download the utility corresponding to the service pack version.
4. Go to the directory where you extracted the files and navigate to the config directory.
5. Open the input.properties file and configure the following connection parameters for the Data Asset Analytics repository.
Property | Description |
|---|
databaseType | The Data Asset Analytics database type. Enter ORACLE, POSTGRESQL, or SQLSERVER. |
databaseHostName | The fully qualified host name of the machine where the database is hosted. Note: If the value contains a special character, you must enclose the value within single quotes ('). |
databasePort | The port number for the database engine service. |
databaseServiceName | The service name for the Oracle database. |
databaseName | The database name for the PostgreSQL or SQL Server database. |
databaseUserName | The name of the user account to connect to the database. |
databaseAdvanceParameter | Optional. Enter the advanced JDBC connection parameters used to connect to the Data Asset Analytics repository. Note: You must enclose the parameters within single quotes ('). |
6. On a shell command line, enter the following command to run the utility from the directory where you extracted the files: ./daautil.sh.
7. Press 2 to select the synchronize mode.
8. Enter the password to connect to the database.
Note: To know the execution status, see the daautil.log file from the directory from which you run the utility.