Siebel Life Sciences Guide > Configuring Data for Oracle Pharma Sales Analytics > Creating Target Lists Using Oracle Business Intelligence >

Using Target List Creator with Siebel Pharma Applications in Connected Mode

You can also use the Target List Creator with the Siebel Pharma application and Oracle Pharma Sales Analytics in connected mode. This topic lists the tasks that you must carry out to verify the Siebel Pharma application's configuration to support using the Target List creator in connected mode:

• Configuration Changes to the Siebel Business Application
• Configuring the Application's Server Component Parameters and Enterprise Profile

Install and Configure the Oracle Business Open Intelligence Interface

The LS Analytics Target Service business service uses an ODBC DSN to connect back to the Oracle BI Server and execute the Oracle BI logical SQL passed into it. This ODBC DSN needs to be setup using the Oracle BI Open Intelligence Interface (ODBC) client, and requires that this client be installed on the Siebel Pharma application server. To install and configure the Oracle BI Open Intelligence Interface, see Oracle Business Intelligence Applications Installation and Configuration Guide.

Configuration Changes to the Siebel Business Application

To enable the LS Analytics Target Service Business Service to be called from the Siebel browser client, the Business Service name has to be present as a ClientBusinessService user property for the Siebel Business Application being used.

To verify the LS Analytics Target Service business service

1. In Siebel Web Tools, find the Siebel Life Sciences application record in the Application objects list.
2. In the Application User Prop list verify that the following entry exists:

   ClientBusinessService10 = LS Analytics Target Service

Configuring the Application's Server Component Parameters and Enterprise Profile

The Oracle BI Open Intelligence Interface ODBC DSN connection must be configured as a new data source profile for the Siebel Enterprise and must be associated with the Siebel Business Application's Object Manager configuration.

To configure a new data source profile and associate with AnalyticsDataSrc

1. Log in to the Siebel Business Application as an administrator.
2. Navigate to the Administration - Server Configuration screen, then the Enterprises view.
3. Click the Profile Configuration tab.
4. Search for the AnalyticsDataSrc in the list. If it does not exist, then copy the existing ServerDataSrc record, and rename the copy to AnalyticsDataSrc.
5. Update the following parameters with the values indicated:

   DSDLLName = sscdsacon

   DSConnectString = AnalyticsWeb

   DSTableOwner = <blank>

6. Click the Component Definitions tab.
7. In the Component list, search for the appropriate Application's Object Manager.

   For example, for Oracle's Siebel Pharma, search for ePharmaObjMgr_ENU.

8. With the Component selected, click Menu (the cogwheel icon), and then select Start Reconfiguration.
9. Search for OM - Named Data Source name in the Component Parameters list.
10. Append the current list at the end with AnalyticsDataSrc.
11. Click Menu (the cogwheel icon), and select Commit Reconfiguration from the drop-down list.
12. Log out of the application.
13. Log in to the server manager, and restart the component by executing the following commands:

    shutdown comp ePharmaObjMgr_enu

    startup comp ePharmaObjMgr_enu

14. Log in to the application again.

    The Create Target List functionality is enabled.