Data Source - From Data Table of Other Application

Overview

Data sources from other applications associate with a table from another application and only support query operations. When building large systems, we need to split the large system into multiple subsystems, and subsystems are split into modules, with dependencies formed between different subsystems. The following is a structural diagram of an integrated management system for the manufacturing industry:

In the above example, the personnel management system is the basic system, and other systems need to use data from the personnel management system. In this case, API calls are generally used to obtain data. To simplify this type of data access, Informat allows you to set the data source type of a data table to From Data Table of Other Application. The system will build a virtual table in this application, and when other data tables in this application access or associate this virtual table, Informat will automatically convert it to access the target data table of the target application.

TIP

Only when the data source is Default or From Data Table of Other Application can this table be associated with other tables. Other types of data sources do not store data in Informat but retrieve data in real-time during queries.