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.