Create external data group
A connection to an SAP Gateway data source can be used in any Intrexx application. Find out how and where you can create and configure a connection here.
To integrate the connection into an application, select the application node and create a new external data group via the main menu "New / External data group".
Define the title of the new external data group and then select the desired OData database connection. A suitable data handler is then entered automatically.
You can enter the name of the desired table or view it directly, or click on 
"Search" and search for the table or view name in the following dialog.
Further information on configuration can be found here.
Files
Binary data fields
OData data fields of type "Edm.Binary (BLOB)" are handled in Intrexx as the File data type. This allows binary data to be saved in Intrexx file fields. As it is not possible to automatically determine the file type from OData binary fields, the file type can be stored in the Expert settings for the data field.
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 an URL that can be inserted into a download link on a view or edit page:
<a target="_blank" href="$ODataMediaResourceCallable.getDownloadURIForBinaryProperty($ProcessingContext, $DC.getRecId(), '<GUID_DATENGRUPPE>', '<BINARY_PROPERTY NAME>', '<FILE_NAME>','CONTENT_TYPE', '<DISPOSITION_TYPE>')">Download File</a>
With this method, it is possible to define the file name and content type dynamically by detecting these values from other fields.
Email us