Okay this is something that isn’t immediately expressed in most integrations and not highlighted in the Oracle BI documentation but it happens every now and then – A client’s LDAP server is SSL protected and we need to leverage LDAP in our Oracle BI implementation.  The long and the short of this method are found here, http://download.oracle.com/docs/cd/E21764_01/web.1111/e13707/atn.htm#BABDBHAA.

Here’s how to set up the configuration:

1. Configure the LDAP Authentication provider. Make sure you select SSLEnabled on the Configuration > Provider Specific page.
2. Obtain the root certificate authority (CA) certificate for the LDAP server.
3. Create a trust keystore using the preceding certificate. For example, the following example shows using the keytool command to create the keystore ldapTrustKS with the root CA certificate rootca.pem.:

   keytool -import -keystore ./ldapTrustKS -trustcacerts -alias oidtrust -file rootca.pem -storepass TrustKeystorePwd -noprompt

   For more information about creating a trust keystore, see Chapter 11, “Configuring Identity and Trust.”

4. Copy the keystore to a location from which WebLogic Server has access.
5. Start the WebLogic Server Administration Console and navigate to the server-name > Configuration > Keystores page, where server-name is the WebLogic Server instance for which you are configuring this keystore.
6. If necessary, in the Keystores field, click Change to select the Custom Identity and Custom Trust configuration rules.
7. If the communication with the LDAP server uses 2-way SSL, configure the custom identity keystore, keystore type, and passphrase.
8. In Custom Trust Keystore, enter the path and file name of the trust keystore created in step 2.
9. In Custom Trust Keystore Type, enter jks.
10. In Custom Trust Keystore Passphrase, enter the password used when creating the keystore.
11. Reboot the WebLogic Server instance for changes to take effect.

Resources:

http://download.oracle.com/docs/cd/E21764_01/web.1111/e13707/atn.htm#BABDBHAA

After all of that hard work you get to play. This playground just happens to be Oracle BI 11g’s BIComposer. Checkout this new tool which dumbs-down Oracle BI. The jury is still out on this one as being truly a viable integration but you judge for yourself.

Oracle BI 11g BIComposer – Part 3 from ArtOf BI on Vimeo.

This Series

• BIComposer – Part 1
• BIComposer – Part 2

Resources

• http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544/bicomposer.htm
• BIComposer Installation Guide

This is the longest in the series but it has the most detail and content. As you’ll see, as I was getting BIComposer set up this was the first run and we bumped into a few issues but we circled back around and explained the troubleshooting methods used to resolve the issues.

Oracle BI 11g BIComposer – Part 2 from ArtOf BI on Vimeo.

This Series

• BIComposer – Part 3
• BIComposer – Part 1

Resources

• http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10544/bicomposer.htm
• BIComposer Installation Guide