Post-installation tasks

• Configure SAP BusinessObjects Enterprise to ITBA
• Install the Vertica driver in the BusinessObjects Enterprise server
• Deploy the HPE ITOC Reports content pack
• Configure data sources
• ETL management
• Configure secure connection for SAP BusinessObjects server

Configure SAP BusinessObjects Enterprise to ITBA

For information about configuring SAP BusinessObjects Enterprise to ITBA, see the HPE IT Business Analytics Administrator Guide.

Install the Vertica driver in the BusinessObjects Enterprise server

You must install the HPE Vertica driver in the BusinessObjects Enterprise server as follows:

1. Get the Vertica JDBC driver from HPBA in the following directory:

   %ITBA_HOME%/glassfish/glassfish/domains/BTOA/lib/vertica-jdbc-7.1.1-0.jar

2. Copy the driver to the following location in the SAP BusinessObjects Enterprise server:

   <BO_INSTALLATION_DIRECTORY>/sap_bobj/enterprise_xi40/dataAccess/connectionServer/jdbc/

3. Open the following file:

   <BO_INSTALLATION_DIRECTORY>/sap_bobj/enterprise_xi40/dataAccess/connectionServer/jdbc/jdbc.sbo

4. Add the JDBCDriver file path to the ClassPath tag in the jdbc.sbo file, as shown below. Add the highlighted content as shown below to the jdbc.sbo file:

   

   The following example shows the highlighted portion of the above illustration:

   <DataBase Active="Yes" Name="Vertica JDBC">
   <JDBCDriver>
   <ClassPath>
   <Path>[BO_INSTALLATION_DIRECTORY]/sap_bobj/enterprise_xi40/dataAccess/connectionServer/jdbc/vertica-jdbc-7.1.1-0.jar</Path>
   </ClassPath>
   <Parameter Name="JDBC Class">$JDBCCLASS$</Parameter>
   <Parameter Name="URL Format">$DATASOURCE$</Parameter>
   </JDBCDriver>
   <Parameter Name="Array Fetch Size">10</Parameter>
   </DataBase>

5. Execute the following scripts:

   cd <BO_INSTALLATION_DIRECTORY>/sap_bobj
   ./stopservers
   ./tomcatshutdown.sh
   ./startservers
   ./tomcatstartup.sh

Deploy the HPE ITOC Reports content pack

1. Download the HPE ITOC Reports content pack (HP_ITOC_Reports_1.20_ContentPack.zip) from HPE LN.
2. Copy the zip file to a temporary folder in your local machine.
3. Unzip the HP_ITOC_Reports_1.20_ContentPack.zip file after which you can see the CORE and ITOC folders.
4. Switch user to ITBA_installer_Username.
5. With the above sudo user, copy the CORE and ITOC folders to $HPBA_HOME/Content Packs/.
6. Log in to ITBA as an administrator.
7. To deploy the HPE ITOC content pack:
   1. Navigate to the Data Management panel.
   2. Click the Install Content Pack tab.
   3. Select ITOC, and click Install.
8. The Install option changes to Upgrade. Click Upgrade.
9. You can view the logs at:

   $ HPBA_HOME/glassfish/glassfish/domains/BTOA/logs/

Configure data sources

The Data Source page enables you to manage the integration of data into the data warehouse through the activation of data sources. The available data source content packs are registered in the deployment process and can then be activated in the Connect Data Source page.

Add and activate a new data source instance

The process of integrating a data source into the data warehouse is done through activation of the source instance.

1. In the ITBA application, select Admin > Data Management > Connect Data Source > Add data source.

   

2. Click Add data source to open the Data Source wizard. The Add Data Source page opens.
3. Select the data source type (ITOC) and click Next. The relevant data source page opens.

   

4. Enter configuration parameters:
   
   1. Enter the instance name. The instance name can be your ITOC name or any name of your choice.
   2. Select thei ITOC version.
   3. Select the time zone.
   4. Select the data source type.
   5. Enter the database user name.
   6. Enter the database password.
   7. Enter the ITOC server host name or IP address.
5. Click Next.

   

6. The data source instance is activated.

   

   Note: If the first-time activation of a data source instance fails, the instance is displayed in the source list with an Error status. You can then activate the data source by clicking Edit Settings and completing the configuration and activation.

View data source configuration settings

1. Select Admin > Data Management > Connect Data Source.
2. Click View Settings. The relevant data source page opens.

Edit data source settings and test the connection

1. Select Admin > Data Management > Connect Data Source.
2. Click Edit Settings, and edit the configuration parameters.
3. Click Next to validate your changes and test the connection to the data source.

ETL management

After a content pack (CP) is activated, the content pack manager notifies the content flow manager to create a job stream for this CP instance. The job stream includes a series of predefined steps.

Each step is an individual job such as an extractor job or an ETL job. The job executes the back-end process to pull the data from the data source to the data warehouse.

Each content pack instance has an individual job, and each job can run in parallel.

Run a job instance using the Content Flow Manager

1. In the ITBA application, select Admin > Data Management > Run ETL.
2. Click Scheduler for the relevant instance:

   

3. Enter the relevant time stamp for scheduling the job instance run. The CronExpression is built in the box below the options. Click Apply.

   

View details of the job instance run

1. In the ITBA application, select Admin > Data Management > Run ETL.

2. Click the icon for the relevant job instance run (you might have to use the scroll bar to see the button). The list of the job instance runs of the instance is displayed. Use the filter to select the runs you want to display.

3. Click the icon for the relevant job instance run. The list of the job instance run steps is displayed.

   

4. Click the icon to see the details of jobs run such as job name and status.

   

Configure secure connection for SAP BusinessObjects server

After the SAP BusinessObjects installation, perform the following steps to configure a secure HTTPS connection.

1. Generate the keystore for SAP BusinessObjects Enterprise server. On the SAP BusinessObjects Enterprise server, SSH to theSAP BusinessObjects server and run the following commands in the Tomcat server.xml config file:
   1. keytool -genkey -alias tomcat -keyalg RSA -keystore /home/bocacerts
   2. openssl genrsa -des3 -out /home/server.key 4096
   3. openssl req -new -key /home/server.key -out /home/server.csr
   4. openssl x509 -req -days 999 -in /home/server.csr -signkey /home/server.key -out /home/server.crt
   5. keytool -import -alias root -keystore /home/bocacerts -trustcacerts -file /home/server.crt
2. Edit <BOE>/sap_bobj/tomcat/conf/server.xml:

   Remove the comment for the connector with port 8443 and modify it as shown in the following example.

   Note: Port 9443 is used in the example; however, you can use any free port in your environment:

   …

   <Connector port="9443" protocol="HTTP/1.1" SSLEnabled="true"

   maxThreads="150" scheme="https" secure="true"

   keystoreFile=”/home/bocacerts" keystorePass="<keystore password set in above step>" clientAuth="false" sslProtocol="TLS" />

3. Restart Tomcat in the SAP BusinessObjects Enterprise Central Configuration Manager:
   1. Open the <BOE>/sap_bobj/ folder.
   2. Run the following commands:

      ./tomcatshutdown.sh

      ./tomcatstartup.sh

4. Using a database client such as SQuirrel, change the SAP BusinessObjects open doc port in the ITBA management database:
   • Postgres DB: xs_mng
   • User: xsadmin
   • Password: openview
   • Table: fnd.settings_management
   • SQL script: Update fnd.settings_management set VALUE = 9443 where CONTEXT = 'bo' and NAME = 'bo.cms.opendoc.port'
5. SSH to the ITBA server. Change the SAP BusinessObjects open doc protocol to https in the SAP BusinessObjects settings XML.
   1. Open <HPBA>/glassfish/glassfish/domains/BTOA/config/settings/bo-settings.xml
   2. Update the protocol from http to https:

      ...
<setting name="bo.cms.protocol"
sectionKey="sections.bo"
nameKey="settings.bo.cms.protocol.name"
descKey="settings.bo.cms.protocol.desc"
refreshRate="Immediate"
displayInUI="false"
settingType="tenant">
<string>https</string>
</setting>
...

6. Restart the HPBA services:
   1. Open <HPBA>/supervisor/configure
   2. Run the command:

      ./install_supervisor_conf.sh

   3. Open <HPBA>/supervisor/bin.
   4. Run the command:

      ./hpba-restart.sh