Register Oracle BI Publisher

6 Register Oracle BI Publisher

Register BI Publisher in HTTPS Mode

Oracle recommends you register BI Publisher in HTTPS mode to encrypt any communication between Oracle Communications Session Delivery Manager and BI Publisher. BI Publisher can be run in both HTTP and HTTPS modes. If you decide to run BI Publisher in HTTP mode, then you can skip this section and go to the Register BI Publisher in Session Delivery Manager section.

Enable HTTPS on the WebLogic Server

To encrypt the communication between BIP and SDM, first enable HTTPS on the WebLogic server.

Login to the administrative console of your WebLogic server. Use the username and password you created when installing BI Publisher.

In the default installation, the administrative console can be reached at http://<IP address>:9500/console.
Under Domain Structure in the left panel, click Environment, and then Servers.
In the main tab under Summary of Servers on the Configuration tab, click bi_server1.
In the Change Center, click Lock & Edit.
In the Configurations, General tab, check the SSL Listen Port Enabled check box (SSL Listen port number 9503).
Click Save.
In the Change Center, click Activate Changes.

In a cluster setup, repeat this task for each BIP server.

Save and Transfer the BI Publisher Certificate to Session Delivery Manager

Open your web browser and connect to BI Publisher. For example:

Note:
You must use secure HTTPS.
```
https://<myhostname>:9503/xmlpserver
```
Confirm that you understand the risks.
View and add the server certificate.
Select the server certificate you that you added and click Export.
Save the file with the .cer extension in one of the following formats:
- X.509 PEM (Linux)
- Base-64 (Windows)
Use the secure file transport protocol (SFTP) to send the saved BI Publisher certificate to a directory on your Oracle Communications Session Delivery Manager server.

Add the BI Publisher Certificate to the Session Delivery Manager Keystore

After transferring BI Publisher Certificate to your Oracle Communications Session Delivery manager server, you must add your BI Publisher certificate to the Oracle Communications Session Delivery Manager keystore.

You can either add the BI Publisher certificate through the SDM setup program (setup.sh) or upload it through the SDM GUI:

Note:

If you are using the SDM setup program to upload a BI Publisher certificate, you must run the setup program on each SDM server cluster node to upload the BI Publisher certificate on each node. If you perform this task through the SDM GUI, the BI Publisher certificate is replicated to all SDM cluster nodes.

See the Configure Southbound Interface Transport Layer Security section in the Custom Installation chapter of the Oracle Communications Session Delivery Manager Installation Guide for more information about loading the BI Publisher certificate through the SDM setup program.
See the Manage Certificates for Southbound Authentication chapter in the Oracle Communications Session Delivery Manager Administration Guide for more information about loading the BI Publisher certificate through the SDM GUI.

Register BI Publisher in Session Delivery Manager

After the Oracle Communications Session Delivery Manager installation, Oracle BI Publisher must be registered from within the SDM GUI application.

Start the Oracle Communications Session Delivery Manager server as the nncentral user:
```
cd /opt/AcmePacket/NNC<version>/bin/
./startnnc.sh
```
Navigate to your Oracle Communications Session Delivery Manager server IP address on port 8080.
Ensure that you have your product plugin installed.
Select Report Manager, Register BI Publisher.
(Use this step to re-register BI Publisher in SDM only) In the Register BI Publisher pane, click Configure Registration.

In the Register BI Publisher Step 1 of 2 pane, complete the following installation details fields to register a BI Publisher server:

Installation Location radio buttons

Select the following location type:

local—The Report Manager and BI Publisher software is installed on the same server.
remote—The Report Manager and BI Publisher software is installed on separate servers.

Note:

If you are registering BI Publisher with SSL on a local server, a domain name server (DNS) is required.

Installation Type radio buttons

Select the following installation type:

standalone—A single or remote installation of Oracle Communications Session Delivery Manager, Oracle BI Publisher, and their respective databases that work together to generate reports.
cluster—A cluster of servers (A local cluster is supported for 12c) that generate reports and provide high availability in case one system experiences a sudden failure. On each server that is part of the same cluster, Oracle BI Publisher and Oracle Communications Session Delivery Manager are installed with their respective databases.

Weblogic Admin User Name field

Enter weblogic. This is the user name that was created when you installed Oracle BI Publisher. Refer to the Install the Oracle Business Intelligence 12c Configuration Assistant section for more information.

Weblogic Admin Password field

Enter the Weblogic password that you created when you installed Oracle BI Publisher. Refer to the Install the Oracle Business Intelligence 12c Configuration Assistant section for more information.

Weblogic Admin Port field

Enter the Weblogic administrator port that you created when you installed Oracle BI Publisher. For example: 9500. Refer to the Install the Oracle Business Intelligence 12c Configuration Assistant section for more information.

Admin User Name field

Enter administrator. This is the user name that you entered when you configured BI Publisher security. Refer to Configure BI Publisher Security section for more information.

Admin Password field

Enter the Oracle BI Publisher administrator password that you created when you installed Oracle BI Publisher. Refer to Configure BI Publisher Security section for more information.

Click Next.

The available configuration parameters for Step 2 of 2 depend on your selections in Step 1 of 2.

Register a Local Standalone Mode of BI Publisher for Report Manager

If you entered local standalone in the previous section, use this additional task to register a local standalone installation of Oracle BI Publisher for Report Manager:

In the Register BI Publisher Step 2 of 2 pane, complete the following installation details fields to register a local standalone installation of Oracle BI Publisher for Report Manager:

Server Protocol drop-down list Select http or https for the secure hypertext transfer protocol.

Server Location field

The host name.

Note:

This value should be the same host name used when creating the certificate (For example, server1.oracle.com).

Server Port field The Oracle BI Publisher server port number. For example, 9502.

BI Publisher Home Folder field The BI Publisher Home Folder. For the installation previously documented, the path is /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi. The path for your installation may differ if you selected a different location for the OracleMiddleWare directory.

Repository Location field

The repository location that can be found by logging into BI Publisher and navigating to Administration, Server Configuration, Catalog, Path. For the installation previously documented, the repository location is /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/components/bipublisher/repository.

Note:

The 'nncentral' user must have write privileges for the BIP home folder and repository location.

BI Publisher Schema Prefix field The prefix schema for BI Publisher. The default prefix is DEV.

Oracle Database User Name field The nncentral user name for your Oracle database. See the Add an Oracle Database User that Connects to BI Publisher for Backup and Restore Functions section for more information.

Oracle Database User Password The password for the nncentral database user.

Oracle Database Service Name The Oracle database service name. Unless you previously selected a different name, enter AcmeBIPublisher.

Oracle Database Home Path Enter the Oracle database home path. For the installation previously documented, the Oracle database home path is: /home/oracle/app/oracle/product/12.2.0/dbhome_1

Oracle Database SID Enter the Oracle database SID. The SID is the first 12 characters of the Oracle Database Service Name. If AcmeBIPublisher is the Oracle Database Service Name, enter AcmeBIPublis.

Click Apply.

Registering a Remote Standalone BI Publisher

Use this task if you entered remote standalone in the previous step:

In the Register BI Publisher Step 2 of 2 pane, complete the following fields:

Server Protocol drop-down list

Select https or http for the web server protocol.

Server Location field

The host name of the server on which BI Publisher is installed.

Server Port field

The BI Publisher xmlpserver port. For example: 9502.

FTP User Name field

The FTP user name.

FTP Password field

The FTP password.

FTP Path for BI Publisher Home Folder field

The FTP path for the BI Publisher Home Folder. For example: /home/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/bi. The path for your installation may differ if you selected a different location for the OracleMiddleWare directory.

Click Apply.

Register a Local BI Publisher Cluster

If you entered the local and cluster options in the Register BI Publisher Step 1 of 2 pane, complete the following task:

Select the local cluster node and click Edit.
In the BI Publisher Cluster Member window, enter the protocol, IP address, port, FTP user name, FTP password, BI Publisher home folder, repository location, and Oracle database information for each node in the cluster.

Note:
If setting up a local cluster, the BI Publisher server information is pre-populated.
Click Apply to save and close the BI Publisher Cluster Member window.
Click Apply.