Skip to Content
Author's profile photo Former Member

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


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.