JavaScript is disabled on your browser.

Foreign Data Group - General Properties

Enter the Title for the new foreign data group. Select the appropriate data handler for the connection from the Datahandler selection list. In the Database connection selection list, the desired connection can be selected.

You can enter the name of the Table and/or View directly or find it via Search.

In the list Owner of the data record a data field that contains the ID of the owner of the data record can be selected.

Exchange - Foreign Data Group

In the lower area of the dialog, a user can now be defined for access to Exchange. With the option to Login as current user, the currently logged-in user will be used for access to Exchange. With the option to Login as static user, the link to Select user will be activated. Clicking on this link opens a dialog that allows users from the data source configuration that have been created and assigned to Exchange users to be selected.

OData - Foreign Data Access

The required connection can be selected from the selection list Database connection. The appropriate data handler for an OData database connection will automatically be entered in the selection list Datahandler. You can enter the name of the Table or View, or click on Search to locate it.

At the bottom, the type of application is defined. With the option Login as current user when the page, on which the OData connection is integrated, is called, the login credentials of the current portal user will be requested.

With the option Login as static user a registered OData User can be used to login. Click on the link to Select user.

The login details of the static user are now registered. The required data fields, which are to be provided by the OData Service, can now be selected on the Data fields tab, and associated with the elements in the Intrexx application.

1:n Relationships

Relationships of type 1:n between OData data groups are represented with parent data groups (e.g. Flights) and subordinate child data groups (e.g. Bookings) in Intrexx. If you establish the database connection in the properties of the child data group, and select the corresponding OData Collection (Table), then the potential 1:n relationships will be made available for selection.

In the next step, the data fields for the child data group can be selected. It will then be possible to display dependent records from child data sets in view tables on view and input pages of the parent data groups.

m:n Relationships

The Velocity Callable ODataLinksCallable can be used to create and remove m:n relationships between two OData foreign data groups.

Creation of an m:n Relationship

$ODataLinksCallable.createLink(<Configuration GUID>, <Service GUID>, <Impersonation GUID>, <Source DG GUID>, <Source_Record_ID>, <Target Navigation Property>, <Target DG GUID>, <Target_Record_ID>)

Removal of an m:n Relationship

$ODataLinksCallable.deleteLink(<Configuration GUID>, <Service GUID>, <Impersonation GUID>, <Source DG GUID>, <Source_Record_ID>, <Target Navigation Property>, <Target DG GUID>, <Target_Record_ID>)

The following parameters are required: