External data group - General properties

Applications module External data group Properties

1. Standard external data group

Title

Enter a name for the external data group here. Click here for more information about defining titles.

Database connection

The desired connection can be selected here.

Data handler

The desired data handler for the connection can be selected here.

Table / View

You can enter the name of the table or view directly here.

Search
Opens a dialog where you can search for tables and views.

Owner of the data set

In this list, a data field that contains the ID of the owner of the data set can be selected.

2. Exchange external data group


Title

Enter a name for the external data group here. Click here for more information about defining titles.

Database connection

The desired connection can be selected here.

Data handler

The desired data handler for the connection can be selected here.

Table / View

You can enter the name of the table or view directly here.

Search
Opens a dialog where you can search for tables and views.

Owner of the data set

In this list, a data field that contains the ID of the owner of the data set can be selected.

Login as current user

With this option, the currently logged-in user will be used for accessing Exchange.

Login as static user

With this option, Exchange users, which have already been created and had Intrexx users assigned to them, can be selected from the Exchange data source configuration. The user data is then shown in the lower area of the dialog.

Select user

Opens a dialog where the static user can be selected.

3. OData external data group


Title

Enter a name for the external data group here. Click here for more information about defining titles.

Database connection

The desired connection can be selected here.

Data handler

The desired data handler for the connection can be selected here.

Table / View

You can enter the name of the table or view directly here.

Search
Opens a dialog where you can search for tables and views.

Owner of the data set

In this list, a data field that contains the ID of the owner of the data set can be selected.

Login as current user

With this option, the login details of the currently logged-in portal user will be retrieved when the page, where the OData connection is integrated, is loaded.

Login as static user

With this option, OData/SAP Gateway users, which have already been created and had Intrexx users assigned to them, can be selected from the OData/SAP Gateway data source configuration. The user data is then shown in the lower area of the dialog.

Select user

Opens a dialog where the static user can be selected.

1:n relationships

1:n relationships 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 edit pages from the parent data groups.

m:n relationships

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

Creating 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>)
Removing 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:

4. Microsoft Office 365 external data group


Title

Enter a name for the external data group here. Click here for more information about defining titles.

Database connection

The desired connection can be selected here.

Data handler

The corresponding data handler is entered automatically as soon as you select the database connection.

Table / View

You can enter the name of the table or view directly here.

Search
Opens a dialog where you can search for tables and views.

Owner of the data set

In this list, a data field that contains the ID of the owner of the data set can be selected.

MS Office365 folder

Folder

Select the desired folder.



When a folder is selected here, its data is automatically entered as expert settings.