Foreign Data

With Intrexx , you can directly access data sets of various origins. This foreign data will be shown in Intrexx applications in the portal. If the connection to the foreign data source has been set up, all foreign data fields can be connected with edit and view fields in the module Applications as usual.

Under certain circumstances, a function in the module Applications will not be supported by a foreign data source. United Planet can offer only limited support for foreign data access. System environments, the configuration of the data source, the technical configuration of the database on which the foreign data source is set up, the basic database drivers, and data types can vary greatly. However, you can assume unlimited functionality on the Intrexx supported data sources SQL Server, Oracle 9, Oracle 10, SAP DB, PostgreSQL, and Derby.

Configuring the Connection

The connection to an external data source will be set up in the Integration module with the Data Sources function.

Highlight the Datasources entry in the left-hand area of the module Integration. In every newly created portal, one connection will already have been entered. This is the connection to the system database of the currently open portal. A new connection can be set up now via the menu item Data Sources / New Data Source or by selecting New Data Source from the context menu.

Foreign Data in the module Applications Foreign data groups will be entered under the application node.