What you will need:



Trial version of Sonic ESB work bench (registration required) http://web.progress.com/en/Product-Ca ... terprise-service-bus.html

• An free account registered with PublicIPMonitor http://www.publicipmonitor.com/

• Oracle Express Database free addition (registration required): http://www.oracle.com/technology/soft ... ts/database/xe/index.html





In order to download Sonic ESB Work bench you will need to register a valid email account in order to receive your free trial license key.



PUBLICIPMONITOR

In this tutorial part 1: we are going to connect to a web services provided by PublicIPMonitor and update an Oracle database with the change in IP. The next tutorials Part 2 we will also create a Sonic service to connect to Oracle Database and show the information received by the message bus.









Install Sonic Work Bench



a. In Vista perform the following to avoid permission errors:

From the Run option









b. Enter: msconfig









c. Click OK

d. Select the Tools Tab and select Disable UAC from the List and Click Launch







e. Click OK









f. You can now execute the downloaded Sonic Work Bench trial

g. Once the installation has been completed go back to the

system configuration and turn back on UAC









h. Click Launch to complete







i. That is it all done

2. Install Sonic Work Bench 7.6 trial (692 MB)

3. Check your email for your trial license key you will need this on the install

With UAC turned off change directory to where you downloaded the Sonic Work Bench (XP users do not need to turn off UAC as this is for Vista only)



Install Sonic Work Bench:









4. Double Click or open to install









5. On Vista Select Run

6. Extract to a folder you will remember for later









7. Click Unzip









8. After completed change directory to the temp extracted files and click Close







9. Change directory to the extracted files. I extracted to: C:UsersdavidAppDataLocalTempSonicWorkbench7.6









10. Double click or Open setup.bat to begin installation









11. Wait for Installer to load. You will need the trial license key to continue



12. If you get this message re-boot your computer: (Vista)









13. Select setup.bat and run as Administrator:









14. Click Next







15. Click Next







16. Click Next







17. Click Next







18. Click Accept agreement (don’t forget to read it first)







19. Enter your license key and click next







20. I use the default of C:sonic click Next







21. Click Yes







22. Click Next







23. Click Next







24. Wait for the next button to appear







25. Check to install documentation and click next







26. Click Next all done.

27. Turn UAC back-on for Vista and re-boot







Running Sonic Work Bench



1. Always start the domain manager first before loading the Work Bench, you can start the domain from the work bench if you prefer to avoid any errors I recommend you start domain manager first.

2. To start Domain Manager:

[/size]





3. Start ==> Progress ==> Sonic 7.6 ==> Start Domain Manager (Vista run as Administrator)









4. On startup Sonic will build the registry etc

5. Next Start the Work Bench:







6. Start ==> Progress ==> Sonic 7.6 ==> Workbench (run as administrator Vista)







7. Leave this open for now:







Configure PublicIPMonitor





Now we need to setup a test account for this project. We will use Public IP monitor to connect to using Sonic ESB with a web service configuration:



1. Register for a free account at: http://www.publicipmonitor.com/

2. Download the PublicIPMonitor utility and install (Vista users turn off UAC before installing)

3. Select Register from Top Right Hand Corner:







4. Fill out the information required by aware use a valid email address as the updates will be sent to the entered email.

5. When completed Select Login with your credential and create your link for the ip update







6. Click on Download to install the PublicIP Service







7. Click on Add and create a test ip GUID

8. Copy the GUID created to the application service installed on your PC







9. Click save and you can now check for updates in your account. (Do not use the above as this is not a valid GUID just a test)

10. You are now ready to test



Building Sonic Services



1. From the Work bench: File ==> New ==> Sonic Development Project







2. Name this PublicIPMonitor:







3. Click Next







4. Leave default and click Finish







5. As per above the project Skelton

6. Create folders:







a. Processes

b. Database

c. XSLT

d. WebServices

e. XML (for our input/output files)





1. First we are going to create our process right click on the folder Processes: New ==> ESB Processes







2. Set Name as PublicIPProcess and click Next







3. Leave as default







4. Click Finish and a dummy service will be created







5. We are now going to create a Web Service call-out to send/retrieve the information from PublicIPMonitor. Delete the Service 1 (Click and Delete Key)

6. Drag Web Services component onto the Process:







7. From the right hand Palette Click Web Service and drag onto the process







8. Change the name to PublicIPMonitorWS (or whatever you like)

9. Double click on the service PublicIPMonitorWS







10. Now we need to configure a few items.







11. Check Inline and Click on the link Web Service Invocation







12. In the WSDL enter:

and click refresh button this will load all the requirements for the WSDL.





13. As you can see from above the WSDL has been looked at by the ESB and loaded the parameters for you.

14. Next we need to create an input XML file that will match the parameter IPCheck

Before we do this make sure your Public IP Monitor is running:.







15. Click on Public IP Monitor

16. In the Test Value enter your GUID. Make sure you have installer PublicIPMonitor service :







17. Ensure the correct GUID is entered and click save and then close







18. Click on Check for Public IP Updates ( if the service is not running click Start)



1. Now we will create an XML input file for testing, Right click folder XML then File ==> New ==> XML







2. Add the name as PublicIPInput.XML







3. Click Next







4. Here we can add the WSDL again and pick the option from the WSDL:







5. Hit enter key after the ?wsdl to refresh DO NOT Click Finish







6. I have checked off Types to avoid confusion leave Elements checked, as you can see the first two are what we are interested in.







7. Select IPCheck and then click Next









8. Click finished to build input file for testing

9. Next we need to edit two parameters

a. org:monitored

b. org:currentIP



10. Next we need to add the correct information, add your PublicIPMonitor GUID:







11. I entered a default IP for current IP which will work fine for this test.



12. We can now test this invocation by creating a Scenario Click on the process Tab (Top)









13. Next we will create a Scenario:









14. Click on the Scenario Tab in the center window bottom left and click on the



Icon









15. You can leave the name as it is we will need to add our input XML file







16. Click on the Eclipse button or drag the file into the Test Value







17. I drag easier that way

18. Click on the Run Button to test the web service:

19. Click Save at this point





20. Click Yes







21. If you look at the bottom tab (center) you can view the reply message, on the right click the max button so we can view the reply message.







22. This is what you should see:







23. Click on the Part message and you will see the results in the tag









That is it for part 1 you have now successfully connected to a Web Service and got a response using Sonic ESB.

Part 2 we will create a service to write this to an Oracle Express (free Download) Database