Appendix C – Data Gateway and Registering Agents

This appendix discusses on working with the Oracle Data Gateway and registering agents. The data gateway is required to establish a connection from the cloud to the local database.

To work with the data gateway and register agents

1. Deploy the data gateway by extracting the associated .zip file to a folder Generator in the system where the Anglesis installed.
2. Log on to the Oracle Cloud application.

   The Home page of the Oracle Cloud application appears.

   

3. Select Console from the side menu located at the top left corner of the page, and select Remote Data gateway from the list that appears.
4. Go to the folder in your system where the data gateway is extracted, and run the datagateway.exe file. The data gateway configuration window appears.
   
5. Enter the appropriate OAC URL address in the URL field.
   
6. Select Generate Key. The “Key successfully generated” message appears, and the key is displayed in the box under the URL field.
   
7. Select Copy to Clipboard to copy the generated key, then select the Enable toggle option, and select Save.
   
8. Go to the Remote data gateway settings in the Oracle Analytics Home page, and select Add to add the generated key.
   
9. Paste the key generated in step 7 in the Public Key text box, and select OK.
   

   The relevant Name, ID, and Host details are populated in the respective text boxes.

10. Enable the data gateway with the Enable Data Gateway toggle option.
    
11. Go to the folder in your system where the data gateway is extracted, and open the obiee_rdc_agent.properties file. Ensure that the localhost and port number are set. Ensure to make a note of the port number.
12. Open the Model Administration Tool from the Start menu.
    
13. On the File menu, select Load Java Datasources.
    

    The Connect to Java Datasource Server window appears.

    

14. Enter the following details in the Hostname and Port fields.
    • Hostname: localhost
    • Port Number: 55750 (enter the port number copied from the obiee_rdc_agent.properties file)
15. Enter appropriate details in the User and Password fields.
16. Select OK.

    The "Successfully loaded javads metadata from localhost:55750" message appears.

    

17. On the File menu, select Open > Offline.
    
18. Select the NoetixRepository.rpd file from the appropriate folder, and select Open.
    
19. Enter the password for the .rpd file available in the Repository Information section of the Target Parameters tab of the Angles for Oracle Generator. Select OK.
    

    The .rpd file is opened successfully, and the repository displays the generated objects in three panes: Physical, Business Model and Mapping, and Presentation.