Copyright © TIBCO Software Inc. All Rights Reserved


Tutorial : Procedure

Procedure
The following sections provide details about how to develop, deploy, and run the example:
1.
2.
3.
4.
5.
6.
7.
8.
Importing the Classic OEBSBWSE TIBCO BusinessWorks Project
This section shows how to import the predefined OEBSBWSE TIBCO BusinessWorks project to TIBCO Business Studio.
Complete the following steps to import an existing TIBCO BusinessWorks project:
1.
2.
Select File > New > Project from the Menu to open the New Project dialog.
3.
Select TIBCO Designer > TIBCO Designer Project in the Select A Wizard page, and then click the Next button.
Before creating or importing a TIBCO ActiveMatrix BusinessWorks Service Engine Plug-in for Oracle E-Business Suite Designer project, you need to install TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite.
4.
Select the Create Project Using Existing Designer Project radio button, then click the Browse button to specify the project location.
The directory for the OEBSBWSE TIBCO Designer project is TIBCO_HOME\bwse\plugins\oebs\samples.
5.
Check the Copy Project Into Workspace checkbox, then click the Finish button.
The classic OEBSBWSE TIBCO BusinessWorks project appears in the Project Explorer panel.
Configuring the Classic OEBSBWSE TIBCO BusinessWorks Project
After importing the classic OEBSBWSE TIBCO BusinessWorks project, configure it by completing the following tasks:
Task A Connect to Oracle Database Server
A connection to the Oracle database server is required by the plug-in for the configuration of the basic settings. Refer to Chapter 2 of TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite User’s Guide for details about how to connect to the Oracle database server.
Task B Configure the Oracle E-Business Suite Connection
Before running or deploying the project, you need to configure the Oracle E-Business Suite connection, then test to see f the connection is successfull.
Figure 6 shows a sample screen of the Oracle E-Business Suite Connection panel.
Figure 6 OracleEBSConnection Settings
The following steps shows how to configure and test the Oracle E-Business Suite Connection share resource:
1.
Expand the OEBSBWSE folder in the Project Explore panel.
2.
Click the OracleEBSConnection shared resource in the DABS Main View panel.
3.
Review and configure the information in the Configuration tab, such as, Database URL, APPS User Name, APPS User Password, and so on.
Refer to TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite User’s Guide for details about Oracle E-Business Suite Connection resource.
4.
Click the Test Connection button to test the connection.
5.
Click the Apply button to save the configuration.
Task C Run the BOM_BO_PUB SQL Script Using the Oracle Application Administrator Account
BOM_BO_PUB package contains PL/SQL data types that are not accessible outside the package. Therefore, you need to use Oracle JPublisher to generate PL/SQL scripts. After running the generated PL/SQL scripts, the wrappers are created. You are then able to invoke the procedures contained inside the Oracle E-Business Suite APIs packages.
In this example, the generated SQL scripts are associated in the TIBCO_HOME\bwse\plugins\oebs\samples\jpub directory:
BOM_BO_PUB SQL script
BOM_BO_PUB_drop SQL script
Refer to Apendix D in TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite User’s Guide for details about how to use Oracle JPublisher to create the wrappers.
Task D Generate and Run SQL Scripts
After reviewing and configuring each activity in the two processes, you need to generate the SQL scripts for the involved PL/SQL APIs, for example, BOM_BO_PUB and EGO_ITEM_PUB:
1.
Expand the OEBSBWSE > Processes folder in the Project Explore panel.
2.
Select an activity in the process, for example, the CreateInventoryItem1 activity in inventoryProcess.
3.
Click the Generate SQL Script button to generate two SQL scripts.
The two SQL scripts ProcessName_ActivityName_APIPackageAndName.APIProcedureName.sql and ProcessName_ActivityName_APIPackageName.APIProcedureName_undo.sql are created in the TIBCO_HOME\bw\plugins\oracleebs\sql directory.
4.
Repeat the above steps to run the SQL script for the other activities. Refer to Chapter 5 of TIBCO ActiveMatrix BusinessWorks Plug-in for Oracle E-Business Suite User’s Guide for details.
Importing the OEBSReference SOA Project
Complete the following steps to import the existing OEBSReference SOA project:
1.
Select File > Import from the Menu in TIBCO Business Studio.
2.
Select General > Existing Projects Into Workspace, then click the Next button in the Import dialog.
3.
Click the Browse button to select the root directory of the SOA project.
The directory for the OEBSReference SOA project is TIBCO_HOME\bwse\plugins\oebs\samples.
4.
Check the Copy Projects Into Workspace checkbox, then click the Finish button.
The OEBSReference SOA project appears in the Project Explorer panel.
Reviewing the Composite Configuration of the OEBSReference SOA Project
Complete the following steps to review the composite configuration:
1.
Expand the Composites folder of the OEBSReference project in the Project Explorer panel.
2.
Double-click the predefined OEBSReference.composite composite to launch the Composite Editor, as shown in Figure 7.
Figure 7 OEBSReference Composite
 
3.
Select a component in the OEBSReference composite and view the configuration of the component from the Properties tab. There are two components in this composite: BOM_SER_BWSE and INV_SER_BWSE.
4.
Select the promoted service named bomPortType and view the binding configuration from a Properties tab, as shown in Figure 8.
Figure 8 Promoted Service Binding
5.
Select a component or composite property to view the property configuration from the Properties tab. Figure 9 show a sample screen of the Composite property.
Figure 9 Composite Property
 
6.
Creating a Distributed Application Archive (DAA)
Projects developed during design time need to be packaged into a DAA file before you can deploy them in the TIBCO ActiveMatrix environment.
To create a DAA using Business Studio, complete the following steps:
1.
Expand the Composite folder in the Project Explorer panel, right-click OEBSReference.composite, and select Create DAA from the popup menu.
2.
Select the Deployment Artifacts folder in the Select Archive Location page.
Enter a new filename or accept the default name in the File Name field. Then click the Next button.
3.
Select the Do Not Use A Distribution File radio button in the Select Distribution page, then click the Next button.
4.
Check the Save DAA Spec checkbox in the DAA Specification page, then click the Finish button.
The OEBSReference DAA file is created successfully and stored in the OEBSReference\Deployment Artifacts folder in your workspace.
To check the location of the DAA file, you can expand the OEBSReference > Deployment Artifacts folder in the Project Explorer panel, right-click OEBSReference.daa, then select Properties from the popup menu.
Setting Up the TIBCO ActiveMatrix Environment
Complete the following steps to set up the TIBCO ActiveMatrix environment:
1.
Right-click the My Computer icon on your desktop, select Manage from the pop-up menu.
Expand the Services and Applications > Services folder in the Computer Management window. Select and then start the TIBCO EMS Server service.
2.
Run the executable named tibcohost.exe located in the TIBCO ActiveMatrix configuration directory: TIBCO_Configuration_Folder\tibcohost\TibcohostInstance_name\host\bin.
3.
If TIBCO ActiveMatrix Administrator has been created:
a.
Launch a web browser and enter the Administrator URL, http://host_name:port_number/amxadministrator/loginForm.jsp, in the address bar to start the TIBCO ActiveMatrix Administrator Server.
b.
If TIBCO ActiveMatrix Administrator has not been created, see TIBCO ActiveMatrix BusinessWorks Service Engine Plug-in for Oracle E-Business Suite Installation for instructions about how to create it.
4.
Add the TIBCO Enabled JDBC Driver For Oracle driver on the node where the application will be deployed, for example, DevNode. Refer to Chapter 3 of TIBCO ActiveMatrix BusinessWorks Service Engine Plug-in for Oracle E-Business Suite Installation for details.
Adding an HTTP Connector Resource Instance
An HTTP connector describes an incoming HTTP connection. The following steps describe how to add an HTTP Connector resource instance using TIBCO ActiveMatrix Administrator:
1.
2.
Select Shared Objects > Resource Templates.
3.
Click the New button in the Resource Templates page. The Add Resource Template dialog appears.
4.
Enter httpConnectorBOM in the Name field.
Select HTTP Connector from the Type drop-down list.
The name of the HTTP Connector resource must be the same as the binding connector name of the bomPortType promoted service, for example, httpConnectorBOM, as shown in Figure 8.
Also, make sure that the values in the Machine Name and Port fields are consistent with the Host and Port fields when creating the concrete WSDL to run the example project. See Running the Example for details.
Click the Save button.
5.
Select the newly created HTTP Connector resource, then click the New Resource Instances button in the Resource Templates page.
The New Resource Instances dialog appears.
6.
Select the SystemHost item (the default host) in the Host column.
Select a node on which the application will be deployed, for example, DevNode, in the Available Nodes list, then click the button to move the DevNode item to the Selected Nodes list.
Click the Save And Install button.
Figure 10 New Resource Instances
The HTTP Connector resource instance is created successfully.
Deploying the DAA
The following steps describe how to deploy the DAA using TIBCO ActiveMatrix Administrator:
1.
2.
Select the Applications tab and click the New button.
3.
a.
b.
Select the Upload A DAA File radio button.
c.
Click the Next button.
4.
Click the Browse button and select the DAA file created previously in Creating a Distributed Application Archive (DAA).
5.
Click the Next button.
6.
7.
Select the newly created OEBSReference item from the Applications list. Click the Distribution tab of the selected application.
8.
Select the application in the left-hand panel, then select the node on which you want to distribute it. For example, select the DevNode item in the Available Nodes column, then move it to the Selected Nodes column.
9.
Click the Save button.
10.
Click the Deploy button, then select Deploy With Start from the pop-up menu to deploy and start the application.
The OEBSReference application status in the Runtime State column appears as Running, as shown in Figure 11.
Figure 11 Deploy and Run the Service

Copyright © TIBCO Software Inc. All Rights Reserved