The appropriate data handler is entered automatically when you select
an SAP Gateway connection.
You can enter the name of the table or view directly or click on
"Search" and search for
name of the table or view in the
that opens. Click on "OK" once you have selected your table view.
for more information about the settings for logging in.
The data fields, which should be provided by the OData service and
displays in applications, can now be selected on the
Data fields tab
and then linked to
OData data fields of type Edm.Binary (BLOB) are handled in Intrexx as
the File data type. This allows binary data to be stored in Intrexx file
Since the file type cannot be
automatically detected from the OData binary fields, it must be saved in the
expert settings for the
This will automatically be used as the filename extension when the binary
data is saved. Currently, only one file type per field can be defined for
all data records. For accessing and manipulating files, OData (Version
2.0 or higher) offers Media Link Entries. These are the recommended method for
accessing binary data.
Another possibility to enable downloading of the contents of binary
fields uses the callable method "$OdataMediaResourceCallable.getDownloadURIForBinaryProperty()".
This generates a URL, which can be inserted in a download link on an entry or view page:
In addition to access to Entity Collections (tables), OData also provides
the ability to define what are known as Function Imports and to run them
via the service. Function imports are comparable to stored procedures in
database management systems, and can receive input parameters and return a
single record or a set of records as the result. Since Intrexx does not
offer direct support for stored procedures, the following procedure must
be used to call function imports:
By using the service metadata, determine the name of the function
to be called(such as with "GetProductsWithRating"), the required
input parameters, whether the results consist of a single record
(OData entry) or a result set (OData entity set), and the entity
type (table in the Intrexx data group) of the results.
Create a view page for the parameters of the function and a
further view page to view the results of the function call.