Microsoft SQL Server
The Conduit Platform by default supports Microsoft SQL Server as a source and a destination.
The Microsoft SQL Server destination can connect to and produce records to a table.
Required Configurations
| Name | Description | Required | Default |
|---|---|---|---|
connection | Connection string for the SQL Server database. Example: sqlserver://username:[email protected]:1433/database | Yes | |
table | The table the destination connector should write to, by default. Example: orders | Yes |
Upsert Behavior
The destination connector takes an sdk.Record and parses it into a valid SQL query.
Table Name
If a record contains a sqlserver.table property in its metadata it will be inserted in that table, otherwise it will fall back to use the table configured in the connector. Thus, a Destination can support multiple tables in a single connector, as long as the user has proper access to those tables.