SQL Server
SQL Server can be hosted on prem or run in Azure, GCP or AWS.
To connect to SQL Server, chose it's icon from the list of available connections which will open the following dialog
Fill in following details in the form. We use Azure SQL service as an example here:
Server: The server name. It can be found in Azure Portal: SQL Server -> Server Name -> Overview -> Server Name
Database: The database name. This can be found in the Azure Portal at the following location: SQL Server -> Server Name -> Overview -> Available Resources -> (x) databases. Pls choose the appropriate database to connect to from this list
Database or Schema: The schema to connect to
User: The username
Password : The password
Note:
The User and Password above are for the SQL Authentication.
In order to connect to a privately hosted instance, the customer will need to whitelist the IPs from Telmai. Please reach out to Telmai support for the updated list of IP’s for whitelisting.
Data Types Supported:
JSON data type is not supported for SQL Server connections out of the box. Please reach out to Telmai support if it needs to be enabled
Please ensure that your environment has whitelisted Telmai IP list.
Last updated