Skip Headers
Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations
Release 11.3

Part Number E28316-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

24 Configuring and Deploying Product Data Synchronization for Oracle Utilities CCB and Siebel Energy

This chapter discusses how to configure and deploy the Oracle Product Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy (Product Data Synchronization for Oracle Utilities CCB and Siebel Energy) integration.

This chapter includes the following sections:

24.1 Deployment Configuration Wizard

The DCW screens prompt you to enter the data required for successful configuration of the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration. Enter the details of the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.

24.1.1 Integration Server Details Screen

All artifacts associated with the integration infrastructure components deploy to the integration server. This screen contains the following fields:

Table 24-1 Integration Server Details Screen

Field Description

Admin Host Name

This is where the admin server resides. This can be a remote server or the same computer where the AIA Pre-Built Integrations Installer is launched. Example: server1.company.com.

The Admin Host Name is _________________________________

Admin Port

This is the port number on which Weblogic Admin server is started. To find this value contact WebLogic administrator. Example: 7001.

The Admin Port is _____________________________________

Domain Name

This is WebLogic server domain corresponding to the Admin Server. Example: domain1

The Domain Name is _____________________________________

Admin User Name

This value is the WebLogic admin user name. To find this value contact your WebLogic administrator.

The User Name is __________________________________

Admin Password

This value is the WebLogic admin password. To find this value contact your WebLogic administrator.

The password is _____________________________________

Managed Server

After you enter the Admin Host name, Admin Port, Domain Name, Admin User name and Admin Password, this field gets populated with managed servers for the domain. Select the manager server from the list. If you are deploying the integration to a SOA cluster, you should select the cluster name in this field.

The Managed Server is _______________________________

Managed Port

This field gets updated automatically after you select the managed server. If you have configured a SOA Cluster the SOA Cluster port appears in the list.


Note:

If you are installing both Oracle Customer Data Synchronization and Oracle Product Data Synchronization Integration Packs for Oracle Utilities Customer Care and Billing and Siebel Energy, ensure the Siebel environment details are the same for both.

24.1.2 Siebel CRM Server Details Screen

Use this screen to enter details related to your Siebel CRM server instance. The screen contains the following fields:

Table 24-2 Siebel CRM Server Details Screen Fields

Field Description

Siebel Hostname

This value is the fully qualified computer name of the Siebel CRM application. Example: example1.corp.siebel.com.

Siebel Host name is _________________________________

Siebel HTTP Port

This value is the Siebel CRM application port. To find this value, contact your administrator. Example: 8024.

Siebel HTTP Port is _______________________________

Internet Protocol

Specifies the Siebel host internet protocol. For example: http://.

Siebel host internet protocol is _____________________________

Siebel EAI Application User

To find this value, contact your administrator.

Siebel EAI Application User is ____________________________

Siebel EAI Application Password

To find this value, contact your administrator.

Siebel EAI Application Password is _______________________

Siebel Enterprise Server Name

To find this value, contact your administrator. Example: Siebel

Siebel Enterprise Server Name is __________________________

Siebel Version

This is the version of the Siebel CRM application. Example: 8.1.1.6

Siebel Language

This is the language used by the Siebel application. For example, enu.

Siebel Language is ________________________


Note:

If you are installing both Oracle Customer Data Synchronization and Oracle Product Data Synchronization Integration Packs for Oracle Utilities Customer Care and Billing and Siebel Energy, ensure the Siebel environment details are the same for both.

In this scenario, a message appears asking you to overwrite the configured Siebel Edge Application. Click OK to continue.

24.1.3 Siebel CRM Database Details Screen

Use this screen to enter details related to your Siebel CRM database instance. The screen contains the following fields:

Table 24-3 Siebel CRM Database Details Screen Fields

Field Description

Siebel Database Host

This value is typically the computer name. To find this value, contact the database administrator. Example: server1.corp.siebel.com.

Siebel Database Host is _____________________________

Siebel Database Port

To find this value, contact the database administrator. Example: 1521.

Siebel Database Port is ______________________________

Siebel Database Username

Specifies a database user that has access to loading the EIM tables Siebel. To find this value, contact the database administrator. Example: ora12345

Siebel Database Username is ____________________________

Siebel Database Password

To find this value, contact the database administrator.

Siebel Database Password is _____________________________

Siebel Database SID

To find this value, contact the database administrator.

Siebel Database System ID is _____________________________


24.1.4 Session Pool Manager Details Screen

The Session Pool Manager (SPM) details are optional and required only when your Siebel server is outside of the firewall. If all your servers are within the network, leave these fields blank.

In the java.net application programming interface (API) used by SPM, proxies are supported through two system properties: http.proxyHost and http.proxyPort. They must be set to the proxy server and port respectively. This value is only set when ProxySettings_Enabled is set to TRUE.

Table 24-4 Session Pool Manager Details Screen Fields

Field Description

Proxy host url

This determines the server to be set in the system properties for http.proxyHost property.

Proxy host url is ___________________________

Proxy port

This determines the port to be set in the system properties for the http.proxyPort property.

Proxy port is ______________________________


Note:

If you are installing both Oracle Customer Data Synchronization and Oracle Product Data Synchronization Integration Packs for Oracle Utilities Customer Care and Billing and Siebel Energy, ensure the Siebel environment details are the same for both.

In this scenario, a message appears asking you to overwrite the configured Siebel Edge Application. Click OK to continue.

24.2 Configuring and Deploying Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration

This section discusses the integration configuration and deployment process. There are two steps:

  1. Configure your integration using the deployment DCW.

  2. Deploy the integration to the Fusion Middleware server.

24.2.1 Configuring the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration

The screens that appear prompt you to enter the data that is required for successful configuration of the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration. Keep the completed worksheets of the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration screens ready before you launch the DCW.

Note:

If you are harvesting content to OER, perform the first three steps. Else start from step 4.

To configure the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration:

  1. Navigate to /slot/emsxxxx/oracle/Middleware/user_projects/domains/soa_domain/bin/ and open setDomainEnv.sh for Linux based systems and setDomainEnv.bat for Microsoft Windows.

  2. Replace WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false" with WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".

  3. Restart the server.

  4. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  5. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh for Linux based systems and aiaconfig.bat for Microsoft Windows.

    This launches the AIA DCW.

  6. Click Next.

  7. Select the Oracle Product Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy PIP

  8. Click Next.

24.2.1.1 Specify Integration Server Details

To specify Integration Server details:

  1. Enter information related to your integration server in the Integration Server Details screen.

    After providing admin user and password, Managed Server and Port are automatically selected.

  2. Click Next.

24.2.1.2 Specify Siebel CRM Server Details

To specify Siebel CRM Server details:

  1. Enter information about your Siebel CRM Server in the Application Details - Siebel CRM screen.

  2. Click Next.

24.2.1.3 Specify Siebel CRM Database Details

To specify Siebel CRM Database details:

  1. Enter information about your Siebel CRM Database in the Siebel CRM Database Details screen.

  2. Click Next.

24.2.1.4 Specify Session Pool Manager Details

To specify Session Pool Manager details:

  1. Enter information about your Session Pool Manager installation in the Session Pool Manager Details screen.

  2. Click Next.

24.2.1.5 Complete Configuration

To complete configuration:

  1. Review the configuration information on the Configuration Summary screen.

    Note:

    If you want to make changes to the configuration, use the navigation pane on the left and select the screen you want to edit.

    You can create a response file based on the input provided in the DCW and use it in future when you want to deploy the integration. You can configure using the steps described in Section 24.2.2, "Configuring using the Response File". Click Save Response File and save the response file with the name and location of your choice.

  2. Click Configure to accept the configuration.

    The system displays progress of the configuration in the Configuration Progress screen.

    The system displays any warnings or errors as necessary. You can review the configuration log for additional details. The configuration log location is displayed in Configuration Progress screen.

  3. When the configuration process completes without errors, the AIA DCW displays the Configuration Complete screen.

  4. Click Finish to close the DCW.

    Note:

    If you encounter any issues running aiaconfig.sh on AIX, see the KIWA report of this integration for further details.

24.2.2 Configuring using the Response File

To configure using the response file:

  1. Open the response file.

    When you create a response file through OUI, passwords get stored as <SECURE>.

  2. Replace the password fields with actual passwords in the response file.

  3. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems, . ./aiaenv.sh for AIX based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  4. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh <Response File Location and Name> for Linux based systems and aiaconfig.bat <Response File Location and Name> for Microsoft Windows.

24.2.3 Deploying the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration

To deploy the integration to Fusion Middleware server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems, . ./aiaenv.sh for AIX based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Note:

    When you copy and paste the command in the command line, ensure that there is space between .xml and -. Ensure that there is space between these two when you run undeployment command too.

    Table 24-5 Deployment Commands for the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration

    Platform Deployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DDeploymentPlan=<AIA_HOME>/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductDPInstall.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<aia_instance>/config/AIAInstallProperties.xml 
    -DSupplementaryDeploymentPlan=<AIA_HOME>/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductSupplementaryDP.xml 
    -l <AIA_HOME>/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProduct.log
    

    Example:

    ant -f $AIA_HOME/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DDeploymentPlan=$AIA_HOME/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductDPInstall.xml 
    -DPropertiesFile=$AIA_INSTANCE/config/AIAInstallProperties.xml 
    -DSupplementaryDeploymentPlan=$AIA_HOME/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductSupplementaryDP.xml 
    -l $AIA_HOME/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductDPInstall.log
    

    Microsoft Windows

    ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DDeploymentPlan=<AIA_HOME>\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPInstall.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml 
    -DSupplementaryDeploymentPlan=<AIA_HOME>\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductSupplementaryDP.xml 
    -l <AIA_HOME>\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPInstall.log
    

    Example:

    ant -f %AIA_HOME%\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DDeploymentPlan=%AIA_HOME%\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPInstall.xml 
    -DPropertiesFile=%AIA_INSTANCE%\config\AIAInstallProperties.xml 
    -DSupplementaryDeploymentPlan=%AIA_HOME%\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductSupplementaryDP.xml 
    -l %AIA_HOME%\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPInstall.log
    

    Note:

    In Windows 2008, 2008 R2 and Vista, run the command prompt as an administrator (elevated mode). If the command prompt is invoked in normal mode, the integrations are not displayed.

  3. Review the log file in the location specified in the command to verify successful deployment.

Oracle AIA ships artifacts in AIA Lifecycle Workbench which can be used in your integrations. These artifacts are created using FMW technologies such as BPEL and Mediator and are natively supported by AIA Foundation Pack tools such as Project Lifecycle Workbench, Harvester, Deployment Generator, AIA Deployment Driver (ADD). These are called native artifacts and they include SOA artifact types such as composites, DataSources, DVM, xRef, and so on. These artifacts can be modified or new natively supported artifacts can be added using the AIA Lifecyle Workbench and a BOM.xml file can be generated.

AIA integration development teams, most often, also require deployment of artifact types that are beyond what is supported by the Project Lifecycle Workbench and AIA Harvester. For instance, integration may require artifacts such as, Java applications, Shell Scripts, ANT based build scripts which constitute part of integration landscape in addition to the artifacts that are delivered by AIA. AIA also supports deployment of these supplementary artifacts. However, you must modify and add new non native artifacts outside AIA Lifecycle Workbench.

For more information on deploying artifacts, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Generating Deployment Plans and Deploying Artifacts".

24.3 Verifying Deployment

To verify the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration deployment:

  1. Open the log files from the following location and look for warnings and error messages:

    • For Linux, Solaris SPARC, HP-UX and IBM AIX Based Systems: Review the install log located at <AIA_HOME>/aia_instances/<instance name>/logs to verify that the integration is successfully installed.

    • For Microsoft Windows: Review the install log located at <AIA_HOME>\aia_instances\<instance name>\logs to verify that the integration is successfully installed.

  2. Confirm that the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration components were successfully installed.

    1. Navigate to the Oracle Enterprise Manager Fusion Middleware Control (http://<server name>:<port number>/em/).

    2. Log in with the server admin user name. For access details, contact the system administrator.

    3. Expand Farm_soa_domain, SOA, soa-infra, Default and look for the following items:

    • SyncItemCompositionOUCCBUtilitiesReqABCSImpl

    • SyncItemCompositionSiebelUtilitiesProvABCSImpl

    • SyncItemCompositionResponseOUCCBUtilitiesProvABCSImpl

    • UtilitiesItemCompositionEBS

    • UtilitiesItemCompositionResponseEBS

    • SyncProductListOUCCBUtilitiesJMSConsumerV1

    • SyncProductListResponseOUCCBUtilitiesJMSProducerV1

    Note:

    The Queue needed by Oracle Utilities Customer Care and Billing to publish Products into and the queue needed to read response message from Siebel Energy into Oracle Utilities Customer Care and Billing resides on the Integration Server.

For integration implementation, see Oracle Product Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy Implementation Guide.

24.4 Undeploying the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration

To undeploy the integration from Fusion Middleware Server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems, . ./aiaenv.sh for AIX based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Table 24-6 Undeployment Command for the Product Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration

    Platform Undeployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant Uninstall -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance_name>/config/AIAInstallProperties.xml  
    -DDeploymentPlan=<AIA_HOME>/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductDPUnInstall.xml 
    -l <AIA_HOME>/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductDPUnInstall.log
    

    Example:

    ant Uninstall -f $AIA_HOME/Infrastructure/Install/AID/AIAInstallDriver.xml
    -DPropertiesFile=$AIA_INSTANCE/config/AIAInstallProperties.xml
    -DDeploymentPlan=$AIA_HOME/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductDPUnInstall.xml
    -l $AIA_HOME/pips/OUCCBToSiebelEnergyProduct/DeploymentPlans/OUCCBToSiebelEnergyProductDPUnInstall.log
    

    Microsoft Windows

    ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance_name>\config\AIAInstallProperties.xml  
    -DDeploymentPlan=<AIA_HOME>\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPUnInstall.xml 
    -l <AIA_HOME>\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPUnInstall.log
    

    Example:

    ant Uninstall -f %AIA_HOME%\Infrastructure\Install\AID\AIAInstallDriver.xml
    -DPropertiesFile=%AIA_INSTANCE%\config\AIAInstallProperties.xml
    -DDeploymentPlan=%AIA_HOME%\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPUnInstall.xml
    -l %AIA_HOME%\pips\OUCCBToSiebelEnergyProduct\DeploymentPlans\OUCCBToSiebelEnergyProductDPUnInstall.log
    

  3. Restart the SOA server.

  4. Verify that all the integration composites are undeployed correctly.

  5. Uninstall the integration following the instructions in Chapter 37, "Uninstalling Oracle AIA".