External Data Group
Intrexx connectors can be used to establish connections to data from external sources. These connections can then be integrated into any application.
For most connectors, this requires a custom data group in which the corresponding connection can be selected and configured, and the desired data fields can be added.
Properties - External Data Group - General
An external data group can be created using the application node. Select the main menu option "New / External Data Group" or the corresponding context menu. The Properties dialog box for the external data group will then open automatically.
External data groups are identified in the application structure by their own " 
" icon. You can open the Properties dialog box for an existing external data group in the application structure by double-clicking it. The available settings vary depending on the selected database connection.
Title
Enter the title of the external data group here. You can find information about multilingual titles here.
Database Connection
You can select the desired connection here.
Data Handler
Select the data handler for the connection here.
Table / View
You can enter the name of the table or view directly here.
Search
Opens a dialog box where you can search for tables and views.
Search Tables / Views
Show tables for the current schema only
With this setting, the list of tables is restricted to the current schema.
Filter
Enter the table or view you are looking for here. The * character serves as a placeholder for any character. A* finds all tables and views whose names begin with A. *A* returns all tables whose names contain the letter A.
Search
Clicking this button activates the filter.
Tables / Views
All search results are listed in this section. Select the table or view you are looking for here.
Click "OK" to save your changes and close the dialog box.
Owner of the data set
Here, you can select a data field that specifies the ID of a record's owner.
Exchange External Data Group
You can find a description of the settings in the upper section here.
Log in as a current user
This option uses the currently logged-in user to access Exchange.
Log in as a static user
This option allows you to select Intrexx users who have already been created and assigned to Exchange users from the Exchange data source configuration. The user data is then displayed in the lower section of the dialog box.
Select a user
Opens a dialog box where you can select the static user.
OData External Data Group
You can find a description of the settings in the upper section here.
Log in as a current user
With this option, the current portal user's login credentials are requested when the page containing the OData connection is loaded.
Log in as a static user
By clicking "Select User" under the "Log in as a static user" option, you can select Intrexx users that have already been created and are assigned to OData or SAP Gateway users from the current OData/SAP Gateway connection.
Additional users for service access can be used, for example, in processes where access to the OData service or the SAP system must always be performed under a specific user, regardless of the user currently logged in to Intrexx.
Click " 
" "Add a new additional user to the OData/SAP gateway configuration" to select a user.
Login from User Configuration
A schema attribute from the "Users" module can be specified here. The GUID of the static user is then stored in the attribute for each user. This allows different static logins to be used for the target system, depending on the Intrexx user.
You can find all additional information about integrating OData into applications here.
Data Fields
On the "Data Fields" tab in the properties of the external data group, you will find all the data fields that are available in the corresponding connection to the external data.
For data fields defined as primary keys ( 
) or foreign keys ( 
), you'll see a corresponding icon to the left of the name. If a primary key exists in an external data table, Intrexx automatically identifies and marks it. The primary key of an external data source is treated as a string in Intrexx.
"Data Type" column
Displays the data type used in Intrexx for the currently selected data field. Intrexx recognizes the data types of external data fields and automatically maps them to the appropriate Intrexx data types.
"External Data Type" Column
Displays the data type used in the external data source for the currently selected data field.
Add
Opens a dialog box where you can select the fields from the external data source.
Select a data field
When you select data fields here, you should always select a primary key as well. Be sure to use a data field with unique values. The primary key of an external data source is treated as a string in Intrexx.
Click "OK" to save your changes and close the dialog box.
Primary Key
Clicking this button to the left of the list designates the currently selected data field as the primary key field. A primary key should always be selected. Be sure to use data fields with unique values.
Foreign Key
Defines the currently selected data field as a foreign key field. The field used as a foreign key must contain a value that uniquely identifies a parent record, such as a customer number.
Remove
Removes the selected data field from the list. If this is still in use within the application, a corresponding message will be displayed. In this case, the data field is not removed from the list.
Edit
Opens a dialog box where you can change the title and name of the data field.
Select Primary Key in Child Data Group
This dialog box appears when the parent foreign data group has more than one primary key and you want to define a foreign key in the "Data Fields" tab of the child foreign data group's properties.
In this case, the mapping used to identify the dependent records in the child external data group cannot be determined automatically.
Therefore, select here the primary key of the parent external data group against which the foreign key of the child external data group is to be compared.
More Information