External data group - General properties

Standard external data group

Title

Enter the title of the external data group. Click here for more information about this topic.

Database connection

The desired connection can be selected here.

Datahandler

The desired datahandler 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 record

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

Exchange external data group

Title

Enter the title of the external data group. Click here for more information about this topic.

Database connection

The desired connection can be selected here.

Datahandler

The desired datahandler 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 record

In this list, a data field that contains the ID of the owner of the data record 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.

Search for user

Opens a dialog where a static user can be selected.

OData external data group

Title

Enter the title of the external data group. Click here for more information about this topic.

Database connection

The desired connection can be selected here.

Datahandler

The desired datahandler 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 record

In this list, a data field that contains the ID of the owner of the data record 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.

Search for user

Opens a dialog where a static user can be selected.

Login by user configuration

Here a schema attribute of the user management of the portal can be used. For each user the GUID of the static user will be saved in the attribute. That way different static logins per Intrexx user can be used for the target system.

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 set up the database connection in the properties of the child data group and select the corresponding OData collection (table), the possible 1:n relationships are then offered for selection. In the next step, the data fields for the child data group can be selected. On view and edit pages of the parent data groups, there is then the possibility to show dependent data records from child data groups in view tables.

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:

  • Configuration GUID

    GUID of the OData configuration

  • Service GUID

    GUID of the OData service.

  • Impersonation GUID

    The GUID of an impersonation user, or “null” for the current user

  • Source DG GUID

    GUID of the source data group.

  • Source Record ID

    ID of the source data record.

  • Target Navigation Property

    The name of the OData Navigation Property that defines the relationship

  • Target DG GUID

    GUID of the target data group.

  • Target Record ID

    ID of the target data record.

Microsoft Office 365 external data group

Title

Enter the title of the external data group. Click here for more information about this topic.

Database connection

The desired connection can be selected here.

Datahandler

The corresponding datahandler 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 record

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

MS Office 365 folder

Folder

Select the desired folder.

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