SQL Server
Read and write Microsoft SQL Server: self-hosted, or managed on Amazon RDS or Azure SQL. Browse to a table or write your own SQL; the builder shows a query's columns without running it.
Settings
What the connection form asks for. Every connection has a Staging side, which it needs, and an optional Production side with values of its own; both ask for the same settings.
| Host | |
| Port | Blank uses 1433. |
| Database | |
| Encryption | Managed services (Amazon RDS and Aurora, Cloud SQL, Azure Database) accept verify-full with no extra setup. Use require for a server with a self-signed certificate. Choices: Require encryption; Require encryption, verify certificate and hostname; Require encryption, verify certificate; Encrypt if the server offers it; No encryption. |
| Sign in with | Choices: SQL Server login. |
| Username | Shown when Sign in with is SQL Server login. |
| Password | Shown when Sign in with is SQL Server login. Stored encrypted, and never shown again after you save it. |
Testing the connection
Test connects, signs in with the SQL Server login and runs SELECT 1, giving up after 10 seconds.
Good to know
- If the server sends the sign-in on to another address, as Azure SQL does under its Redirect connection policy, Trinium follows it once.
- Encryption has five settings, from no encryption to verifying the certificate and the hostname.
- A query's columns show in the builder without running it.
Nodes that use it
Look up each row's keys in a database table and add the matching row's columns.
Read a table or SQL query from Microsoft SQL Server. A Bookmark can read only the rows added or changed since the last successful run.
Load rows into a SQL Server table. Turn on All or nothing and a load that fails leaves the table as it was.