Before you connect
- A database user with read access to the tables you want to query.
- Network access from Genloop. In the Azure portal, add Genloop’s regional IP address to your server’s firewall rules. See Before you begin.
Connection fields
Encryption (TLS)
The connection is always encrypted; there is no option to turn encryption off. What you control is certificate validation:- Azure SQL — leave Trust server certificate off so the server’s certificate is validated.
- Self-hosted SQL Server with a self-signed certificate, or a tunnelled connection to a local server — turn Trust server certificate on so the connection is accepted.
Connect through an SSH tunnel
If the server is not reachable directly, reach it through a bastion or jump host. Turn on Connect via SSH tunnel in the connection form and complete these fields. When tunnelling to a local server, turn Trust server certificate on.Permissions
Genloop only reads your data. Give the connecting user read access to the tables you select; no write access is needed. A minimal grant looks like this:Next steps
Connect a database
Back to the full connection flow.
Context Hub
View and edit the memory built from your connection.