Setting Up Integration with Table Data Sources

The mobile platform supports working with the table data sources: SAP, Postgres Pro/PostgreSQL, 1C, Oracle, SQL Server, SOAP/XML, table JSON service.

To integrate mobile platform server with a data source:

  1. Create a basic stored procedure on the data source side.

  2. Connect a data source to mobile platform server.

  3. Import resource structure.

  4. Set up default values for resource input parameters.

NOTE. Before the setup see the notion of a table resource and required conditions for input parameters.

After executing the operations the mobile platform server can execute API requests to get and cache source data.

Table Resource

Table Resource is a resource in the mobile platform that returns data as a table on working with a data source.

The data types available for table resource:

To select the limited data set, the table resource must contain input parameters, with which it addresses the basic stored procedure in the data source.

When setting input parameters make sure that the conditions are satisfied:

Basic Stored Procedure

The mobile platform server interacts with table data source only via calling a basic stored procedure.

Basic stored procedure is a set of instructions that is developed and executed on the data source side.

Interaction between mobile platform server and data source via stored procedure:

  1. The mobile platform server sends input parameters to the procedure.

  2. The procedure executes the specified instructions and processes the request.

  3. The mobile platform server gets corresponding data from the source in the response to procedure request.

When developing a basic stored procedure make sure that the conditions are satisfied:

A basic CRUD procedure is available for all table data sources that can take and change data for one iteration.

Requirements to types of input parameters and the use of basic procedures are given for each table data source:

See also:

Basic CRUD Procedure | Basic SAP Procedure | Basic Postgres Procedure | Basic 1C Procedure | Basic Oracle Procedure | Basic SQL Server Procedure | Basic SOAP/XML Procedure | Table JSON Service