Oracle® Business Intelligence Enterprise Edition Deployment Guide > Integrating Oracle Internet Directory With Oracle Business Intelligence > Provisioning for Oracle BI Using Directory Integration Platform (DIP) >

Defining Provisioning Policies for Oracle BI


You use the Provisioning Subscription tool (oidprovtool) to create provisioning profile entries in the directory. Refer to chapter Oracle Directory Integration Platform Tools in Oracle Identity Management User Reference 10g (10.1.4.0.1) for syntax and usage of oidprovtool.

To define Provisioning Policies for Oracle BI

  1. Run the following command to define the provisioning policies for the dummy application:

    oidprovtool

    The following example shows the usage of oidprovtool. Alter the parameters according to your application's provisioning requirements.

    oidprovtool operation=create profile_mode=OUTBOUND profile_status=enabled ldap_host=$host ldap_port=$port ldap_user_dn='cn=orcladmin' ldap_user_password=$passwd application_dn='orclApplicationCommonName=DummyappOnline,cn=DUMMYAPP,cn=Products,cn=OracleContext' organization_dn='dc=us,dc=oracle,dc=com' interface_name=<pl/sql package name eg.LDAP_NTFY
    interface_version=3.0 interface_type=PLSQL interface_connect_info=$db_host:1521:$connect:$db_userid:$db_userpassword user_data_location='cn=User Properties,orclApplicationCommonName=DummyappOnline,cn=DUMMYAPP,cn=Products,cn=OracleContext' default_provisioning_policy=PROVISIONING_REQUIRED application_type=DummyApp
    application_display_name='DummyApp Online' event_subscription='USER:dc=us,dc=oracle,dc=com:ADD(*)'
    event_subscription='USER:dc=us,dc=oracle,dc=com:MODIFY(*)'
    event_subscription='USER:dc=us,dc=oracle,dc=com:DELETE'
    event_subscription='GROUP:dc=us,dc=oracle,dc=com:DELETE'
    event_subscription='GROUP:dc=us,dc=oracle,dc=com:ADD(*)' schedule=30 max_retries=5

    Where:

    • $db_host = host name of the Oracle database server where the provisioning is to be done
    • $connect = Oracle SID (directory database connect string, or the net service name in tnsnames.ora)
    • $db_userid = db user
    • $db_userpassword = password for db user
    • ADD(*) = attributes you want provisioned through DIP when a new entity is added in OID. Use asterisk (*) to provision all attributes, or provide a list of required attributes.

If provisioning for an application or database is to occur when a user is added in OID, then the procedure PutOIDEvents gets invoked. Add custom code in this procedure per your application provisioning requirements.

Oracle® Business Intelligence Enterprise Edition Deployment Guide Copyright © 2006, Oracle. All rights reserved.