OData Support

PowerBuilder Classic and PowerBuilder .NET can use OData datasources.

Database Profile

Define a database profile to access an OData service in PowerBuilder using the OData interface.

Database Painter

You can connect to the OData service and work with in the Database painter.

  • Define an OData datasource with the database profile painter

  • Connect to an OData datasource in the Objects view

  • Add tables to the Object Layout view with drag-and-drop or the context menu

  • Display table and column properties in the Properties view with drag-and-drop or the context menu

  • Drag-and-drop a table onto the Columns View

  • Invoke the Edit Data feature in the Results view of the Database Painter

Since OData is not a SQL source, some features are not supported:

  • The ISQL session view is not enabled

  • You cannot create, modify or delete tables

  • You cannot create users or group of users

  • You cannot embed SQL statements in powerscript

Create a DataWindow Using an OData Service

Select the OData Service datasource in the DataWindow wizard.

Set the Connection Information for the OData Service

Use the SQLCA Transaction object (or user-defined transaction object) to retrieve and display data from the OData service in a DataWindow or Datastore.