Connecting Data Sources

A data source is any external system that provides data for mobile users. Each data source contains resources that are a limited set of data in the source. To correctly address data source resources, set up a connection to appropriate data source object. For example, a stored DBMS procedure, SAP RFC module.

The mobile platform supports the data sources: SAP, Postgres Pro/PostgreSQL, Oracle, Microsoft SQL Server, 1C, SOAP, JSON, Microsoft Exchange Server, WEB services, Foresight Web, Foresight, Local Database, file resources, local database, and sending transaction data.

NOTE. Connecting to file resources is available only in the Files subsection.

If required, one can connect any data source using a universal connector that is used as a mediator between a mobile platform server and a data source. If output data structure differs from JSON format structure, or data format is proprietary, the connector converts data into a valid format and allows for exchanging requests between a mobile platform server and a data source to execute operations with data.

To manage data sources, use the Data Sources section in the selected project:

The working area displays a list of connected data sources in the project.

To add a data source:

  1. Select the required data source in the drop-down menu of the Add Data Source button.

  2. Set up data source connection.

  3. Add data source credentials.

  4. Import data source resources or create new ones. Resources can be created for the Postgres Pro/PostgreSQL and Local Database data sources.

NOTE. Resources cannot be imported for the Local Database data source.

  1. Set schedule to synchronize resources structure.

After executing the operations the connected data source is added to the list and can be further used in the project.

To integrate with table data sources, use calling of basic stored procedures.

Edit data source

Delete data source

For details about data source requests, see the Method for Working with Table Resources section.

See also:

Setting Up Environments and Projects | Setting Up Integration with Table Data Sources