Read more about the SQL Server Integration in our docs.
Accessing SQL Server in Glide
SQL Server as a data source is available to Business and Enterprise customers only.
SQL and Updates Consumption
SQL data sources consume updates only when you actively modify data within your Glide app (add, edit, or delete operations). Routine syncing and querying operations do not use up your Glide app's allotted updates. Changes that result in adding, editing, or deleting data from either Glide or the connected SQL database will accrue updates.
Read more about Updates.
Supported Versions of SQL Server
Glide currently does not distinguish between different versions of SQL Server. For the best performance and compatibility, it’s recommended to use the latest version of SQL Server.
Locating Configuration Credentials
When setting up SQL Server with Glide, you will need the correct configuration credentials, which include the username, password, host, and database name. These are typically found within your hosting platform’s database access settings or provided as a connection string.
Configuring IP Allowlist for SQL Server
If your SQL Server host platform requires an IP address to be added to the allowlist for security reasons, you should add Glide’s IP address: 34.133.75.11.
SQL Server Security
Most hosted platforms use certificates that have been signed by trusted root certificate authorities. Glide's platform supports such certificates in addition to certificates issued by AWS RDS service.
Users of Google CloudSQL should utilise the CloudSQL specific integration as it will make use of Google Cloud Platform APIs in order to connect using secure ephemeral certificates.
If you are self-hosting your database and don't have the ability to acquire a root signed certificate (or your host doesn't provide one) you will need to disable TLS certificate verification at this time.
Adding Multiple SQL Server Databases
You can integrate multiple SQL Server databases in one Glide app. Here’s how to add additional databases:
Open your Glide app and go to the App Settings menu.
Select “Integrations.”
Select “Add” and choose SQL Server from the list.
Enter the required details for your new database connection.