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 a mobile platform server with a data source:

Create a basic stored procedure on the data source side.
Connect a data source to a mobile platform server.
Import resource structure.
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 a 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:

Scalar. Simple data type, for example, integer, text.
Table. Table from named scalar type columns.

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:

Table resource contains a custom number of parameters, including zero.
Table resource parameter has name.
Table resource parameter is scalar or table.
The table consists of named columns of scalar types.
Types and names of table resource parameter set are not changed after creating a resource.

Basic Stored Procedure

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

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

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

A mobile platform server sends input parameters to the procedure.
The procedure executes the specified instructions and processes the request.
A 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:

It takes zero or more input parameters.
All input parameters have name.
Type of input parameter is basic scalar or basic table.

One or more returned values of basic table type.
Types of input and output parameters are set during procedure creation and do not change during execution.

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: