Liquent InSight for Analytics 6.2 CHF 3 Installation Guide

Configure New Adapter for Oracle 12C

  1. Go to the Applications tab and click Application Settings in the ribbon.
    1. In the foccache_dir * field, enter install location\WebFOCUS_Express80\srv\wfs\edatemp.
    2. In the foccache_maxage * field, enter 60.
      This specifies the location and duration of session data.
    3. Save and Restart the server
  2. Navigate to the Applications tab, right-click on the Application Directories node and choose New > Application Directory. Select or enter the following values:
    Field Name Input Value
    Application Type New Application under APPROOT
    Application Name liquent_synonyms
    Description Liquent synonym storage location
    1. Select the Add directory to APPPATH option.
    2. In the Position in APPPATH pulldown, select First
    3. Click OK
  3. Right-click on the Application Directories node and choose New > Application Directoryagain. Select or enter the following values:
    Field Name Input Value
    Application Type New Application under APPROOT
    Application Name liquent_temp_files
    Description Temp file location
    1. Select the Add directory to APPPATH option.
    2. In the Position in APPPATH pulldown, select Last
    3. Click OK
  4. Right-click on Application Directories, select Application path and verify that liquent_synonyms and liquent_temp_files folders have the In Path option selected.
    If not, select it and Save.
  5. Navigate to the Adapters tab.
  6. Expand Available > SQL > Oracle, right-click on 12C and select Configure. Select or enter the following values:
    Field Name Input Value
    Connection Name insight6
    Important: Ensure all lowercase.
    TNS name database SID
    Security Explicit
    User <database user name (DM)>
    Password <database password (DM users password)>
    Select profile edasprof
    1. Click Test. Verify that an Oracle Adapter Test Successful page is displayed. Close the page
    2. Once the test is successful, go back to the Add Oracle 12C configuration tab and select Configure
    3. Verify the custom provider is able to retrieve users and groups by selecting the Access Control tab
  7. Right-click Adapters > Configured > Oracle 12c folder and select Change Settings.
    1. Under Read/Write Optimization, change FETCHSIZE to 1000
    2. Click Save
  8. Select the Access Control tab. In the ribbon, choose the Register group. Choose CUSTOM - ism as Security provider and click Next.
    If you are able to see the list of groups below, the security configuration is good.
  9. Select the Workspace menu and then Configuration Files (tree to the left).
    1. Right-click on Server Profile – edasprof.prf and choose Edit
    2. Add the following lines to the end of the file after replacing insight server name and port number with the Calyx RIM server name or the IP address and port number for which Calyx RIM for Analtics is being configured: 
      
                        EX liquent_temp_files/user_name.fex
                        
                        -SET &&INSIGHT_SRVR_NM='http://insight server name:port number'; 
                        
                        -SET &&INSIGHT_API='/insight/api/view?';
    3. Click Save
  10. Select the NLS button from the Workspace tab and change the following:
    Field Name Input Value
    CODE_PAGE = 65001 – Unicode (UTF-8)
    LANG = AMENGLISH
    Note: This value may be displayed as already selected.
  11. Select Recreate FOCUS system files
  12. Click Save / Rebuild NLS Files and Restart Server.