5. Creating BI Publisher Datasource
To create BI Publisher Datasource, do the following:
- Create Data Source with JNDI as ‘jdbc/ofsllbipdb’ on
BI Publisher Domain
- Target the datasources to ‘bi_server1’
- Access the weblogic console URL using http://hostname:port/console.
![](BIP_Datasource_1.jpg)
- Launch http://hostname:port/xmlpserver.
The following window is displayed.
![](BIP_Datasource_2.jpg)
- Login using
the same credentials used for ‘WebLogic administration’ console
login. The following window is displayed.
![](BIP_Datasource_3.jpg)
- Click ‘Administration’
in the header section. The following window is displayed.
![](BIP_Datasource_4.jpg)
- Click ‘JNDI
Connection’. The following window is displayed.
![](JNDI_Connection.jpg)
- Add Data Source
‘FLLReportsPool’ with JNDI as ‘jdbc/ofsllbipdb’.
- Under ‘Security’ section, select ‘BI
Author Role’ and ‘BI Consumer Role’ from Available
Roles and assign them as Allowed Roles.
Note
If “BI Author” and “BI Consumer”
roles are not displayed in the ‘Available Roles’ section,
you need to create the roles as explained in following ‘Creating
Roles’ section.
5.1 Creating Roles
The following section details the steps to be followed to create “BI
Author” and “BI Consumer” roles which are used to define
security roles while creating Data Source on BI Publisher Domain.
To create WebLogic Application Role
- Login to Enterprise Manager using the URL - http://hostname:port/em.
- Select Weblogic Domain > Security > Application Roles
as indicated in the following screen.
![](Weblogic_Roles1.jpg)
- In the Application
Stripe field, select ‘obi’ from the drop-down list. The option
‘BIServiceAdministrator’ is added by default. Click ‘Create’.
![](Weblogic_Roles3.jpg)
- Specify the
following details:
- Role Name
- Display Name
- Description
![](Weblogic_Roles4.jpg)
- Click ‘Add’ to add the application role to
the members family. The same can later be mapped to required Users or
Groups defined in Enterprise LDAP server, or the role can be mapped to
other application roles.
![](Weblogic_Roles5.jpg)
- Add the Weblogic
User by selecting “weblogic” in the ‘Searched Principals’
section and click ‘OK’. The Weblogic User is added to the
application role.
![](Weblogic_Roles6.jpg)
- Click ‘OK’.
The new role is added to the list of application roles.
![](Weblogic_Roles7.jpg)
To Create WebLogic Application Policies
- Login to Enterprise Manager using the URL - http://hostname:port/em.
- Select Weblogic Domain > Security > Application Policies
as indicated in the following screen:
![](Weblogic_Roles8.jpg)
- In the Application
Stripe field, select ‘obi’ from the drop-down list. Click
‘Create’.
![](Weblogic_Roles9.jpg)
- In ‘Create
Application Grant’ screen, under the Grantee section, click ‘Add’.
![](Weblogic_Roles10.jpg)
- Select the
newly created application role from the list and click ‘OK’.
The new role is added to the list.
![](Weblogic_Roles11.jpg)
- In the ‘Permissions’
section, click ‘Add’.
![](Weblogic_Roles12.jpg)
- In the search
criteria, select ‘Resource Type’ and select the resource
type from the drop-down list. Select the required resource from the search
results and click ‘Continue’.
![](Weblogic_Roles13.jpg)
- Define the
required permission(s) for the application role by selecting the appropriate
Permission Class and Permissions Actions check box. Click ‘Select’.
![](Weblogic_Roles14.jpg)
- The selected
permissions are defined to the application role. Similarly you can define
the required permissions for other application roles.
![](Weblogic_Roles15.jpg)
- Once done,
click ‘OK’.
![](Weblogic_Roles16.jpg)