{"id":1564,"date":"2010-04-22T12:15:23","date_gmt":"2010-04-22T17:15:23","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=1564"},"modified":"2010-04-22T12:15:23","modified_gmt":"2010-04-22T17:15:23","slug":"oracle-esb-customerdata-tutorial","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=1564","title":{"rendered":"Oracle ESB: CustomerData Tutorial"},"content":{"rendered":"

Setup JDev<\/h2><\/span>\n

* Install JDev 10.1.3.3<\/p>\n

Create a new Application Server connection<\/h3><\/span>\n

* Click “Connections” tab,
\n* Right click “Application Server”,
\n* Select “New Application Server Connection…”<\/p>\n

Name: LocalApplicationServer\r\nConnection Type: Oracle Application Server 10g 10.1.3\r\nUser name: oc4jadmin\r\nPass: welcome1\r\nConnect to: Single Instance\r\nHost name:  localhost   \r\nOPMN Port: 6003\r\nOC4J instance name: home<\/pre>\n
Create a new Integration Server connection<\/h3><\/span>\n
* Click “Connections” tab,
\n* Right click “Integration Server”,
\n* Select “New Integration Server Connection…”<\/p>\n
Name: LocalIntegrationServer\r\nApplication server: LocalApplicationServer\r\nHost name: localhost\r\nPort number: 8888<\/pre>\n
Unzip CustomerSample.zip<\/h2><\/span>\n
* CustomerSample.zip is in ‘OracleAS_1\\integration\\esb\\samples\\tutorials\\CustomerData’
\n* Unzip it into C:\\<\/p>\n
Create JDev Application and Project<\/h2><\/span>\n
Create a JDev Application named ‘ESBSamples’<\/h3><\/span>\n
* Click “Applications Navigator” tab,
\n* Right click “Applications”,
\n* Select “New Application…”,
\n* Enter application name,
\n* Click “OK”,
\n* Click “Cancel” on Create Project dialog.<\/p>\n
Create a JDev ESB Project named ‘CustomerData’<\/h3><\/span>\n
* Click “Applications Navigator” tab,
\n* Right click “ESBSamples”,
\n* Select “New Project…”,
\n* Select “General -> Projects -> ESB Project”,
\n* Click “OK”. <\/p>\n
Import XSD Files<\/h2><\/span>\n
* Click “CustomerData” ESB project
\n* Click “File -> Import…”
\n* Select “Web Source”, click “OK”
\n* Browse to ‘C:\\Customer\\Schemas’
\n* Select all three schema files, click ‘OK’<\/p>\n
Create an ESB System<\/h2><\/span>\n
* Click ‘Create System\/Group’ icon on the center panel.
\n– Create: System
\n– Name: CustomerData
\n* Click ‘OK’<\/p>\n
Create an Inbound File Adapter Service: CustIn<\/h2><\/span>\n
* Drag ‘Component Palette -> Adapter Services -> File Adapter’ onto ‘CustomerData.esb’ design area in the center panel.
\n* Define file adapter service:<\/p>\n
Name: CustIn\r\nSystem\/Group: CustomerData<\/pre>\n
* Click ‘Configure Adapter Service Wsdl’ icon to the right of WSDL File field.<\/p>\n
Service name: CustIn\r\nOperation type: Read File\r\nOperation name: ReadCustomerData\r\nDirectory for Incoming Files (physical path): C:\\Customer\\In\r\nInclude Files with Name Pattern: *.xml\r\nPolling frequency: 1 sec\r\nSchema location: Type Explorere -> Project Schema Files -> LegacyCustomer.xsd -> CustomerData\r\nSchema element: CustomerData<\/pre>\n
* Click ‘Finish’
\n* Click ‘OK’
\n* ‘CustIn_RS’ routing service is also created automatically.<\/p>\n
Create an Outbound Database Adapter Service: CustDBOut<\/h2><\/span>\n
Create OLite ‘CUSTOMER_DATA’ table<\/h3><\/span>\n
\r\ncd C:\\oracle\\product\\10.1.3.1\\OracleAS_1\\integration\\esb\\olite\\bin\r\nsql_olite.bat @C:\\Customer\\create_customer.sql\r\n<\/pre>\n
Create CustDBOut<\/h3><\/span>\n
* Drag ‘Component Palette -> Adapter Services -> Database Adapter’ onto ‘CustomerData.esb’ design area in the center panel.<\/p>\n
Name: CustDBOut\r\nSystem\/Group: CustomerData<\/pre>\n
* Click ‘Configure Adapter Service Wsdl’ icon to the right of WSDL File field.
\n– Service name: CustDBOut
\n– Connection: click ‘New’<\/p>\n
Connection name: Olite\r\nConnection type: Oracle Lite\r\nUser name: system\r\nPass: any\r\nDriver: Type 4 Driver\r\nLibrary: Olite40.jar\r\nClasspath: C:\\oracle\\product\\10.1.3.1\\OracleAS_1\\integration\\esb\\lib\\olite40.jar\r\nHost name: localhost\r\nJDBC port: 1531\r\nSID: OraESB<\/pre>\n
* Click ‘Test Connection’, should return Success
\n* Click ‘Finish’<\/p>\n
Connection is now: Olite\r\nUser name: system\r\nDriver: oracle.lite.poljdbc.POLJDBCDriver\r\nConnection string: jdbc:polite4@localhost:1531:OraESB\r\nJDDI name: eis\/DB\/Olite<\/pre>\n
* Operation type: Perform an operation on a table -> Insert or Update (Merge)
\n* Import Tables: SYSTEM.CUSTOMER_DATA
\n* Primary key: CUSTOMERID
\n* Click ‘Finish’
\n* Click ‘OK’<\/p>\n
Create an Outbound JMS Adapter Service: CRMOut<\/h2><\/span>\n
* Drag ‘Component Palette -> Adapter Services -> JMS Adapter’ onto ‘CustomerData.esb’ design area in the center panel.
\n* Define jms adapter service:
\n– Name: CRMOut
\n– System\/Group: CustomerData
\n* Click ‘Configure Adapter Service Wsdl’ icon to the right of WSDL File field.
\n– Service name: CRMOut
\n– OEMS: Memory\/File
\n– Connection: LocalApplicationServer
\n– Operation type: Produce Message
\n– Operation name: Product_Message
\n– Destinations: demoTopic (topic)<\/p>\n
\r\nDestination name: jms\/demoTopic\r\nJMS Connection Factory: jms\/TopicConnectionFactory\r\nMessage body type: TextMessage\r\nDelivery mode: Persistent\r\nPriority: default\r\nTimeToLive: 0\r\nJNDI name: eis\/Jms\/TopicConnectionFactory\r\n<\/pre>\n
– Schema location: browse to ‘Type Explorer -> Project Schema Files -> CommonCustomer.xsd -> Customer’
\n– Schema element: Customer
\n– Click ‘Finish’
\n* Click ‘OK’<\/p>\n
Create an Outbound Routing Service: CustOut_RS<\/h2><\/span>\n
* Drag ‘Component Palette -> ESB Services -> Routing Service’ onto ‘CustomerData.esb’ design area in the center panel.
\n* Define routing service:
\n– Name: CustOut_RS
\n– System\/Group: CustomerData
\n* Select ‘Generate WSDL from Schema’
\n– Schema location: browse to ‘Type Explorer -> Project Schema Files -> CommonCustomer.xsd -> Customer’
\n– Schema element: Customer
\n– Operation name: MapCustomerData
\n– Namespace: http:\/\/oracle.com\/esb\/namespaces\/CustomerData<\/p>\n
Specify Routing Rules for CustIn_RS and CustOut_RS<\/h2><\/span>\n
* Double click CustIn_RS<\/p>\n
Specifying Routing Rules from CustOut_RS to CustDBOut<\/h2><\/span>\n
* Double click CustOut_RS
\n* Expand Routing Rules
\n* Click ‘+’ sign to the right of MapCustomerData
\n– Select ‘ESB\/Services in project\/CustDBOut\/write’
\n* Click ‘H’ icon to the right of <>
\n– Select ‘Create New Mapper File:’
\n– Click ‘OK’
\n– Drag ‘inp1:Customer’ to ‘top:CustomerData’
\n~ Check ‘Enable Auto Map’
\n~ Check ‘Prompt for Preferences before Auto Map’
\n~ Mode: Basic
\n~ Check ‘Match Elements with Similar Names’
\n~ All others deselected. Especially, de<\/strong>select Match Elements Considering their Ancestor Names
\n* Click OK<\/p>\n
Specifying Routing Rules from CustOut_RS to CRMOut<\/h2><\/span>\n
* Double click CustOut_RS
\n* Expand Routing Rules
\n* Click ‘+’ sign to the right of MapCustomerData
\n– Select ‘ESB\/Services in Project\/CustomerData\/CRMOut, select Produce_Message’<\/p>\n
Adding an Expression Filter to the CustOut_RS Routing Service<\/h2><\/span>\n
* Double click CustOut_RS
\n* Click the filer icon for ‘CustDBOut::write’
\n* In the WSDL Message box, expand Customer_request\/Customer\/inp1:Customer\/Address
\n* Select Country.
\n* Click ‘Insert Into Expression’.
\n* Specify the country as “US”: \/inp1:Customer\/Address\/Country=’US’
\n7. Click OK.<\/p>\n
Register Services with Oracle ESB<\/h2><\/span>\n
* Right click ‘Application Navigator\/Applications\/ESBSamples\/CustomerData\/’
\n* Select ‘Register with ESB\/LocalIntegrationServer’
\n* Click OK<\/p>\n
View Services in Control Console<\/h2><\/span>\n
Running the Tutorial<\/h2><\/span>\n
* Copy ‘C:\\Customer\\LegacyCustomer.xml’ to ‘C:\\Customer\\In’ directory.
\n* ‘C:\\Customer\\In\\LegacyCustomer.xml’ disappears.
\n* Query OLite<\/p>\n
\r\n...OracleAS_1\\integration\\esb\\olite\\bin>msql.exe system\/any@jdbc:polite4@127.0.0.1:1531:oraesb\r\n\r\nSQL> select customerid,name,country from customer_data;\r\nCUSTOMERID | NAME                  | COUNTRY\r\n-----------+-----------------------+--------\r\nA22-9AXC2  | Deserae International | US\r\n\r\n1 row(s) returned<\/pre>\n
References<\/h2><\/span>\n
* http:\/\/download.oracle.com\/docs\/cd\/B31017_01\/integrate.1013\/b28212.pdf<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Setup JDev * Install JDev 10.1.3.3 Create a new Application Server connection * Click “Connections” tab, * Right click “Application Server”, * Select “New Application Server Connection…” Name: LocalApplicationServer Connection Type: Oracle Application Server 10g 10.1.3 User name: oc4jadmin Pass: … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[48,35],"tags":[],"class_list":["post-1564","post","type-post","status-publish","format-standard","hentry","category-esb","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-pe","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1564"}],"version-history":[{"count":2,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1564\/revisions"}],"predecessor-version":[{"id":1566,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1564\/revisions\/1566"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}