Table of Contents

• Title and Copyright Information
• Document Control
• 1 Preface
  • What is New in this Release of OFSAAAI Application Pack
  • Summary
  • Audience
  • Related Documents
  • Conventions
  • Abbreviations
• 2 Data Management Tools (DMT) Module Configurations
  • Data Mapping Configurations
    • Data Movement from RDBMS Source to HDFS Target (T2H)
      • Default Implementation
      • Sqoop Implementation
    • Data Movement from HDFS Source to RDBMS Target (H2T)
      • Default Implementation
      • OLH (Oracle Loader for Hadoop) Implementation
      • Sqoop Implementation
    • Data Movement from File to HDFS Target (F2H)
    • Data Movement of WebLog Source to HDFS Target (L2H)
      • Prerequisites
      • Configurations
      • Logger Types Seeded Table
  • Oracle® Loader for Hadoop (OLH) Configuration
    • Prerequisite
    • Steps for Configuring OLH
    • Limitations
  • Sqoop Configuration
    • Prerequisites
    • Steps for Configuring Sqoop
      • Sqoop 1 Cluster Mode
      • Sqoop 1 Client Mode
        • Limitations of Sqoop 1
  • SCD Execution on Hive Information Domain
    • Constraints
    • Assumptions
  • Heterogeneous Support for SCD to RDBMS
    • Assumptions
  • Configuring DMT Optimization Parameter
• 3 Dimension Management Module Configurations
  • Configurations to use Alphanumeric and Numeric Codes for Dimension Members
    • Configure Alphanumeric Dimensions
    • Configure Numeric Dimensions
    • Configure Alphanumeric Code in Simple Dimension Tables
    • Create Index on Code Column
  • General Configurations for Dimension Management Module
• 4 Rule Run Framework Configurations
  • Performance Optimization Setting for RRF Module
    • Behavior of Execution Modes
    • Use ROWID
    • Use PARTITION
    • Hints/ Scripts
  • Component Registration in RRF
    • Component Detailed Implementation Class
      • getComponentDescription
      • getPorbableParamValues
      • getSummary
      • getCompDescMap
      • fillTaskParameter
      • getUsedTables
    • Deployment
    • Entry to PR2_COMPONENT_MASTER Table
    • Sample Code
• 5 Operations
  • Delink ICC Server from FICServer
    • Configure ICC Server on a Separate OFSAA Node
      • Prerequisites
    • Steps to Deploy ICC Server in Separate OFSAA Node
  • Distributed Activation Manager (AM) Based Processing
    • Setting Up of Secondary AM Server
      • Prerequisites
    • Configuring OFSAA Instance through Load Balancer to Distribute Batch Tasks on Multiple AM Nodes
    • Executing Batches on Multiple AM Nodes
• 6 Unified Analytical Metadata Configurations
  • Hierarchy Node Internationalization
    • Scope
    • Prerequisites
    • Multi Language Support (MLS) Table
      • MLS Table Structure
      • MLS Table Configuration
    • Node Generation Process
      • Node Generation when MLS Table is Present and Configured
      • Node Generation when MLS Table is Not Present or Not Configured
    • Configure Mapper for Multiple Locales
    • Update Nodes in Existing Regular BI and PC Hierarchies
    • Limitations
  • Data Element Filters Classification
    • Limitations
  • Configuring Essbase Connectivity Check
    • Settings in .profile File
    • Checking the Connection
• 7 Enterprise Modeling Framework Configurations
  • Configuration of Oracle R Distribution and Oracle R Enterprise (ORE)
  • Configurations for OFSAAI Remote Invocation of Scripted Models Using Standard R Distributions
    • Prerequisite
      • Installing OFSAAIRunnerOpenR R Package
    • Configurations
    • Structure of the gss-jass.conf File
  • Configurations for Open-R with HDFS
    • Prerequisites
    • Installing OFSAAIRunnerHDFS Package
    • Additional Configurations for ORAAH Executions
  • Support for Scripts which work on HDFS Files Directly
  • User Configurable Execution Implementation
  • Configuration for Parallel Execution of Models
  • Configurations for ORE Execution
  • Variable Migration Utility
  • Model Execution Venue Migration Utility
  • Data Redaction Grants to Sandbox Schema
• 8 Process Modeling Framework Configurations
  • SMTP Server Configurations
  • Work Manager Configurations
    • Creating Work Manager in WebSphere Application Server
    • Mapping Work Manager to OFSAA WebSphere Instance
    • Creating Work Manager in WebLogic Application Server
• 9 Document Management Configurations
  • Configure Document Upload Settings
    • Configure Document Upload Location Properties
    • Configure Document Upload File Formats and Size
    • Configure Document Upload File Timeout and File Transfer
  • Content Management Integration
    • Configurations for Document Upload to Multiple Libraries
• 10 Questionnaire Setup and Configuration Details
  • Launching Questionnaire Menu
  • Mapping Roles to Access Questionnaire
  • Configuring Components, Dimensions, and Static Options
    • Configuring Components for Questionnaire
    • Configuring Dimensions for Questionnaire
    • Configuring Static Options for Questionnaire
  • Registering and Invoking your Application's Customized Workflow
• 11 Data Security and Data Privacy
  • Multi-Factor Authentication
    • Prerequisites
    • Configuring OTP through Email using OAM Adaptive Authentication Service
      • Enabling Adaptive Authentication Service
      • Configuring Adaptive Authentication Plugin
    • Configuring AdaptiveAuthenticationModule
      • Configuring Credentials for UMS
      • Protecting the Resource with AdaptiveAuthenticationScheme
      • Enabling Two-Factor Authentication to a Protected Resource
      • Accessing the UI
  • Transparent Data Encryption (TDE)
  • Data Redaction
    • Prerequisites
    • Input for Data Redaction
    • Data Redaction Utility
      • Executing Data Redaction Utility with False Flag
      • Executing Data Redaction Utility with TRUE flag
    • Creating Batch for Executing Data Redaction Utility
    • Logs
    • Disabling Data Redaction
    • Reverting the Data Redaction for an individual Policy
    • Reverting the Data Redaction for an individual Column
  • Data File Encryption
  • Key Management
    • Executing EncryptC Utility
      • Knowing the Prerequisites
      • Generating Keystore
      • Retrieving AESCryptKey.ext
      • Generating new AESCryptKey.ext and updating the Keystore
  • HTTPS Protocol
  • Logging
    • Purging of Logs
    • Log File Format
• 12 Generic Configurations
  • OFSAA Global Performance Optimization
  • Query Performance Optimization
  • Adding FIC_MIS_DATE Option During Batch Creation IN AAI Run Framework
  • Multiple Language Support (MLS) Utility
    • Available Parameters
    • AAIPI.sh Utility
  • Transferring Batch Ownership
  • Database Password Reset/ Change
  • Changing IP/ Hostname, Ports, Deployed paths of the OFSAA Instance
    • Running Port Changer Utility
  • Using X-Frame-Options to Embed OFSAA Content on your Site
    • Knowing the Prerequisites
    • Enabling or Disabling X-Frame-Options in the web.xml File
  • Setting Access-Control-Allow-Origin Header
    • Knowing Additional Cross-Origin Resource Sharing (CORS) Configuration
  • Configuration for Tomcat
  • Configuring WebLogic
    • Configuring WebLogic for REST Services Authorization
  • Configuring WebSphere
    • Configuring WebSphere for REST Services Authorization
  • SSO Authentication (SAML) Configuration
    • SAML Service Provider Metadata Configuration with Certificate
    • SAML Service Provider Metadata Configuration without Certificate
  • System For Cross-Domain Identity Management (SCIM)
    • Prerequisites
    • Create Generic SCIM application in Oracle IAM
    • Assign Groups from Oracle IAM to the existing groups in OFSAA
    • User - User Group Mapping in Oracle IAM
    • Synch Users from OFSAA to Oracle IAM
    • Create Users
    • Modify Users
    • Enable/Disable Users
    • Delete Users
  • Public Key Authentication
    • Prerequisite
    • Setting Up Public Key Authentication on Client Server
    • Other SSH Software
    • Configurations Required in OFSAA Setup
  • Enable and Disable Users
    • Prerequisites
    • Enabling or Disabling Users with System Administrator and System Authorizer Roles
  • Password Reset
    • Prerequisites
    • Resetting a User Password
  • Configuring OFSAA OIM Connector
    • Knowing the Prerequisites
    • Configuring the Connector
    • Configuring Entitlements
      • Performing User Group and User-User Group Mapping Reconciliation
      • Provisioning Entitlement Requests
      • Removing Provisioned (Deprovisioning) Entitlements
      • Approving Request Entitlements
  • Using REST APIs for User Management from Third-Party IDMs
    • Knowing the Prerequisites
    • Understanding REST API Specifications
  • Configuring the Logout URL for OBIEE in OFSAA
  • Enabling Deep Linking in OFSAA
  • Enabling Unlimited Cryptographic Policy for Java
• 13 Configurations for Connecting OFSAA to Oracle Database using Secure Database Connection (TCPS)
  • Prerequisites
  • Configure OFSAA to Store Config Schema, Atomic Schema, and SysDBA Credentials with Oracle Wallet
  • Configuring OFSAA and various Web Application Servers with Oracle Wallet
    • Configuring OFSAA and Tomcat as Web Application Server with Oracle Wallet
    • Configuring OFSAA and WebLogic as Web Application Server with Oracle Wallet
    • Configuring OFSAA and WebSphere as Web Application Server with Oracle Wallet
  • Generating EAR/WAR Files
  • Configuring Password Changes
• A Appendix A – Distributed Activation Manager Deployment
• B Appendix B – Additional Information in REST APIs for User Status and User Access Reports