Data Providers

Microsoft Azure SQL

3min

﻿
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﻿.
What is created
In this section, an SQL database is used to create a customer 
﻿ app that allows you to:
Functions & Jigs
Functionality description
﻿List customers (SELECT)﻿﻿
View a list of customers.
﻿List a single customer (SELECT)﻿﻿
View a single customer.
﻿Create a customer (INSERT)﻿﻿
Capture new customers in a form.
﻿Update a customer (UPDATE)﻿﻿
You can update customer details by tapping the Edit customer button. This populates a form with the customer's details and an update button.
Before you begin
We have simplified the process by providing database scripts﻿ to create the Customer SQL database on which the example is based. 
High-level steps
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.
﻿

Updated 22 May 2024

Did this page help you?

Deleting Dynamic Data

Database Scripts

Docs powered by Archbee

TABLE OF CONTENTS

What is created

Before you begin

High-level steps

Functions & Jigs	Functionality description
List customers (SELECT)	View a list of customers.
List a single customer (SELECT)	View a single customer.
Create a customer (INSERT)	Capture new customers in a form.
Update a customer (UPDATE)	You can update customer details by tapping the Edit customer button. This populates a form with the customer's details and an update button.