Update SQL Server Data with WIX

You can connect to an external database .

Or, if your SQL Server has an external API, then you can use the API to submit queries to the database. Here is some material that will help you with that: