Skip to content

Add SQL Server Support #720

@bobbyiliev

Description

@bobbyiliev

Feature request

We have to add support for SQL Server as a first-class resource in the Materialize Terraform provider by introducing two new resources:

  • materialize_connection_sqlserver
  • materialize_source_sqlserver

This aligns with the native SQL Server support now available in Materialize:

https://materialize.com/docs/ingest-data/sql-server/

Tasks:

  • Implement materialize_connection_sqlserver resource
  • Implement materialize_source_sqlserver resource
  • Add unit tests for both resources
  • Add integration tests
  • Add acceptance tests
  • Update provider documentation and examples

Motivation:

Materialize now supports ingesting data from Microsoft SQL Server using CDC. Adding Terraform support will let users declaratively configure SQL Server connections and sources like they can with PostgreSQL and MySQL.

References:

Note: Keep in mind the #693 PR as well and how things might be connected.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions