Adding a BI Connection

Use the Web Service Soft Coding Template (P953000) application to create a connection to the Business Intelligence server. You can type P953000 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 add a BI Connection template:

1. Access the P953000 application

2. Click Add.

3. Enter BI CONNECTION in the Template Name field.

4. Enter BI Connection in the Description field.

5. Enter BI_CONNECTION in the SoftCoding Key field.

   Important: The value for SoftCoding Key must be BI_CONNECTION. You cannot use any other value for this field.

6. Enter the following in the Value field:

   <webservice>
   <endpoint>
   http://server:port/analytics/saw.dll?SoapImpl=</endpoint>
   <username>username</username>
   <password>_||_BI_PASSWORD_||_</password>
   <properties>
   <property><name>root catalog</name><value>root catalog
   folder</value></property>
   </properties>
   </webservice>

7. Enter the Mask Fields in the grid (for example, BI_PASSWORD).

   Mask fields are the fields that have _ | | _ as a prefix and postfix. However, you do not include the prefix and postfix when entering the mask field in the grid. The system adds the prefix and postfix for you.

8. Click OK to save the template.