Connector for Connector API - Integration into Applications

Set Up External Data Access

A Connector API connection can be used in any Intrexx application. You can configure the connection in the "Integration" module. You can find all the information here.

Once the connection is configured, open the desired application and then select the application node. Create a new external data group using the main menu "New / External Data Group" or the corresponding context menu.

The dialog box for configuring the external data group opens automatically.

Enter the name of the new external data group. You can find information about multilingual titles here.

Select the Connector API database connection. In the "Data Handler" drop-down list, the corresponding data handler is automatically selected.

You can enter the name of the desired table directly or find it by clicking "Search" at .

Search Tables / Views

Click "OK" to save your selection and close the dialog box.

In "Record Owner," you can select a data field that contains the ID of the record's owner.

Select Data Fields

The data fields provided by the Connector API connection can then be selected on the "Data Fields" tab and linked to elements in the application.

Click "Add" here at to select the fields you want.

In the first column, primary key fields are marked with a symbol , and foreign key fields are marked with a symbol .

Here you will find the titles, names, and data types of the data fields. Intrexx recognizes the data types of external data fields and automatically assigns the appropriate Intrexx data type.

The "External Data Type" column displays the data type used in the external data source for the currently selected data field.

Primary Key

Defines 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.

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.

External data groups are identified in the application structure by their own " " icon. The data fields in an external data group can be displayed using the main menu option "Edit / Show Data Fields" and linked to input or view elements.

Next Steps

The external data group for the Connector API connection is now fully configured. To use the data from the external data group in the application, you can now create application elements and link them to the external data fields—for example, on a page in the external data group or in a view table.