SQL Server
Query a Microsoft SQL Server database. Review required fields, credential setup and how this connector works in Zild.
Query a Microsoft SQL Server database.
Where to configure
Open Zild Admin → Integrations → Connectors, find the provider and use Configure or Edit. Enter the data from this guide, enable the connector for the workflow and save.
Required fields
These requirements are the data needed by the workflow using the connector. Generic saving may accept empty fields that are only required when an operation runs. Saving does not confirm that the provider accepts the credential.
| Field | Workflow requirement |
|---|---|
ConnectionString | Connection with the server, database and authentication supplied by your administrator. |
Format example with placeholder values:
Server=HOST,1433;Database=DATABASE;User ID=USER;Password=PASSWORD;Encrypt=True;TrustServerCertificate=FalseHow to obtain credentials
- Ask your administrator for the host, port, database and a user with access to the required queries.
- Build the string in the driver’s format and enter it in ConnectionString. There is no API key to generate.
How it works in Zild
The API uses System.Data.SqlClient in execute-query. Authentication and permissions come from the connection string; also configure network access to the server.
How to verify the configuration
After saving, use the matching workflow (query, agent, call or processing) to verify access. If it fails, check the credential, permissions and selected provider resource. For limited or legacy types, confirm availability with your administrator before use.
When editing, Zild displays protected credentials as asterisks. Preserve the masked value to keep the current credential or paste a new credential to replace it.