SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. 

AppiWorks is an application integration and automation platform. It can create a connection to the SQL server in the AppiWorks platform and use it in any sub-products such as Blooms, Forms, Flows, and client platforms such as AppiWorks for Zoho CRM, AppiWorks for Google Forms, AppiWorks Looker Studio Connector, etc.

Before setting up the SQL Server connection in the AppiWorks platform, one must configure the SQL Server in any of the cloud providers such as GCP, AWS, etc. (can be any other providers), you can visit the following links for your reference

GCP - https://cloud.google.com/sql/docs/sqlserver/create-manage-databases

AWS - https://aws.amazon.com/getting-started/hands-on/create-microsoft-sql-db

Azure - https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart?view=azuresql&viewFallbackFrom=azuresql-vm&tabs=azure-portal#create-a-single-database

***IMPORTANT NOTE***

The following IP range should be whitelisted in your cloud/ on-premise SQL Server database so that AppiWorks Infrastructure can connect with it.

35.238.134.134