B Frequently Asked Questions
Refer to these Frequently Asked Questions if you have questions about the behavior of Fusion Analytics Warehouse.
How do I synchronize data security from Oracle Fusion Cloud Applications (Cloud CX) with Fusion Analytics Warehouse?
To synchronize data security, you must create a pipeline for the "Security Configuration Option" functional area in the "Customer Experience Security Configurations" offering. This pipeline enables Fusion Analytics Warehouse to extract the access group-based security details from Oracle Fusion Cloud Applications (Cloud CX) and load it into Fusion Analytics Warehouse. Based on the access group-based security setup in Oracle Fusion Cloud Applications (Cloud CX), the synchronization process brings the access group-based rules and assigns to the appropriate users based on the data role assignment to the users in Fusion Analytics Warehouse.
| Oracle Fusion Cloud Applications Object | Corresponding Fusion Analytics Warehouse Table |
|---|---|
| Account Access | DW_CXS_SALES_ACCOUNT_ACCESS_D |
| Opportunity Access | DW_CXS_OPPORTUNITY_ACCESS_D |
| Lead Access | DW_CXS_LEAD_ACCESS_D |
| Access Group Members | DW_CXS_ACCESS_GROUP_MEMBERS_D |
| Object Share | DW_CXS_OBJECT_SHARE_D |
| Access Group | DW_CXS_ACCESS_GROUP_RF_DN_DH |
To ensure that synchronization happens frequently, you must schedule the incremental refreshes. See Set Up the Pipeline Parameters.
- Sign in to your service.
- In Fusion Analytics Warehouse, click the Navigator.
- In the Navigator menu, click Console.
- On the Console, click Data Configuration under Application Administration.
- On the Data Configuration page, click Customer Experience.
- On the service page, click Create, select
Customer Experience Security Configurations in
Offering, select Security
Configuration Option in Functional
Area, and then click Next.
- Review the parameters and click one of the options:
- Cancel: To cancel the data pipeline for the functional area.
- Save: To save the data pipeline for the functional area but not activate it.
- Activate: To schedule when to run the data pipeline for the functional area. See Activate a Data Pipeline for a Functional Area.