web oracle bi集成,BI Publisher 和Oracle BI Server 怎么样实现安全集成？

以下是我在网上找到的答案，全是英文 看得不太懂，很苦恼，BI Publisher 和Oracle BI Server 的安全集成BI Publisher offers integration with Oracle BI Server security so that you can administer the BI Publisher users through the BI Server Administration tool. To ...显示全部

以下是我在网上找到的答案，全是英文 看得不太懂，很苦恼，

BI Publisher 和Oracle BI Server 的安全集成

BI Publisher offers integration with Oracle BI Server security so that you can administer the BI Publisher users through the BI Server Administration tool. To accomplish this you must define the BI Publisher functional roles within the Oracle BI Server Administration tool, assign users to these groups, and then specify Oracle BI Security as your security model in the BI Publisher Admin interface.

Note: For information on setting up Oracle BI security, see the Oracle Business Server Aministration Guide.

1.        In the BI Server Administration tool, create the following groups to correspond to the BI Publisher functional roles:

o        XMLP_ADMIN – this is the administrator role for the BI Publisher server.

o        XMLP_DEVELOPER – allows users to build reports in the system.

o        XMLP_SCHEDULER – allows users to schedule reports.

o        XMLP_ANALYZER_EXCEL – allows users to use the Excel analysis feature.

o        XMLP_ANALYZER_ONLINE – allows users to use the online analysis feature.

o        XMLP_TEMPLATE_DESIGNER - allows users to connect to the BI Publisher server from the Template Builder and to upload and download templates.

2.        Add the appropriate users to the BI Publisher groups in the BI Server Administration tool.

Note: Ensure to assign at least one user to the XMLP_ADMIN group.

3.        In the BI Publisher Enterprise application, log in with Administration privileges. From the Admin tab select Security Configuration.

4.        In the Security Model section of the page, select Oracle BI Server from the list. Provide the following connection information for the BI Server:

o        JDBC Connection String - example: jdbc:oraclebi://host:port/

Note that if your Oracle BI Server is SSL-enabled, you must copy the keystore to the BI Publisher server and provide it in the connection string.

If your Oracle BI servers are set up in a clustered configuration, the connection string must use the appropriate syntax. See Adding the Oracle BI Server as a JDBC Data Source for a description of the required syntax.

An example connection string for a clustered, SSL-enabled instance follows: jdbc:oraclebi://mycompanyserver.com:9706/PrimaryCCS=BIdb01;PrimaryCCSPort=9706;ssl=true;sslKeystorefilename=c:\mycompany\SSL\OracleBI\sslc\javahost.keystore;sslKeystorepassword=admin;trustanyserver=true;

For more information on SSL and on clustered configurations, see the Oracle Business Intelligence Enterprise Edition Deployment Guide.

o        Administrator Username and Administrator Password

o        Database Driver Class - example: oracle.bi.jdbc.AnaJdbcDriver

5.        It is recommended that you create a local super user for the system to allow you to access the Administrator pages once the changes take effect. Select the Enable Local Superuser check box and enter a username and password for the user under the Local Superuser section of the Security Configuration tab.

6.        Restart the BI Publisher server for the security changes to take effect.

Add Folders to the Oracle BI Server Roles

1.        Log in to BI Publisher as a user with the XMLP_ADMIN role.

2.        From the Admin tab select Roles and Permissions.

3.        All of the groups from your Oracle BI instance will display as available roles.

4.        Find the group (role) that you wish to attach folders to and select Add Folders.

如果使用外部表认证，需要创建2个ini-block, 一个存放group，一个存放usename，而且一定要输入密码

上面这个错误是因为BIP没有收到password收起