Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations Release 11.2 Part Number E26495-05 |
|
|
PDF · Mobi · ePub |
This chapter discusses how to configure and deploy the Oracle Customer Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy (Customer Data Synchronization for Oracle Utilities CCB and Siebel Energy) integration.
This chapter includes the following sections:.
The DCW screens prompt you to enter the data required for successful configuration of the Customer Data Synchronization for Oracle Utilities CCB and Siebel Energy integration. Enter the details of the Customer 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.
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: 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: 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. |
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: 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 Enterprise Server Name is __________________________ |
Siebel Version |
This is the version of the Siebel CRM application. Example: |
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 overwirte the configured Siebel Edge Application. Click OK to continue.
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: 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 _____________________________ |
Use this screen to enter details related to Oracle Utilities Customer Care and Billing server. The screen contains the following fields:
Table 24-4 Oracle Utilities Customer Care and Billing Server Details Screens Fields
Field | Description |
---|---|
CCB XAI Service URL |
This value is the location of the Customer Care and Billing web service. Example: CCB XAI Service URL is ________________________ |
CCB Username |
This value is the user ID of the Customer Care and Billing user authorized to invoke web services used in the integration. CCB Username is ________________________ |
CCB User Password |
This value is the password for the user specified above. CCB User Password is ________________________ |
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-5 Session Pool Manager Details Screen Fields
Field | Description |
---|---|
Proxy host url |
This determines the server to be set in the system properties for Proxy host url is ___________________________ |
Proxy port |
This determines the port to be set in the system properties for the 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 overwirte the configured Siebel Edge Application. Click OK to continue.
This section discusses the integration configuration and deployment process. There are two steps:
Configure your integration using the deployment DCW.
Deploy the integration to the Fusion Middleware server.
The screens that appear prompt you to enter the data that is required for successful configuration of the Customer Data Synchronization for Oracle Utilities CCB and Siebel Energy integration. Keep the completed worksheets of the Customer 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 Customer Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration:
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.
Replace WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false" with WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".
Restart the server.
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.
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.
Click Next.
Select the Oracle Customer Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy PIP
Click Next.
To specify Integration Server details:
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.
Click Next.
To specify Siebel CRM Server details:
Enter information about your Siebel CRM Server in the Application Details - Siebel CRM screen.
Click Next.
To specify Siebel CRM Database details:
Enter information about your Siebel CRM Database in the Siebel CRM Database Details screen.
Click Next.
To specify Utilities Customer Care and Billing Services details:
Enter information about your Utilities Customer Care and Billing Services installation in the Utilities Customer Care and Billing Services Details screen.
Click Next.
To specify Session Pool Manager detailss:
Enter information about your Session Pool Manager installation in the Session Pool Manager Details screen.
Click Next.
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.
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.
When the configuration process completes without errors, the AIA DCW displays the Configuration Complete screen.
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.
To configure using the response file:
Open the response file.
When you create a response file through OUI, passwords get stored as <SECURE>.
Replace the password fields with actual passwords in the response file.
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.
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.
To deploy the integration to Fusion Middleware server:
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.
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-6 Deployment Commands for the Customer 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/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerDPInstall.xml -DPropertiesFile=<AIA_HOME>/aia_instances/<aia_instance>/config/AIAInstallProperties.xml -DSupplementaryDeploymentPlan=<AIA_HOME>/pips/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerSupplementaryDP.xml -l <AIA_HOME>/pips/ OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomer.log Example: ant -f $AIA_HOME/Infrastructure/Install/AID/AIAInstallDriver.xml -DDeploymentPlan=$AIA_HOME/pips/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerDPInstall.xml -DPropertiesFile=$AIA_INSTANCE/config/AIAInstallProperties.xml -DSupplementaryDeploymentPlan=$AIA_HOME/pips/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerSupplementaryDP.xml -l $AIA_HOME/pips/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomer.log |
Microsoft Windows |
ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DDeploymentPlan=<AIA_HOME>\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerInstallDP.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml -DSupplementaryDeploymentPlan=<AIA_HOME>\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerSupplementaryDP.xml -l <AIA_HOME>\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerDP.log Example: ant -f %AIA_HOME%\Infrastructure\Install\AID\AIAInstallDriver.xml -DDeploymentPlan=%AIA_HOME%\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerDPInstall.xml -DPropertiesFile=%AIA_INSTANCE%\config\AIAInstallProperties.xml -DSupplementaryDeploymentPlan=%AIA_HOME%\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerSupplementaryDP.xml -l %AIA_HOME%\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomer.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.
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".
To verify the Customer Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration deployment:
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.
Confirm that the Customer Data Synchronization for Oracle Utilities CCB and Siebel Energy Integration components were successfully installed.
Navigate to the Oracle Enterprise Manager Fusion Middleware Control (http://<server name>:<port number>/em/).
Log in with the server admin user name. For access details, contact the system administrator.
Expand Farm_soa_domain, SOA, soa-infra, Default and look for the following items:
ProcessSalesOrderBillingAccountListSiebelUtilitiesConsumer
ProcessSalesOrderBillingAccountListSiebelUtilitiesProducer
ProcessSalesOrderSiebelUtilitiesJMSConsumer
ProcessSalesOrderSiebelUtilitiesReqABCSImpl
QueryCustomerPartyListSiebelUtilitiesProvABCSImplV1
SyncAccountSiebelUtilitiesAggregatorAdapter
SyncAddressSiebelUtilitiesAggregatorAdapter
SyncBPSiebelUtilitiesAggregatorAdapter
SyncContactSiebelUtilitiesAggregatorAdapter
SyncCustomerPartyOUCCBUtilitiesJMSConsumerV1
SyncCustomerPartyOUCCBUtilitiesProvABCSImpl
SyncCustomerPartyOUCCBUtilitiesProvJMSProducerV1
SyncCustomerSiebelUtilitiesEventAggregator
SyncCustomerSiebelUtilitiesEventAggregatorRoutingService
SyncSiebelUtilitiesAggrEventConsumer
SyncSPSiebelUtilitiesAggregatorAdapter
UpdateCustomerPartySiebelUtilitiesReqABCSImplV1
UtilitiesCustomerPartyEBSV2
UtilitiesProcessBillingAccountListEBF
UtilitiesProcessSalesOrderBillingAccountListEBF
UtilitiesSalesOrderEBSV2
Navigate to Farm_soa_domain, Weblogic Domain, right click <domain name>, Security, Credentials, oracle.wsm.security and verify the following items:
OU_CCB_01
For integration implementation, see Oracle Process Integration Pack for Oracle Utilities Field Work Implementation Guide.
To undeploy the integration from Fusion Middleware Server:
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.
Run the command for your platform.
Table 24-7 Undeployment Command for the Customer 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/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerDPUnInstall.xml -l <AIA_HOME>/pips/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerUndeployDP.log Example: ant Uninstall -f $AIA_HOME/Infrastructure/Install/AID/AIAInstallDriver.xml -DPropertiesFile=$AIA_INSTANCE/config/AIAInstallProperties.xml -DDeploymentPlan=$AIA_HOME/pips/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerDPUnInstall.xml -l $AIA_HOME/pips/OUCCBToSiebelEnergyCustomer/DeploymentPlans/OUCCBToSiebelEnergyCustomerUndeployDP.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\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerDPUnInstall.xml -l <AIA_HOME>\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerUndeployDP.log Example: ant Uninstall -f %AIA_HOME%\Infrastructure\Install\AID\AIAInstallDriver.xml -DPropertiesFile=%AIA_INSTANCE%\config\AIAInstallProperties.xml -DDeploymentPlan=%AIA_HOME%\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerDPUnInstall.xml -l %AIA_HOME%\pips\OUCCBToSiebelEnergyCustomer\DeploymentPlans\OUCCBToSiebelEnergyCustomerUndeployDP.log |
Restart the SOA server.
Verify that all the integration composites are undeployed correctly.
Uninstall the integration following the instructions in Chapter 39, "Uninstalling Oracle AIA".