Creating an OAS Connection

Use the Soft Coding Records (P954000) application to create a connection to the Oracle Analytics Server. You can type P954000 in the Fast Path or use this path to navigate to the Soft Coding applications:

Navigator > EnterpriseOne Menus > EnterpriseOne Life Cycle Tools > System Administration Tools > Soft Coding Administration

To create an OAS connection:

1. Access the P954000 application.

2. Click Add.

3. In the User/Role field, enter the EnterpriseOne user, role, or *PUBLIC.

4. In the Environment Name field, enter the EnterpriseOne environment for which you are creating this OAS connection.

5. In the Template Name field, enter BI CONNECTION.

6. In the Soft Coding Key field, enter BI_CONNECTION.

7. Click the Populate Soft Coding Value button to populate the Soft Coding Description and Soft Coding Value fields with the information from the BI CONNECTION template.

8. Change the user name and root catalog in the Soft Coding Value for your connection.

9. Enter the Mask Value for any Mask Fields. For example, enter a value for BI_PASSWORD. You do not need to use the prefix and postfix values (_ | | _) when entering the mask field in the grid. The system adds these automatically.

10. Click OK to save the record.