Microsoft Azure SQL
Integrating with an Azure SQL database is easy, using the SQL data provider in provides access to interact with external data efficiently. For more information on how the the provider functions, see Microsoft Azure SQL.
In this section, an SQL database is used to create a customer app that allows you to:
Functions & Jigs | Functionality description |
|---|---|
View a list of customers. | |
View a single customer. | |
Capture new customers in a form. | |
You can update customer details by tapping the Edit customer button. This populates a form with the customer's details and an update button. |
We have simplified the process by providing database scripts to create the Customer SQL database on which the example is based.
The SQL data provider is used in to integrate with an Azure SQL database. In this section, we follow these high-level steps:
- Identify the SQL database to be used as your data source.
- Configure SQL connection in .
- Define a SQL call in a function in .
- Define data operations in the function, such as SELECT, INSERT, UPDATE, and DELETE. For each operation, create a new function to specify the operation.
- Reference the Jigx functions in s.
- Publish your solution
- Test the data provider.
