About Validating Your Data
As an administrator, you can validate a library of metrics between your Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Fusion Analytics Warehouse.
Prerequisites for Data Validation
Here's a list of prerequisites for validating your data as an administrator:
- Ensure that you can access the Oracle Transactional Business Intelligence instance and run queries.
- Ensure that you have the same data security privileges in Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
- Ensure that you’re assigned the Integration Specialist Group in Oracle Fusion Analytics Warehouse to access the Common folder in Oracle Analytics Cloud and to view the output of the data validation project.
- Create a user, such as
MyFAWValidationUser, to validate the extracted data. See Create a User to Validate the Extracted Data. - Create a custom BI Abstract role and associate it with an applicable user, such as
MyFAWValidationUser, whose credentials you want to provide for data validation. - In Oracle Fusion
Analytics Warehouse, on the Source Credentials tab of the Data Validation page, provide the
credentials of the applicable user, such as
MyFAWValidationUser.Note:
If the password has expired, then set the new password using the Source Credentials tab. To navigate to the Source Credentials tab, open the Navigator menu, click Console, and then click Data Validation under Application Administration. You see the Scheduled Validation, Detailed Validation, and Source Credentials tabs.
