PBTV: Creating and Consuming Web Services Based on SQL Queries in PowerBuilder

Tuesday Oct 30th 2012 at 10:00 AM PST (Los Angeles) – 18h00 CET (Paris)

Unlike direct connections to the database, Web services can be managed and secured outside of an application and used by any Website or client/server, Web, or mobile application. A PowerBuilder application then can use Web services to return data sets as data sources of the application’s DataWindows. This facilitates the incorporation of PowerBuilder applications and Web services into a cloud computing environment.

This session explains and demonstrates how to:

• Build a data store based on a chosen query and structure that can be used for constructing Web service output.
• Create a class (NVO) as a wrapper of a Web service with the necessary “Get_…()” functions that populate arrays of structures from respective data store(s).
• Deploy a created Web service to an IIS Web server including the creation of a WSDL file.
• Create a DataWindow with a Web service as a data source.
• Choose a proper Web service and find its desired method (“Get_…()” function).
• Select a proper parameter from the chosen Web service method and finalize the created DataWindow to solve hidden problems with the string data type.

Presenter: George Mikhailovsky

Register: https://www2.gotomeeting.com/register/779151770