Sink for MicrosoftSQL DB

[bossenti]

Body

Base on a feature request in #1236, we want to extend our family of data sinks with one for MicrosoftSQL databases.
This sink should be able to store data from a StreamPipes data stream to a MicrosoftSQL database. Thereby, at least basic authentication should be available, ideally we could even provide SSL-secured connections.

If there is JDBC client library available (license must be applicable, ideally Apache License), then we can make use of the existing JDBC implementation for sinks, see for reference the PostgreSQL sink.

Please see also our tutorial on how to implement new sinks: https://streampipes.apache.org/docs/docs/extend-tutorial-data-sinks.html

Mentoring

As this issue is marked as good first issue: one of @dominikriemer, @tenthe, or @bossenti are happy to provide help for getting started, just tag (one of) them if you want to start working on this issue and need some help.
This issue is ideal for people that are interested in getting started with StreamPipes and its SDK.

StreamPipes Committer

I acknowledge that I am a maintainer/committer of the Apache StreamPipes project.

[deexidee]

can help on this one

[bossenti]

great 🙏🏼
In case you need any help, feel free to approach us @deexidee
You can find a tutorial on how to write StreamPipes sinks in our documentation: https://streampipes.apache.org/docs/docs/extend-tutorial-data-sinks.html