SQL Server

What is 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. 

What is AppiWorks integration with SQL Server?

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.

Setup and Configuration

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


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

How to establish a connection?

Note: You can find the credentials while setting up the configuration in cloud providers (check the Setup & Configurations section above)

Troubleshooting and Support