Configuring the SQL Connection

best practice for production apps is to use rest as the data layer to access data and not directly integrate to sql using the sql data provider the sql data provider will be squiggled in blue to indicate it is not recommended, together with a message to use rest docid\ jrbansm ojn3nf4 dn hu instead see rest endpoints from azure sql docid\ eoui2cpyynsdruk tobdp for more information jigx will route all calls to azure sql server from a jigx mobile app through the jigx cloud no data is stored or cached in jigx cloud the encrypted sql connection information is stored in non user readable secure storage in jigx cloud and allows for ip allowlisting for azure sql database servers to complete these steps, the user will need jigx credentials with admin privileges for the solution being configured and azure sql administrative credentials to configure the allowlisted ip addresses for the azure sql server being used in the {{jigx}} solution following these steps to configure a new azure sql connection for the solution in {{jigx}} cloud before adding the jigx cloud ip addresses to the allowlisted ip addresses in azure sql creating an azure sql connection in jigx cloud sign in to jigx management at https //manage jigx com and navigate to the solution being configured click on the connections menu option on the left of the solution screen 3\ click add connection on the top right of the connections screen 4\ enter the connection information for the new azure sql connection in the name field, enter your server's name, which will be the connection name {{jigx}} functions will refer to when you create sql functions we recommend that this be the same as your sql instance, for example, jigx1 database windows net in type – select azure sql for both azure sql and on premise sql servers optionally enter any descriptive text in the description field in server enter the name of azure sql or sql on premise database server the azure administrator or database administrator will assist with this name in database enter the name of the sql server database you want to connect to in user enter the user name that will connect to sql server in password enter a valid password for the sql server in options configure other connection options such as non standard ports or other specific connection information that the database server may need 5\ before saving or testing the connection, click the ip allowlist link in the middle of the new connection screen note the two ip addresses listed the calls from jigx cloud to azure sql will always originate from one of these ip addresses these ip addresses will be added to the azure sql server these ip addresses will vary depending on the jigx cloud region being used 6\ navigate to the administrative portal for the azure sql server instance hosting the database used in the jigx solution under the security section, select networking please refer to azure sql firewall connection documentation for detailed instructions 7\ add the two jigx ip addresses to the ip addresses allowlist for this azure sql instance adding ip addresses 8\ in {{jigxmanagement}} , click test connection if all the settings are configured correctly, the connection will succeed click save 9\ the connection can now be used in your {{jigx}} project to execute sql queries or stored procedures to read and write data to azure sql