Skip to main content

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

connectionConnection string for the SQL Server database. Example: sqlserver://username:[email protected]:1433/databaseYes
tableThe table the destination connector should write to, by default. Example: ordersYes

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.