SQL Server
SQL Server can be hosted on prem or run in Azure, GCP or AWS.
Creating a connection
To connect to SQL Server, you'll need to provide the below details:
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.
Database or Schema: The schema to connect to
User: The username
Password : The password

Connecting an asset
Once a connection is defined, you can start using it to create assets. To create assets, you will need to select existing table, or run a custom SQL query.

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
Last updated