Create a DataWindow Using an OData Service

To select the OData Service datasource in the DataWindow wizard:

  1. Select File > New from the menu bar and select DataWindow.

  2. If there is more than one target, select the target where you want the DataWindow to be created from the drop-down list.

  3. Choose the presentation style for the DataWindow object and click Next.

  4. Select the OData Service datasource and click Next.

  5. Select the OData profile and click Next.

  6. In the SQL painter.

    • You can select one table.

    • The Sort, Group, and Having tabs are not available.

    • The Results tab is obsolete, because it is used by PowerBuilder .NET.

    • In the Where tab you can specify some selection criteria using the WHERE clause for the SELECT statement.

    When you complete the query, click OK.

  7. Review your specifications and click Finish.

At runtime, the DataWindow or DataStore can manipulate OData service data, which includes retrieving, updating, inserting, and deleting the data.