In an Intrexx portal, data records from external data, e.g. from an external CRM or ERP, can be combined and displayed together with Intrexx data. This article shows you how to combine customer data from an external data source with types A, B, or C, which come from an Intrexx data group.
Configure the connection to the external data source
A connection to the OData Northwind service is used as the external data source. The connection can be easily established with the URL "https://services.odata.org/V2/Northwind/Northwind.svc/". You can find out how to configure an OData connection here.
Configure the external data group in an application
You can find out how to create an external data group here. Select your Northwind connection in the database connection field. The "Customers.Customer" table can then be searched for and selected. It provides sample customer data.
Then switch to the "Data fields" tab and add all available data fields by clicking on 
"Add".
The Intrexx data group
An Intrexx data group with an input page already exists when an application is created with the "Basic application" template. An input field for the type with which a customer can be classified has been created here on the input page. You can find out how to create elements here.
There is also a selection list that obtains its entries from the external data group "Customers". The saved value is the primary key - the customer number - from the external data group (PK) CustomerID). The customer number and the company name should be displayed in the drop-down list so that it is easier to read in the browser.
The customer number is saved together with the type in the data field "Customer" in the Intrexx data group.
Display Intrexx data and external data together
On the "All entries" page, the assembled data record can now be displayed in a view table, for example. For this purpose, the data fields "Customer" and "Type" from the Intrexx data group are added as table columns. The "Customer" table column has the "Dynamic view" control type.
By clicking on 
"Display value", you can set which data from the external data group is to be displayed in which order in the table.
Application in the browser
On the edit page, a customer can now be selected and a type entered in the browser. The assembled data set is displayed in the view table on the "All entries" page.
Send us an e-mail